Hello
I have a column of data and I would like to count the number of cells containing only positive numbers. Also some cells have parentheses, brackets, less than symbols. I would like to exclude all these and only count cells with a positive number. Below is a typical column I would encounter. Its data from an aluminum analysis. I need to get a count of the amount of positive numbers. No cells with any characters other than positive numbers. For example this column should yield a count of 7. VBA code please.
Thanks for any help.
Tom
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
I have a column of data and I would like to count the number of cells containing only positive numbers. Also some cells have parentheses, brackets, less than symbols. I would like to exclude all these and only count cells with a positive number. Below is a typical column I would encounter. Its data from an aluminum analysis. I need to get a count of the amount of positive numbers. No cells with any characters other than positive numbers. For example this column should yield a count of 7. VBA code please.
Thanks for any help.
Tom
| Al |
| -3 |
| -3 |
| -3 |
| -3 |
| -3 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| (0.007) |
| (0.001) |
| 0.0006 |
| 0.0009 |
| 0.0014 |
| 0.002 |
| 0.004 |
| 0.02 |
| 0.065 |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
