Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |