Blank cells

**SalamanderSam14** · 01-05-2012, 10:18 AM

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

**jeffreybrown** · 01-05-2012, 10:21 AM

Please take a few minutes to read the Forum rules and revised the title of your thread.

**tom1977** · 01-05-2012, 10:28 AM

look at attachment

**OnErrorGoto0** · 01-05-2012, 10:42 AM

=LOOKUP(1E+100,A$1:A3)+1
should work I believe.

**SalamanderSam14** · 01-06-2012, 04:30 AM

thanks both for your comments i have used the lookup formula and that works fine

**teylyn** · 01-06-2012, 04:35 AM

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