•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
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives
#large dataset processing
#unique count
#families
#types of produce
#pivot table