The problem is the formula in Column AE4:AE25
=IFERROR(INDEX($AD$4:$AD$25,MATCH(AF5,AC$4:AC$25,0)),"")
I get duplicate numbers, number 5 twice and number 6 is missing.
I have searched for a solution, but the formula for duplicates I've found don't seem to work
with the way I have me numbers placed in the uploaded spreadsheet.
However I do see within the formula of Column AE:AE25 there is a way to distinguish and separate
the duplicate using a slight variation only if there are duplicates.
How can I do this ?
Thanks
Bookmarks