| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic count for filtered items
How can I assure that the count of filtered items will appear in the lower
left corner in Excel when I apply a filter to a column. I do not want to have to highlight the column to get the count. Thank you for your time. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic count for filtered items
Put your worjksheet calculation in manual. If you have formulas in yoru
workbook, they will calculate on filterand wipe out your count. "mbparks" wrote: How can I assure that the count of filtered items will appear in the lower left corner in Excel when I apply a filter to a column. I do not want to have to highlight the column to get the count. Thank you for your time. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic count for filtered items
As always, Thank you for your quick response. This solved the mystery.
"Sean Timmons" wrote: Put your worjksheet calculation in manual. If you have formulas in yoru workbook, they will calculate on filterand wipe out your count. "mbparks" wrote: How can I assure that the count of filtered items will appear in the lower left corner in Excel when I apply a filter to a column. I do not want to have to highlight the column to get the count. Thank you for your time. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic count for filtered items
Sorry for the spelling. Thank you for telling us it worked!
"mbparks" wrote: As always, Thank you for your quick response. This solved the mystery. "Sean Timmons" wrote: Put your worjksheet calculation in manual. If you have formulas in yoru workbook, they will calculate on filterand wipe out your count. "mbparks" wrote: How can I assure that the count of filtered items will appear in the lower left corner in Excel when I apply a filter to a column. I do not want to have to highlight the column to get the count. Thank you for your time. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic count for filtered items
Don't forget to renable auto-calc.
I would suggest a couple other workarounds that don't involve changing calculation mode back and forth. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 2 Oct 2008 10:02:07 -0700, mbparks wrote: As always, Thank you for your quick response. This solved the mystery. "Sean Timmons" wrote: Put your worjksheet calculation in manual. If you have formulas in yoru workbook, they will calculate on filterand wipe out your count. "mbparks" wrote: How can I assure that the count of filtered items will appear in the lower left corner in Excel when I apply a filter to a column. I do not want to have to highlight the column to get the count. Thank you for your time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count items in a filtered list? | Excel Worksheet Functions | |||
| items filtered | Excel Discussion (Misc queries) | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Count Filtered Visible Items that Match Numeric Criteria between two ranges | Excel Worksheet Functions | |||
| counting filtered items | Excel Worksheet Functions | |||
Linear Mode
