Thread
:
Find first previous cell with data
View Single Post
#
4
Posted to microsoft.public.excel.newusers
Mark
external usenet poster
Posts: 102
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...
Reply With Quote
Mark
View Public Profile
Find all posts by Mark