Find Duplicate in column and delete first:

[mattress58]

I need to go do column "C" and delete the rows that have duplicates. I need to keep the last one though.

So if in cell C5 there is "Hilo" and "Hilo" is also in C10 row 5 is deleted. I even dont need the row delete really. I coul just delete the vale in C5 in this example. Either/ OR

Thanks for help

[sktneer]

Try this and see if this is what you want.

Please Login or Register  to view this content.