Selecting the non blank from 4 cells...

[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 ***

 

[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: