Return the vaslue for first cell in an array with something in it

[sobrien]

I want a formula in column Y that returns the first cell to the left in array c:x with something in it be it text or a number. The text will always be DNP yet the number could be any random number.

\For example say from C1 across was as follows:

88 54 99 101 DNP 44 (in cell Y I would want the answer to be 44)

Alternatively if the text was:

88 54 99 (in cell Y I would want the answer to be 99)

I am going to bed so apologies if I don;t thank you until tomorrw

cheers

 

[DonkeyOte]

A little confusing - I think you're saying 1st value from the right (ie last value) in which case:

Y1:
=LOOKUP(2,1/(C1:X1<>""),C1:X1)

 

[sobrien]

awesome thanks!!