Here is an interesting problem to keep your brain cells fight boredom on this Friday & weekend.
Let’s say you have some data like this.
And you want to know, for a given customer name (in cell G4),
- What is the most frequent quantity?
- What is the most often purchased item?
How would you write formulas to get these answers?
Assume that all the data is in a table, conveniently named data. So you can access customer names by using structured name – data[Customer] etc.
[Related: Introduction to Excel Structured Referencing]
If there are ties, you may pick any one value.
Click here to download sample file with raw data.
Go ahead and post your answers in the comments.
Want more? Check out our Excel Homework problems page and get cracking.
