Removing duplicates in IF Error Formula

[colegerald38]

Hello

I have duplicate data with my current formula


=IFERROR(INDEX('Machine'!$B$2:$B$10000,SMALL(IF('Machine'!$D$2:$D$10000=$B$5,ROW($A$2:$A$10000)-ROW($A$2)+1,""),ROWS($A$2:A2))),""

How can I amend this to avoid duplicates?

[Teblol]

I am not sure how to go about adding it to your current formula, however you can use the below formula to remove the duplicates after your current formula runs.

This code is assuming your data is sitting in column E. Paste this in column F.

Please Login or Register  to view this content.

[colegerald38]

I am not sure how to go about adding it to your current formula, however you can use the below formula to remove the duplicates after your current formula runs.

This code is assuming your data is sitting in column E. Paste this in column F.

Please Login or Register  to view this content.

How would it be incorporated in the formula? If I use that one my current code will not work

[colegerald38]

That is not working

[Teblol]

It would not be incorporated in the formula as I stated in my original comment. You can place your formula in a column, and the formula I provided in the column next to it. This will remove the duplicates.