Count data items and display highest item

deepheat101

Board Regular
Joined
Jul 26, 2006
Messages
138
Hi There,

I have a sheet with columns A to D, and from row 2 downwards, each column contains up to 150 text values.

What I need is to display in row 1 of each column the value that appears the most in each of the four columns (I'm not interested in the actual count). If there is a "tie" for the highest count then display any one of the tied values (if it is easier, the first one alphabeticaly would be fine) - Any ideas where I start?

Many Thanks in advance
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,114,057
Messages
5,545,753
Members
410,704
Latest member
Cobber2008
Top