View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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