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 (e-mail address removed)
 
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

(e-mail address removed)

| 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 (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Referencing cells in consecutive rows 2
Row reference for consecutive series calculation 0
Duplicate entry in a column/row 14
Duplicate hashtags in OneNote 0
Vlookup of specific text, then in consecutive rows 9
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
"Cross"-Auto filling: consecutive columns into rows 1

Top