All articles with 'Mode.mult()' Tag
![Lookup most frequent item [Homework]](https://chandoo.org/wp/wp-content/uploads/2017/02/most-frequent-lookup.png)
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?
Continue »{ 17 Comments }
Formula Forensics No. 030 – Extracting a Sorted, Unique List, Grouped by Frequency of Occurrence
Published on Oct 4, 2012 in Formula Forensics, Posts by Sajan
![Formula Forensics No. 030 – Extracting a Sorted, Unique List, Grouped by Frequency of Occurrence](https://chandoo.org/wp/wp-content/uploads/2012/10/Extracting-a-sorted-unique-list-grouped-by-frequency-Master.png)
Today at Formula Forensics, Guest author Sajan shows us how to extract a sorted, unique list of items, displaying the most frequently occurring items first, while restricting the output based on some additional criteria.
Continue »