G
GrtArtiste
I use a spreadsheet with a column (H) in which single digits (usually
0 through 6)
are entered beginning in row 11. The most recent entry is in row 804
and there
will be an unknown number of additional entries. I need a formula
which will
show the number of times that a certain value (for example, 2) has
been entered
in the column. In addition, it would be helpful if a second formula
could show the
result as a percentage of the total number of entries in the column.
Any tips on how to proceed? I’m using MS Excel 2003. Thanks for any
assistance.
GrtArtiste
0 through 6)
are entered beginning in row 11. The most recent entry is in row 804
and there
will be an unknown number of additional entries. I need a formula
which will
show the number of times that a certain value (for example, 2) has
been entered
in the column. In addition, it would be helpful if a second formula
could show the
result as a percentage of the total number of entries in the column.
Any tips on how to proceed? I’m using MS Excel 2003. Thanks for any
assistance.
GrtArtiste