Re: Count Text & return higest value

Here's one way:

If your letters are in a single column beginning in cell A1, add a formula
in the column to the right:

W    @code(A1) [and copy down]
S
G
G
V

Then the formula @char(@mode(B1..Bn)) will give you the desired result.

Another way would be to do a /(D)ata(Q)uery(E)tract with the formula
@COUNT(fieldname) in one of the output fields.


"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.
>
> Pete