Slight adjustment:

If this formula is going to be in the same row as the table row you want
to search, use:

=IF(COUNTIF(A1:AX1,A1)1,ADDRESS(ROW(),MATCH(TRUE, A1:AX1<A1,0)),"$A$1")

Should be:

=IF(COUNTIF(A1:AX1,A1)1,ADDRESS(ROW(),MATCH(TRUE, A1:AX1<A1,0)),"$A$"&ROW())

Biff

"Biff" wrote in message
...
Hi!

cell reference

Does that mean cell address?

Assume your values are in the range A1:AX1

Entered as an array with the key combo of CTRL,SHIFT,ENTER:

=IF(COUNTIF(A1:AX1,A1)1,ADDRESS(1,MATCH(TRUE,A1:A X1<A1,0)),"$A$1")

If this formula is going to be in the same row as the table row you want
to search, use:

=IF(COUNTIF(A1:AX1,A1)1,ADDRESS(ROW(),MATCH(TRUE, A1:AX1<A1,0)),"$A$1")

Biff

"carlossaltz"
wrote in message
...

I need a formula that will compare all values in a row of 50 fields and
return the cell reference of the field that is different from the rest.
Of the 50 entries, 49 are similar and the 50th is different. The catch
is that the field that is different will not always appear in the same
column on each row in the table. The only alternative I could come up
with was to use nested IF's, however, this is cumbersome due to the
number of fields that need to be evaluated.


--
carlossaltz
------------------------------------------------------------------------
carlossaltz's Profile:
http://www.excelforum.com/member.php...o&userid=24205
View this thread:
http://www.excelforum.com/showthread...hreadid=378205