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 Everyone,
I have a similar problem with extracting data from different excel spreadsheets and getting duplicate values. I’m utilizing this formula but was looking for a way on how to remove all duplicate values the formula is returning
=SUMIF(‘Cattle’!B:B,Comparison!A2,’Cattle’!Q:Q)
Please help me as soon as possible
I have a similar problem with extracting data from different excel spreadsheets and getting duplicate values. I’m utilizing this formula but was looking for a way on how to remove all duplicate values the formula is returning
=SUMIF(‘Cattle’!B:B,Comparison!A2,’Cattle’!Q:Q)
Please help me as soon as possible
Formulas don't remove values. But perhaps I'm not understanding your real need.
Do you want to exclude duplicate entries on your Comparison worksheet from reporting the sum twice?
Do you want to return the corresponding value for only the first match from Cattle column B?
Do you want to exclude duplicate entries on your Comparison worksheet from reporting the sum twice?
Do you want to return the corresponding value for only the first match from Cattle column B?