| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula results in the status bar
I have a worksheet (not mine) which has filters. When I filter I see the
result ( number of filtered rows) e.g., 11 of 336 rows - in the status bar. How do I get this feature in a spreadsheet I build from scratch? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula results in the status bar
The status bar numbers are the counts of rows which satisfy the filtered
criteria Example 1 - single criteria counts In C1: =COUNTIF(A:A,"Pete") will return the same number if you had filtered col A for "Pete" Example 2 - dual criteria counts In C1: =SUMPRODUCT((A2:A10="Pete")*(B2:B1010)) will return the same number if you had filtered col A for "Pete" AND col B for values greater than 10 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Matt S" wrote: I have a worksheet (not mine) which has filters. When I filter I see the result ( number of filtered rows) e.g., 11 of 336 rows - in the status bar. How do I get this feature in a spreadsheet I build from scratch? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula results in the status bar
hi
per microsoft, it's buit in. are you having problems somehow? look here? http://support.microsoft.com/kb/213886 regards FSt1 "Matt S" wrote: I have a worksheet (not mine) which has filters. When I filter I see the result ( number of filtered rows) e.g., 11 of 336 rows - in the status bar. How do I get this feature in a spreadsheet I build from scratch? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula results in the status bar
It's easy when you know how. Thanks for the help!
"FSt1" wrote: hi per microsoft, it's buit in. are you having problems somehow? look here? http://support.microsoft.com/kb/213886 regards FSt1 "Matt S" wrote: I have a worksheet (not mine) which has filters. When I filter I see the result ( number of filtered rows) e.g., 11 of 336 rows - in the status bar. How do I get this feature in a spreadsheet I build from scratch? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I set the status bar to count results from filter? | Setting up and Configuration of Excel | |||
| Filter Results in Status Bar | Excel Discussion (Misc queries) | |||
| How do I get the filter results to show up in the status bar? | Excel Discussion (Misc queries) | |||
| Auto filter not displaying number of results in status bar. | Excel Discussion (Misc queries) | |||
| how do i set results to appear in status bar of excel | Excel Discussion (Misc queries) | |||
Linear Mode
