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 above.
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?
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)
Today we look at the third place winner from our inaugural Formula Challenge, a neat solution provided by Sajan.