Eliminating duplicate records in consecutive rows of a column

L

Larry

Eliminating duplicate records in consecutive rows of a column

I have an Excel spread sheet that has 6,000 rows of text in one of the
columns. I want to be able to eliminate duplicate records.

Can this task be done automatically?

In additional to posting your solution to this group, can you please
cc: me at [email protected]
 
W

William

See replies in misc newsgroup where you posted the same question. Please
don't post the same question to multiple ngs.

--
XL2002
Regards

William

[email protected]

| Eliminating duplicate records in consecutive rows of a column
|
| I have an Excel spread sheet that has 6,000 rows of text in one of the
| columns. I want to be able to eliminate duplicate records.
|
| Can this task be done automatically?
|
| In additional to posting your solution to this group, can you please
| cc: me at [email protected]
 
Top