count and match
 

Excel 2007

I have a spreadsheet with 7 columns and 253 rows, one of the columns has a
checkmark if the person responded. I want to filter out all the checkmarks
and do a count on these and put these on a black spreadsheet and leave the
original in tact. I cannot figure this out in excel 7, please help.

count and match
 

We need to know what you're using for a checkmark...

"Pammy" wrote:

Excel 2007

I have a spreadsheet with 7 columns and 253 rows, one of the columns has a
checkmark if the person responded. I want to filter out all the checkmarks
and do a count on these and put these on a black spreadsheet and leave the
original in tact. I cannot figure this out in excel 7, please help.

count and match
 

the font marlett and a checkmark is when I type lower case b

"Bob Umlas, Excel MVP" wrote:

We need to know what you're using for a checkmark...

"Pammy" wrote:

Excel 2007

I have a spreadsheet with 7 columns and 253 rows, one of the columns has a
checkmark if the person responded. I want to filter out all the checkmarks
and do a count on these and put these on a black spreadsheet and leave the
original in tact. I cannot figure this out in excel 7, please help.

count and match
 

Excel 2007 Advanced Filter
No need to identify symbol.
http://www.mediafire.com/file/z1eetwwlgmx/11_18_09.xlsx