Hi, first time using this forum, so here goes..
I have a large data sheet containing a column of numbers, some of which are repeated, i am trying to identify these as 'multiples' as some will appear twice, three times or more and some just once.
I need to keep the matches in the order they originally appear on so that the data in other columns remains in place.
I have seen once before a way to comapre the data using a simple formula so that when a number appears more than once it is shown in another column 1, 2, 3 etc depending on the number of times it appears.
Anyone able to help how this is achieved?
Bookmarks