repeat entry based on value in cell
Hi Folks!
I'm helping someone over in the .Functions group. It's a data extraction
problem.
Here's what we have:
................header1.....header2.....header3... ..Count
Data1.......date1.........date2........date3...... .....2
Data2.......date1.........date2........date3...... .....1
Data3........................date2........date3... .........0
Data4.......date1........date2.................... .........2
Data5.........................................date 3............1
The count column is the numbers of dates that Data(n) meets a criteria, the
month number.
We need to create a list of Data(n) that repeats based on the number in the
Count column. Like this:
Data1
Data1
Data2
Data4
Data4
Data5
I can do this with a couple of helper formulas but it is a real PITA and is
the hardest part of solving this problem. We need this list output to a
different sheet.
Thanks!
Biff
|