| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Condensed List from Imported Data
I have a sheet that has Imported Data from a test file. I refresh this data
often. The Imported data has many Blank rows. On another Sheet, I need to make a list of the Imported Data, Col A. I need the list to have the Blank Cells OMITTED. I prefer not to use AutoFilter. Is there some way that i can do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a Condensed List from Imported Data | Excel Worksheet Functions | |||
| Impossible? Condensed search results | Excel Worksheet Functions | |||
| how to create a data table from an imported graph | Charts and Charting in Excel | |||
| Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
Threaded Mode
