How to trace the last non-zero value line in a report

C

Carol Su

New member
Joined
Dec 18, 2013
Messages
6
Reaction score
0
Points
0
Hi

I need help on excel formula. I have attach a sample report..
Appreciate your time and help!

Thanks
Carol
 

Attachments

  • Excel Formula.xlsx
    12 KB · Views: 7
try
Code: 
=LOOKUP(99^99;B:B)
 
You must log in or register to reply here.
Back
Top