Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter question
when i filter data, the number of responses no longer appears in the bottom
left corner of the screen. how do i know how many items meet my filter criteria? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter question
The status bar counter is known to be unreliable. You can use the following
formula, which gives a count of data that is unfiltered (doesn't count blank cells though, so set the range to a column that always has data) =SUBTOTAL(2,A2:A100) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "katie3309" wrote: when i filter data, the number of responses no longer appears in the bottom left corner of the screen. how do i know how many items meet my filter criteria? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter question | Excel Discussion (Misc queries) | |||
Filter question? | Excel Discussion (Misc queries) | |||
Filter Question | Excel Discussion (Misc queries) | |||
a filter question | Excel Discussion (Misc queries) | |||
filter question | Excel Discussion (Misc queries) |