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.

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.

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.

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