ExcelBanter - Auto Filter Status Bar

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Auto Filter Status Bar (https://www.excelbanter.com/excel-worksheet-functions/58798-auto-filter-status-bar.html)

bkbrueggemann

Auto Filter Status Bar

How do I get the status bar in Auto Filter to show the number of records
returned (e.g., 122 of 335 records found)? Right now, it only changes from
"ready" to "filter mode."

Gord Dibben

Auto Filter Status Bar

Check out the info on this at Debra Dalgleish's site.

http://www.contextures.on.ca/xlautofilter02.html#Count

Gord Dibben Excel MVP

On Mon, 5 Dec 2005 10:21:02 -0800, "bkbrueggemann"
wrote:

How do I get the status bar in Auto Filter to show the number of records
returned (e.g., 122 of 335 records found)? Right now, it only changes from
"ready" to "filter mode."

bkbrueggemann

Auto Filter Status Bar

Thank you! This is exactly what I needed.

"Gord Dibben" wrote:

Check out the info on this at Debra Dalgleish's site.

http://www.contextures.on.ca/xlautofilter02.html#Count

Gord Dibben Excel MVP

On Mon, 5 Dec 2005 10:21:02 -0800, "bkbrueggemann"
wrote:

How do I get the status bar in Auto Filter to show the number of records
returned (e.g., 122 of 335 records found)? Right now, it only changes from
"ready" to "filter mode."

All times are GMT +1. The time now is 07:51 AM.