Thread: Cleaning Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AMMark AMMark is offline
external usenet poster
 
Posts: 2
Default Cleaning Data

I have a large data dump of financials that are 6 columns wide and thousands
of rows deep and is in one tab of a workbook. The data is broken up into
groups of essential data and then separated by empty space and non-essential
text. All of the data that I wish to use for calculation has a first column
that starts with a date like 1/2006. The "separator" rows do not start with
dates, they are either empty or start with text.

Without having to do it manually, I want to:

1) Count all the rows that start with dates.
2) Delete all the rows that do not.


Thanks,

Mark