Thanks for all of the replies.
Will try the different ways out this weekend.
Bud
Quote:
Originally Posted by Rick Rothstein
Yes, that seems to work. Similar to my previous array-entered formula (which
was one character shorter)...
=CHOOSE(MAX(COUNTIF(A1:D1,A1:D1)),"SINGLE","DOUBLE ","TRIPLE","QUAD")
I wonder if anyone has measured the efficiency of the CHOOSE function as
compared to the INDEX function?
--
Rick (MVP - Excel)
|