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.
Wow Brad, thank you. Do you have a Venmo or something? I definitely would like to buy you some beer for helping me out.
This was a 5 minute problem once you posted your file and said which version of Excel you use.
My pleasure to help.
Brad
