xlfn.IFERROR or IFERROR don't work in Excel 98-2003

**dj_danu01** · 07-24-2013, 10:22 AM

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

**Fotis1991** · 07-24-2013, 10:27 AM

IFERROR works in EXCEL>2003. Try using IF(ISERROR..

=IF(ISERROR(INDEX(D$2:D$162,MATCH(0,COUNTIF(E$1:E1,D$2:D$162),0))),"",(INDEX(D$2:D$162,MATCH(0,COUNTIF(E$1:E1,D$2:D$162),0))))

**dj_danu01** · 07-26-2013, 02:53 AM

I don't know why, "ISERROR(...) " is not working on my Excel.
SO i used this Macro:

Sub DeleteDups()
Dim x As Long
Dim LastRow As Long
LastRow = Range("A65536").End(xlUp).Row
For x = LastRow To 1 Step -1
If Application.WorksheetFunction.CountIf(Range("A1:A" & x), Range("A" & x).Text) > 1 Then
Range("A" & x).EntireRow.Delete
End If
Next x
End Sub