Excel gurus???

[ofishil]

I have a Excel question

I have this formula that I got off the internet and made it work for my application, however its not perfect. Can someone help me out?

=INDEX(F5:L5,MATCH(MAX(COUNTIF(F5:L5,F5:L5)),COUNT IF(F5:L5,F5:L5),0))

The formula gets from a row the greatest text input and inputs it into a cell.

for example if a row has

1 1 2 2 2 2

it will take the 2 (since it has the most) and input it into a cell where the formula is.

problem is when it is there are 3 1's and 3 2's.

for example if a row has

1 1 1 2 2 2

it will put 1 since it appears first.

I would rather is say "tied" or anything else to set it off from being false information.

Any help is appreciated.
Thanks

[lnester]

Put that equation above inside a nesting formula that says "If, then", where the if statement countifs the row, and the "then" part of the formula makes is equal to the other countif statement.

So:

= IF (COUNTIF(row of information, 1st choice)=COUNTIF(row of information, 2nd choice), "Tied", INDEX....

Make sense?