When value appears adjacent cell acknowledges
Closed
SJJ
-
Feb 12, 2012 at 12:20 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 16, 2012 at 09:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 16, 2012 at 09:38 AM
Related:
- When value appears adjacent cell acknowledges
- It appears that call of duty did not quit - Call of Duty (CoD) Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel send value to another cell - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 16, 2012 at 09:38 AM
Feb 16, 2012 at 09:38 AM
Hi SJJ,
Why use VBA for this?
Select column B, goto cell properties (Ctrl+1), number tab, bottom option and enter 00# in the "Type:" field.
Now enter the following formula in cell B1:
=IF(C1="","",ROW(C1))
Drag formula down as far as you like.
Best regards,
Trowa
Why use VBA for this?
Select column B, goto cell properties (Ctrl+1), number tab, bottom option and enter 00# in the "Type:" field.
Now enter the following formula in cell B1:
=IF(C1="","",ROW(C1))
Drag formula down as far as you like.
Best regards,
Trowa