| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
building list from a column of data
thanks
i tried to use the formulas, then macro recording seems to fit for further more routine computation. regards, driller -- ***** birds of the same feather flock together.. Try this entered in D2. D1 is a column header (or empty cell, or just not a number) =IF(ROWS($1:1)<=COUNT(1/FREQUENCY(rng,rng)),INDEX(rng,MATCH(0,INDEX(COUNTI F(D$1:D1,rng),,1),0)),"") Copy down until you get blanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to set up building list for Banker for new farm shop | New Users to Excel | |||
| Building Pivot table from Access data | Excel Discussion (Misc queries) | |||
| Excel or Access for building front end to small data-set? | Excel Discussion (Misc queries) | |||
| Building list based on condition | Excel Worksheet Functions | |||
| self-building dropdown list | Excel Worksheet Functions | |||
Threaded Mode
