display is not zero

  • Thread starter Thread starter marksuza
  • Start date Start date
M

marksuza

I am having trouble with the 'not' in a statement. I have a column an
at the end of the column I want to display the last number if not zero
I thought about an index with an if function but I cannot get the 'no
zero' criterium in. Can anybody help me? thanks.

Marco
 
Hi Marcos
to get the last number you may use the following (for column A)
=INDEX(A1:A1000,MAX(IF(A1:A1000<>0,ZEILE(A1:A1000),0)))
Enter as array formula (with CTRL+SHIFT+ENTER)
 
ZEILE? ROW?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Frank Kabel said:
Hi Marcos
to get the last number you may use the following (for column A)
=INDEX(A1:A1000,MAX(IF(A1:A1000<>0,ZEILE(A1:A1000),0)))
Enter as array formula (with CTRL+SHIFT+ENTER)
Click to expand...
 
Good morning Bob
thanks for the correction - need more coffee!!!!! <vbg>

For the OP change the formula to
=INDEX(A1:A1000,MAX(IF(A1:A1000<>0,ROW(A1:A1000),0)))
 
It was giving me ref#, but I got around the problem differently. Bu
thanks anyways.

Marco
 
Hi

this would only give a #REf error if there are no values <>0 in column
A. But you seem to have solve your issue :-)
 
Back
Top