Cell values not displaying

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

=INDEX('sheet1'!E2:E51,COUNTA('sheet1'!E2:E51))

i've got the above in a cell. which basically looks up the
last number in the E Coloum on sheet1. However due to a
calculation being put in all E cells...
=IF(A2<>"",B2-C2,"")
....the top formula is not displaying the last number
found. in fdact it's not displaying anything. even though
th calculation in the e cell(s) returns a number.

Is there a way around this?

many thanks
 
Hi Alan
one way:
=INDEX('sheet1'!E2:E51,SUMPRODUCT(--('sheet1'!E2:E51<>"")))
HTH
Frank
 
Back
Top