Forum Discussion
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...
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) ))
this awsome sir.
how to add more criteria like: <100 sir ?
im stuck this formula. thanks for help again.
how to add more criteria like: <100 sir ?
im stuck this formula. thanks for help again.
It's confusing when people jump into an already answered question and start asking a new one. Best practice is to post a new question.
The formula will be easy if you post a sample workbook, a description of what you want the formula to do and expected result. If you have a formula that isn't working the way you would like, put that in the workbook too so we can teach you the necessary tricks.
The formula will be easy if you post a sample workbook, a description of what you want the formula to do and expected result. If you have a formula that isn't working the way you would like, put that in the workbook too so we can teach you the necessary tricks.
- sorry sir.
I created a new topic here https://techcommunity.microsoft.com/t5/excel/index-match-function-avoid-duplicate-returns-with-criteria/td-p/3377836