| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count / match | Excel Discussion (Misc queries) | |||
| Match wild cards and then count | Excel Discussion (Misc queries) | |||
| How to count the match letter within a string? | Excel Discussion (Misc queries) | |||
| Count if match any of 3 strings | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
Linear Mode
