Excel

Solved/Closed
dush09
Posts
8
Registration date
Monday February 4, 2013
Status
Member
Last seen
February 11, 2013
- Feb 4, 2013 at 01:58 AM
dush09
Posts
8
Registration date
Monday February 4, 2013
Status
Member
Last seen
February 11, 2013
- Feb 6, 2013 at 06:31 AM
Hello,

My question is about EXCEl Sheet.

If the cell B2 is equal to any value (numbers/text) then cell A2 = (A1 + 1) if not then keep it Blank (No value or space).

Waiting for a reply...

Thanks,
Dushyant.

2 replies

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
68
Feb 5, 2013 at 10:02 AM
Hi Dushyant,

Put this formula in Cell A2 of your sheet:

=IF(B1<>"",A1+1,"")

Check if this gives you the desired values in Cells.

Do reply with results.
1
dush09
Posts
8
Registration date
Monday February 4, 2013
Status
Member
Last seen
February 11, 2013
3
Feb 6, 2013 at 06:31 AM
Hey Zohaib,

Thanks a Lot man It it working as per the question !!!

Thanks and Regards,
Dushyant
0