| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a Condensed List from Imported Data
I have a sheet that is Data Imported from a txt file. I refresh this list
often, It has a bunch of blank rows. On another sheet I need to make a list of the data from Column A of the imported Data But I need it to be Condensed, BLANK cells Omitted. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Condensed List from Imported Data
Autofilter for non-blanks.
F5SpecialVisible cells onlyOK Copy/paste to sheet2. Gord Dibben MS Excel MVP On Thu, 15 Oct 2009 15:52:01 -0700, Lemmesee wrote: I have a sheet that is Data Imported from a txt file. I refresh this list often, It has a bunch of blank rows. On another sheet I need to make a list of the data from Column A of the imported Data But I need it to be Condensed, BLANK cells Omitted. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Condensed List from Imported Data
Hi,
What do you mean by condensed list - do you want to exclude blanks only or is there another criteria as well -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Lemmesee" wrote in message ... I have a sheet that is Data Imported from a txt file. I refresh this list often, It has a bunch of blank rows. On another sheet I need to make a list of the data from Column A of the imported Data But I need it to be Condensed, BLANK cells Omitted. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Condensed List from Imported Data
Try the below array formula..assuming that sheet1 colA is mandatory..If not
adjust to suit --Copy this to Sheet2 cell A1 and copy/drag to the right as required --Also copy down as required =IF(ROW(A1)<=COUNTIF(Sheet1!$A:$A,"?*")+COUNT(Shee t1!$A:$A),INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$1:$A $100<"",ROW(Sheet1!$A$1:$A$100)),ROW(A1))),"") If this post helps click Yes --------------- Jacob Skaria "Lemmesee" wrote: I have a sheet that is Data Imported from a txt file. I refresh this list often, It has a bunch of blank rows. On another sheet I need to make a list of the data from Column A of the imported Data But I need it to be Condensed, BLANK cells Omitted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Impossible? Condensed search results | Excel Worksheet Functions | |||
| how to create a data table from an imported graph | Charts and Charting in Excel | |||
| I do not have the List-create a list option on my data toolbar ?? | New Users to 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) | |||
Linear Mode
