Re: Count Text & return higest value

Pete - personally I'd use 5 separate @countif formulas in separate
cells then @max to find the maximum, but if you want to put it all in
one cell you can base it on:

@MAX(@COUNTIF(range,"=x"),@COUNTIF(range,"=y"),@COUNTIF(range,"=z"))