Lookup most frequent item [Homework]
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.
Go ahead and post your answers in the comments.
Want more? Check out our Excel Homework problems page and get cracking.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Use CTRL to make copies of worksheets quickly
|Kill NULLs – a Simple macro to save time when importing data from SQL Server »