HELP

barnsleype

New Member
Joined
Nov 24, 2005
Messages
1
CAN ANYONE HELP WITH THE FOLLOWING

I HAVE 3 RESULTS L (COLUMN Q), M (COLUMN R), H (COLUMN S)

THESE BOXES TOTAL THE NUMBER OF L'S M'S OR H'S BETWEEN COLUMNS B AND P STARTING FROM ROW 5

I WOULD LIKE COLUMN T TO SHOW WHICH ONE OCCURS MOST FREQUENTLY BUT LIKE THIS

L MOST FREQUENT = 1
M MOST FREQUENT = 2
H MOST FREQUENT = 3

HOWEVER

IF L IS EQUAL TO M OR H THEN = 1
IF M IS EQUAL TO H THEN = 2

HOPE THIS MAKES SENSE
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,298
Office Version
  1. 365
Platform
  1. Windows
Like this

Hi there,

in T5 would go:
Code:
=IF(AND(Q5>=R5;Q5>=S5);1;IF(R5>=S5;2;3))
By the way, you CAPSLOCK seems to be stuck...

Greetz,

Koen
 

Watch MrExcel Video

Forum statistics

Threads
1,118,539
Messages
5,572,786
Members
412,484
Latest member
deezina07
Top