Index Match & Duplicates

**werko** · 03-27-2015, 09:53 PM

Hello!

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

**benishiryo** · 03-27-2015, 10:47 PM

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

Formula:

Please Login or Register  to view this content.

if it does, then:

Formula:

Please Login or Register  to view this content.

**werko** · 03-27-2015, 10:58 PM

Thanks, benishiryo

I found this formula and it seems to work.

Please Login or Register  to view this content.

But i'll try yours too.

**werko** · 03-27-2015, 11:01 PM

benishiryo

Your formulas woks either

Thanks!!!

Re: Index Match & Duplicates