LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Impossible? Condensed search results LiAD Excel Worksheet Functions 8 March 30th 09 02:07 PM
how to create a data table from an imported graph pieterV Charts and Charting in Excel 2 May 10th 07 10:43 PM
I do not have the List-create a list option on my data toolbar ?? Ruthlife New Users to Excel 2 September 6th 06 02:10 PM
Want to Create a List in Excel 2002; Don't see List in Data Menu? Manoj Excel Discussion (Misc queries) 2 April 7th 06 07:34 PM
Does Excel 2002 have a List>Create List option under Data? Jesse Excel Discussion (Misc queries) 3 May 20th 05 01:52 PM


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"