Index Match & Duplicates

[werko]

Hello!

Need help with this formula, what i'm trying to achieve is to avoid duplicate items if the qty is the same.

[benishiryo]

hi werko. does the position of the ties matter? if not, try this array formula:

=INDEX(Sheet2!$A$1:$A$5,MATCH(LARGE(Sheet2!$E$1:$E$5+ROW(Sheet2!$E$1:$E$5)/10000,ROWS(A$1:A1)),Sheet2!$E$1:$E$5+ROW(Sheet2!$E$1:$E$5)/10000,0))

if it does, then:

=INDEX(Sheet2!$A$1:$A$5,MATCH(LARGE(Sheet2!$E$1:$E$5+(ROW($A$6)-ROW(Sheet2!$E$1:$E$5))/10000,ROWS(A$1:A1)),Sheet2!$E$1:$E$5+(ROW($A$6)-ROW(Sheet2!$E$1:$E$5))/10000,0))

[werko]

benishiryo

Your formulas woks either

Thanks!!!

[werko]

Thanks, benishiryo

I found this formula and it seems to work.

=INDEX(Sheet2!$A$1:$A$5,MATCH(LARGE(Sheet2!$E$1:$E$5-ROW(Sheet2!$E$1:$E$5)/10^5,1),Sheet2!$E$1:$E$5-ROW(Sheet2!$E$1:$E$5)/10^5,0)) ends with: Ctrl+Shift+Enter

But i'll try yours too.