I have 1,2,3,4,5 for cells A2,B2,C2,D2, and E2. I'm trying to figure a function wherein the first cell on row 2 that contains a number will result in ABC for A1 and the rest (i.e. B1,C2,D2,and E2) will result in ZZZ.

See image for clearer explanation.

Thanks guys.

Hi,

Am Fri, 8 Nov 2013 22:52:16 +0000 schrieb managingcrap:

I have 1,2,3,4,5 for cells A2,B2,C2,D2, and E2. I'm trying to figure a
function wherein the first cell on row 2 that contains a number will
result in ABC for A1 and the rest (i.e. B1,C2,D2,and E2) will result in
ZZZ.

in A1 try:
=IF(COUNTIF($A$2:A2,"0")=1,"ABC",IF(COUNTIF($A$2: A2,"0")1,"ZZZ",""))
and drag to the right


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2