Forum Discussion
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?
- Exclude duplicate entries on my comparison worksheet from reporting the sum twice . So i’m utilizing uniqiue identifiers which is A2 on Comparison sheet, but there are mutiple unique identifiers on column A. I want to remove those duplicates without interfering with the SUMIF formula
=IF(COUNTIF(Comparison!A$2:A2,Comparison!A2)>1,"",SUMIF(‘Cattle’!B:B,Comparison!A2,’Cattle’!Q:Q))
