| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
with Autofilter on, display count results in lower left corner wit
With Autofilter on, how can I have Excel display the count results (ex. 7 of
50) of a particular filter, WITHOUT having to have Manual Calculation on? I have had to turn AutoCalc OFF in order to see the results that typically display in the lower left corner of the application. |
|
#2
|
|||
|
|||
|
The results should appear, even if calculation is set to Manual. Perhaps
there are too many formulas in the table, as explained he http://www.contextures.com/xlautofilter02.html#Count jsky wrote: With Autofilter on, how can I have Excel display the count results (ex. 7 of 50) of a particular filter, WITHOUT having to have Manual Calculation on? I have had to turn AutoCalc OFF in order to see the results that typically display in the lower left corner of the application. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter - display column showing visible row count | Excel Discussion (Misc queries) | |||
| Display count of rows | Excel Worksheet Functions | |||
| how to display the count of lines found by autofilter? | Excel Discussion (Misc queries) | |||
| Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
| Find & Replace results to display specified chosen fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
