Excel macro, if > 0 add 1 to cell!?!?
Closed
Craig Farish
-
Apr 8, 2011 at 01:51 AM
RWomanizer
RWomanizer
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Related:
- Macro to add 1 to a cell value
- Excel add 1 if cell contains text - Guide
- Excel formula add 1 if cell contains text ✓ - Forum - Excel
- Excel macro send email to address in cell ✓ - Forum - Excel
- Excel if cell contains date then add 1 ✓ - Forum - Office Software
- Excel - macro to lookup cell and add new row - How-To - Excel
1 reply
RWomanizer
Apr 8, 2011 at 02:21 AM
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Apr 8, 2011 at 02:21 AM
hi Craig,
You can do it without using Macro,
just put the formula in Column C4 as,
=COUNTIF(A:A,">0")
you got he desired result.
Regards,
Rahul
You can do it without using Macro,
just put the formula in Column C4 as,
=COUNTIF(A:A,">0")
you got he desired result.
Regards,
Rahul