View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Mark Mark is offline
external usenet poster
 
Posts: 102
Default Find first previous cell with data


Your are close but just off

=INDIRECT("I"&COUNTI(A4:A10000)) needs to be:
=INDIRECT("I"&COUNTA(A4:A10000)).

I can see why you did that but you are using the COUNTA function.
Should work now...