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) ))
Hi Brad,
Thank you for the input. I am trying to copy the data into cell G3 in spreadsheet Final (2) from sheet Walleye JPMcopy). I put "EQUITIES" because I was unsure where to select. Please let me know if you need more information.
I want to see a copy of the actual workbook along with a small selection of the results you want to return. When looking at the formula you were trying to use, I couldn't tell where the formula was being placed. Nor could I tell what the exact name of the worksheet might be--I now see that worksheet final (2) has a closing right parenthesis, something that was missing in your original formula.
It is also not clear whether I'm supposed to return information on all the EQUITIES, or all the info that is available in worksheet Walleye JPMcopy.
When I look at your workbook, all care about is worksheets final (2), Walleye JPMcopy and whichever worksheet will be containing the formula. Similarly, all I care about on worksheet Walleye JPMcopy are columns D and L, and column L could have the numbers 1 through xx as their data. I don't need a lot of data--I used ten rows in my test workbook.
What is important is the layout. Where does the data start and end? Where does the formula go? What values do you expect the formula to return? Is the formula only supposed to return EQUITIES? Should it return other types of investments, too?
It is also not clear whether I'm supposed to return information on all the EQUITIES, or all the info that is available in worksheet Walleye JPMcopy.
When I look at your workbook, all care about is worksheets final (2), Walleye JPMcopy and whichever worksheet will be containing the formula. Similarly, all I care about on worksheet Walleye JPMcopy are columns D and L, and column L could have the numbers 1 through xx as their data. I don't need a lot of data--I used ten rows in my test workbook.
What is important is the layout. Where does the data start and end? Where does the formula go? What values do you expect the formula to return? Is the formula only supposed to return EQUITIES? Should it return other types of investments, too?