View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lemmesee Lemmesee is offline
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.