I want to create a formula that will look above the row for the first cell with a value then add one to that value, for example:
A1 = "2"
A2 = ""
A3= ""
A4 = A1+1
OR
A1 = "2"
A2 = "4"
A3= ""
A4 = A2+1
I want to create a formula that will look above the row for the first cell with a value then add one to that value, for example:
A1 = "2"
A2 = ""
A3= ""
A4 = A1+1
OR
A1 = "2"
A2 = "4"
A3= ""
A4 = A2+1
Last edited by SalamanderSam14; 01-06-2012 at 06:31 AM.
Please take a few minutes to read the Forum rules and revised the title of your thread.
HTH
Regards, Jeff
look at attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
=LOOKUP(1E+100,A$1:A3)+1
should work I believe.
Good luck.
thanks both for your comments i have used the lookup formula and that works fine
Tom1977, OnErrorGoto0, AlamanderSam14
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks