| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to obtain the number of filtered records in Autofilter
How to switch ON the option of obtaining the total number of filtered records
when using Autofilter in Excel? In Excel, when using Autofilter option, I can read sometimes in the satus bar the number of filtered records. Often this information is missing in the lefthand side of status bar. There is a way to find the info by selecting "Count" in the right hand side of status bar but this introduce mistakes by adding title lines. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to obtain the number of filtered records in Autofilter
See how Debra Dalgleish tackles this problem with a couple of workarounds.
http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 11:26:02 -0700, Ramez wrote: How to switch ON the option of obtaining the total number of filtered records when using Autofilter in Excel? In Excel, when using Autofilter option, I can read sometimes in the satus bar the number of filtered records. Often this information is missing in the lefthand side of status bar. There is a way to find the info by selecting "Count" in the right hand side of status bar but this introduce mistakes by adding title lines. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to obtain the number of filtered records in Autofilter
Thanks very much Gord. The answers were there but mostly it explained why I
was not seeing the information (too much formulas and/or changes after filtering). I will be able to workaround it now. "Gord Dibben" wrote: See how Debra Dalgleish tackles this problem with a couple of workarounds. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 11:26:02 -0700, Ramez wrote: How to switch ON the option of obtaining the total number of filtered records when using Autofilter in Excel? In Excel, when using Autofilter option, I can read sometimes in the satus bar the number of filtered records. Often this information is missing in the lefthand side of status bar. There is a way to find the info by selecting "Count" in the right hand side of status bar but this introduce mistakes by adding title lines. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count rows in a filtered list when using AutoFilter? | Excel Worksheet Functions | |||
| how do I see more than 1000 records filtered | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do I get the number of rows that meet an autofilter criterion. | Excel Worksheet Functions | |||
| How can I make autofilter show the filtered number of rows | Excel Worksheet Functions | |||
Hybrid Mode
