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)


"muddan madhu" wrote in message
...
sorry for that

may be this one

=INDEX({"single";"double";"triple";"quad"},MAX(COU NTIF(A1:D1,A1:D1)))

use ctrl + shift + enter



On Dec 8, 10:45 am, "Rick Rothstein"
wrote:
I don't think that formula works if the repeated cell is not the first
cell.
Put these values in columns A thru D and try it out...

A B C D
1 2 3 3

--
Rick (MVP - Excel)

"muddan madhu" wrote in message

...

try this

=INDEX({"single";"double";"triple";"quad"},COUNTIF (A1:D1,A1:D1))

use ctrl + shift + enter

On Dec 8, 6:44 am, budward wrote:
I need a formula that does the following. Is this possible?(complete
noob!)

If no numbers match "SINGLE"..If two numbers match "DOUBLE"…If three
numbers match "TRIPLE"… All four numbers match "QUAD"

7 4 2 7 DOUBLE
1 9 6 7 SINGLE
2 3 0 1 SINGLE
8 7 8 2 DOUBLE
3 6 5 9 SINGLE
2 7 7 7 TRIPLE
9 9 7 9 TRIPLE
3 4 0 4 DOUBLE
1 1 7 6 DOUBLE
7 9 5 3 SINGLE
1 1 1 1 QUAD

--
budward