Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Count Text & return higest value



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



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.