Selecting the non blank from 4 cells...

D

Darin Kramer

Hi there,

Assume:
B2 = blank (formulae result is a "")
c2 = blank (formulae result is a "")
D2 = blank (formulae result is a "")
E2 = Yes

In cell A2 I need to see the result of the non blank cell between B2 and
E2, in this case an A
(Only one of the cells between B2 and E2 will ever contain a "yes", the
others will always be blank (ie "" )

Thanks!!!

Darin






*** Sent via Developersdex http://www.developersdex.com ***
 
S

Stefi

Hi Darin,

I think that you want to see in A2 which cell from B2:E2 contains "Yes". If
so, the required result in your example is E. In this case this formula does
the job:

=CHAR(65+MATCH("Yes",$B$2:$E$2,0))

If you mean something else, please, explain it!

Regards,
Stefi


„Darin Kramer†ezt írta:
 

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