|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 18th, 2009, 03:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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. 
|
|
#2
November 18th, 2009, 04:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
|
#3
November 18th, 2009, 04:26 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
|
#4
November 18th, 2009, 05:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
count and match
Excel 2007 Advanced Filter
No need to identify symbol. http://www.mediafire.com/file/z1eetwwlgmx/11_18_09.xlsx
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
