Forum Discussion

Copper Contributor

Feb 22, 2020

Solved

INDEX MATCH function, avoid duplicate returns

Hi everyone! I'm working on a sheet for work. I am on my last task and can't seem to figure this one out. I'm hoping someone can help: I have a data sheet with all the data. In my current she...

excel

Formulas and Functions

SergeiBaklan
Feb 22, 2020
certavi

If you are on Excel with dynamic arrays that could be

=UNIQUE(FILTER('Horse data'!B2:B100, (I$13='Horse data'!C2:C100) * ($K$13='Horse data'!D2:D100) ))

SergeiBaklan

Diamond Contributor

Feb 22, 2020

certavi

If you are on Excel with dynamic arrays that could be

=UNIQUE(FILTER('Horse data'!B2:B100,
  (I$13='Horse data'!C2:C100) * ($K$13='Horse data'!D2:D100)
))

Hetz6366

Copper Contributor

Dec 27, 2024

I am having the same issue with duplicate returns in my formula, how can I avoid the duplicates? I added a countif and that does not work either. Any help would be greatly appreciated. =IFERROR(INDEX('Merch Square Formers'!$A$3:$A$213, SMALL(IF((D$2<$C$2)*('Merch Square Formers'!$C$3:$C$213=C$2)*('Merch Square Formers'!$C$3:$C$213<>"")+(($D$2=$C$2)*('Merch Square Formers'!$D$3:$D$213<>"")*('Merch Square Formers'!$C$3:$C$213=C$2)*('Merch Square Formers'!$C$3:$C$213<>""))*(COUNTIF($D$4:D4, 'Merch Square Formers'!$A$3:$A$213)=0), ROW('Merch Square Formers'!$C$3:$C$213)-MIN(ROW('Merch Square Formers'!$C$3:$C$213))+1), ROW()-ROW($D$4)+1)), "")