Automatic count for filtered items

  • Thread starter Thread starter mbparks
  • Start date Start date
M

mbparks

How can I assure that the count of filtered items will appear in the lower
left corner in Excel when I apply a filter to a column. I do not want to
have to highlight the column to get the count.

Thank you for your time.
 
Put your worjksheet calculation in manual. If you have formulas in yoru
workbook, they will calculate on filterand wipe out your count.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make the record count always show when using filters... 1
Auto filter count 3
Filter doesn't show record count 5
Data Lookup Question 1
Counting Subtotal 4
Counting Filtered Results Using Autofilter 2
filter count 3
auto count from autofilter 1

Back
Top