•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel - Finding Unique Values for multiple criteria
Hi folks, I can't figure out the formulas or terms I need to search to make this happen. I'm trying to analyze a large data set of services my org provided (400+ rows). The image is a simplified version of the data and pivot table I could figure out so far.
I'm trying to determine two things:
1) Unique count of families who sought each type of produce? In the pivot table I can see 3 families requested apples, 3 requested bananas, 2 requested carrots but this isn't a viable approach for the actual data set.
2) How many families sought 2+ types of produce? In the pivot table, 3 families sought 2+ types of produce.
Thank you for your help!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com