All articles with 'mode()' Tag

Lookup most frequent item [Homework]

Published on Feb 17, 2017 in Excel Challenges
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?

Continue »

Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)

Published on Jul 17, 2013 in Formula Challenges, Posts by Jeff

Today we look at the third place winner from our inaugural Formula Challenge, a neat solution provided by Sajan.

Continue »