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) ))
Thank you for posting the file. Without it, I couldn't have figured out the problem.
There were actually two issues. First, the name of the worksheet wasn't Walleye JPMcopy) but rather Walleye JPMcopy (without the right parenthesis). Second, you had a dozen or so spaces following the text in Walleye JPMcopy column D. Deleting those trailing spaces made the formula as suggested work correctly.
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.