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 67
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