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
|