Excel

[Solved/Closed]
Report
Posts
8
Registration date
Monday February 4, 2013
Status
Member
Last seen
February 11, 2013
-
Posts
8
Registration date
Monday February 4, 2013
Status
Member
Last seen
February 11, 2013
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
8
Registration date
Monday February 4, 2013
Status
Member
Last seen
February 11, 2013
3
Hey Zohaib,

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

Thanks and Regards,
Dushyant