Excel formula to drive value in column A

[Jagdev Singh]

Hi Experts,

In the attached file under column A, I am able to derive the result. Is there any other way to deal with it.

Regards,
JD

 

[Luke M]

With that data layout, you can put this formula in A1, copy down.

=LOOKUP("zzz",B1:H1)

 

[Hui]

A1: =INDEX(B1:H1,MATCH("*",B1:H1,0))
Copy down

 

[chirayu]

http://excel.tips.net/T003785_Last_Non-Zero_Value_in_a_Row.html

 

[Deepak]

Hi JD,

Are looking for first or last non blank data as
Your formula says first
Marc says last
Hui says first
chirayu link says last

For last this might too...

=HLOOKUP("zzz",B1:H1,1,1)

 

[Jagdev Singh]

Hi All,

All the formulas are effective and fulfill my need. Thanks folks!!!