I got a list of numbers in a rows, i like to remove the duplicates numbers .
what i got.JPG
I used this formula, suggested by one of the forum member, it's worked for him. But in Excel 98_2003, it's not working.
=_xlfn.IFERROR(INDEX(D$2:D$162,MATCH(0,COUNTIF(E$1:E2,D$2:D$162),0)),"")
Anyone can explain me or give me another formula could match with Excel 98-2003?
Thank you
Bookmarks