| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Listing data without blank rows
I have an excel file with 4 work sheets.. in sheet named 'Claim sheet' i
have data (numbers and text) in cells CM10:CM1661 which is entered periodically and deleted via formula linked with other cells in other sheets, the majority of the 1661 rows are normally blank. What i need to do is on sheet named 'Statement' list (starting in cell B10) all data in 'Claim sheet' CM10:CM1661 without the blank rows. The number of rows with data should never be more than 16 at any one time, so on sheet 'Statement' the data can be listed in cells B10:B26. Any help with the right formula will be much appreciated.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| listing data without blank rows | Excel Worksheet Functions | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Copy rows of data to another worksheet where ReturnDate is blank | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
