If function..please help

M

managingcrap

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

See image for clearer explanation.

Thanks guys

+-------------------------------------------------------------------
|Filename: Excel help.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=928
+-------------------------------------------------------------------
 
C

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top