Re: Count Text & return higest value

"pys" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I have 5 text values in a range (W,S,G,VG).  I want a formula to count
> the number of occurances of each value and return the value of the one
> that occurs the most. Sounds simple, but I've tried @countif & can't
> quite find the right formula. Am working in Lotus 123.
>
There's probably a more elegant way to do this, but as you only have 5
values, can't you do a formula for each value - @COUNTIF(LIST,"w") etc,
and then do @max on your five @countif formulae?
-- 
Slartibartfast
To reply by email, remove the FJORDS from my address