Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force entry into cell, based on validation selection in adjacent cell | Excel Worksheet Functions | |||
Repeat Cell Based on the Value-Excel 2003 | Excel Worksheet Functions | |||
Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
restricting entry into a cell based on entry to a previous cell | New Users to Excel |