HELP

[barnsleype]

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

 

[Rijnsent]

Like this

Hi there,

in T5 would go:

=IF(AND(Q5>=R5;Q5>=S5);1;IF(R5>=S5;2;3))

By the way, you CAPSLOCK seems to be stuck...

Greetz,

Koen