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?
|