Count last nonzero number in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have columns of numbers, A:Z. Each column has either numbers, zero's, or
text.
I need to find the row number that has the "Last" nonzero number.

So if A1="car" , A2=0, A3=6, A4="Boat"

I would need a value of 3, the last occurence of a nonzero number (6).

Thanks for your help
 
Hi
try the following formula:
=LOOKUP(2,1/((A1:A100<>0)*(ISNUMBER(A1:A100))),ROW(A1:A100))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Loop - Please help 1
Tough conditional formatting question 8
Retun greatest # of cells between nonzero 3
Average last 3 entries 3
Counting Unique Pairs of Cells 6
Looking Up the First Nonzero Value in a Column 3
Counting non-zero cells based on date 2
First Positive in Horizontal Array 2

Back
Top