H
HeatherM
I want to count the instances of each value in a column
with various references in it(a mixture of text entries
and number entries). I would normally put an IF statement
in each of the rightmost columns that will test the cell
in the reference column and IF the cell contents = a
certain value then put 1, or 0 if the result is false. The
next column will test the cell and IF the cell contents =
another value put 1 or 0 and so on until I have a grid of
zeros with ones appearing in the appropriate column that
the reference data matches. Then I can total the columns
and know instantly how many of each reference I have,
without filtering and COUNTing the values.
But I can't do it in Excel. I keep getting the
message "There is more than one cell with this label,
Select the cell containing the label to use" How do I do
it?
with various references in it(a mixture of text entries
and number entries). I would normally put an IF statement
in each of the rightmost columns that will test the cell
in the reference column and IF the cell contents = a
certain value then put 1, or 0 if the result is false. The
next column will test the cell and IF the cell contents =
another value put 1 or 0 and so on until I have a grid of
zeros with ones appearing in the appropriate column that
the reference data matches. Then I can total the columns
and know instantly how many of each reference I have,
without filtering and COUNTing the values.
But I can't do it in Excel. I keep getting the
message "There is more than one cell with this label,
Select the cell containing the label to use" How do I do
it?