Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Find 1st non-zero cell above current cell.

Posted on 2011-04-19
3
Medium Priority
?
361 Views
Last Modified: 2012-05-11
Let's say I have a workbook where I have numbers loaded in cells A1:A6. In cell A7, I would like to load the value from the 1st cell that doesn't have a zero in looking up from cells a6 to A1. What is the formula that I would write in cell A7?
Thanks
Todd
Excel-example.JPG
0
Comment
Question by:shambalad
  • 2
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 35427639
=LOOKUP(2,1/(A1:A6<>0),A1:A6)
would do it.
0
 
LVL 7

Author Comment

by:shambalad
ID: 35427669
Man, you're fast.
Thank you very much. THis keeps me from getting stuck here at work.
Todd
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35427679
Glad to help. :)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question