I need to delete duplicate values without losing/eliminating the rows they are in.

Hello-

I am working on a huge spreadsheet for work and I have multiple values in a column, like so:

AAA
BBB
BBB
BBB
CCC
DDD
DDD

I need it to read:
AAA
BBB


CCC
DDD


(In other words, I still need the rows intact, just the duplicate values eliminated).

Help please?

Thanks!

Depending on how many values, you could just filter it and then delete everything but the first one
For example, filter so you see:
AAA
AAA
AAA

Then just delete everything past the first AAA. Now filter by BBB only, etc. Not a great fix but would work if you don't want to use VBA and have few values

Hey all-thanks for the tips. I actually realized this morning that I could use a simple function to get it done:

=IF(A2=A1,"",A2), in column B

This gets rid of all the duplicates by returning a blank cell.

Thanks!

Just realized that my method wasn't entirely effective, as it only worked for consecutive duplicate values. I also have duplicates like this:

AAA
BBB
BBB
BBB
CC
CC
AAA
DDD

In that case, I'd need to eliminate the AAA's and the BBB's and CC's.
Also, I have realized that I don't actually remember how to implement the solution you suggested, Jeff! I'm pretty rusty on the Macro front. I'd appreciate help.

Thanks!

Thanks Jeff! Worked like a charm.

*SOLVED