in A2 have =CONCATENATE(B2, C2, D2, E2) It's not pretty, but hey.......
--
Dave


"Darin Kramer" wrote:

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