Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Formulas » VBA (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.

  • Insert Rows and Add Missing Dates

    I have spreadsheets which have dates listed in Column A with other data in subsequent columns. There may be multiples (even hundreds) of one date listed (see example below). 5-May-08 6-May-08 7-May-08 7-May-08 7-May-08 8-May-08 There are also missing dates (e.g. 1-May-08 to 4-May-08). Ultimately, I need...
    Posted to Functions and Formulas (Forum) by theCruv on Fri, Jun 20 2008

  • How Excel solves all my problems

    Last week I was on holliday and we had to divide 3 bottles of wine among ten friends. We could have written our names on little papers and draw 3 names from the lot, but why do something like that when you have a computer with excel. So I wrote a array function that returns a permutation from a set of...
    Posted to Functions and Formulas (Forum) by kaak on Thu, May 8 2008
Page 1 of 1 (2 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.