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