Here’s something handy i came across the other day – i had a huge list and wanted to see duplicates so i headed off to the conditional formatting options in excel and chose to colour duplicates…
Great! Except i had a huge list that i couldn’t sit and scroll through to find them. Right clicking one of the duplicates i then spotted the filter option and low and behold there was filter by colour!
Excellent.
Hope it helps!