Trying to find all alike numbers in a column of about 5000. Data is sorted
by number already but the list it to long to look through. Filtering the
data only brings up another long list to have to go through. Is there a
formula that will find them and highlight them? There could be numerous
different ones.
Example
001-3456
001-3456
001-7890
001-7890
002-9876
002-9876
002-9787

Find all alike

Thanks