Help Tagging Data where certain criteria met

[kpaull]

Excel Workbook
	A	B	C	D	E
151	7-19-2010 0:31 PM - Data Export
152
153	7-19-2010 0:31 PM - Report for Voice System name: xyz-123 ANYWEHRE USA - list usage exten 20063
154
155
156	VDN	VDN Number	20063
157	Vector	Vector Number	939	Step	5
158	Vector	Vector Number	952	Step	5
159
160	7-19-2010 0:31 PM - Data Export
161
162	7-19-2010 0:31 PM - Report for Voice System name: xyz-123 ANYWEHRE USA - list usage exten 20064
163
164
165	VDN	VDN Number	20064
166
167	7-19-2010 0:32 PM - Data Export
168
169	7-19-2010 0:32 PM - Report for Voice System name: xyz-123 ANYWEHRE USA - list usage exten 20070
170
171
172	VDN	VDN Number	20070
173	Vector	Vector Number	870	Step	5
174
175	7-19-2010 0:32 PM - Data Export
I have this data shown below, I import it from a .csv file into Excel. Each line which begins with the date stamp and ends with "list usage exten XXXXX" is considered the start of a new record and the rows that follow until the next similar line are all part of that one record. **Note this file might be 30000 rows or greater. list usage extnesion all

#VALUE!

Excel 2007[/B]


2) Now with the data like this, I need to look through the file for any record which contains only one row (for example the record on row 159) . I want only to show those records (possibly copy them to another worksheet).

Any guidance/help would would be greatly appreciated.

Thanks in advance,
Kurtis

 

[kpaull]

Any questions on this? Did I perhaps not explain something correctly?

Should it be posted differently?

Hey, any help is appreciated.

Kurtis

 

[kpaull]

Please, I could really use this help.

Thanks!