hello
I would like to ask you if you know a way to delete duplicate lines and leave the first instance of them, but not deleting rows as well, as shown in this screenshot:
\1
thanks!
hello
I would like to ask you if you know a way to delete duplicate lines and leave the first instance of them, but not deleting rows as well, as shown in this screenshot:
\1
thanks!
You could do this quite easily with Conditional Formatting.
Please post a sample workbook instead of a picture of it.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
See the updated example.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks