Menu
All articles with '&' Tag
{ 57 Comments }
Using an Array Formula to Find and Count the Maximum Text Occurrences in a Range
Published on Oct 31, 2011 in Excel Howtos, excel links, Formula Forensics, Huis, Learn Excel, Posts by Hui
Chandoo is off on Holidays and once again thrown me the keys to Chandoo.org.
So this week we’re going to:
- Pull apart an Array Formula and see what’s under the hood;
- Have a look at a technique for quickly developing Custom Number Formats &
- Look at how we can use HTML Codes in posts at Chandoo.org to spice up your questions and answers.
Today is Tarun’s Problem
“I have got multiple names in each row and would like to have what name is repeated maximum number of times and how many times?”
Today we pull apart an answer to this question and see how it works.
Continue »
