Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding data amongst empty cells
Hi all
I have a column with 1,000 rows but only 10 of the rows contain any data and they are spread out across the 1,000. On a seperate sheet I want to list those 10 in a row together but I don't want to copy all 1,00 across and use data sort as it needs to be formula based. Any ideas?! -- James. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting data to next available empty cells | Excel Discussion (Misc queries) | |||
Count Only Empty Cells AFTER Cells with Data | Excel Worksheet Functions | |||
Finding days between cells C and L where the cells may be empty | Excel Worksheet Functions | |||
Data validation and empty cells | Excel Discussion (Misc queries) | |||
data in empty cells | Excel Worksheet Functions |