Excel

Solved/Closed
dush09 Posts 8 Registration date Monday 4 February 2013 Status Member Last seen 11 February 2013 - 4 Feb 2013 à 01:58
dush09 Posts 8 Registration date Monday 4 February 2013 Status Member Last seen 11 February 2013 - 6 Feb 2013 à 06:31
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.
Related:

2 responses

Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 69
5 Feb 2013 à 10:02
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.
dush09 Posts 8 Registration date Monday 4 February 2013 Status Member Last seen 11 February 2013 3
6 Feb 2013 à 06:31
Hey Zohaib,

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

Thanks and Regards,
Dushyant