UKC

excel filter counting help req

New Topic
This topic has been archived, and won't accept reply postings.
 Adders 02 Aug 2006
Excel help please.


im wanting to put an auto filter on a csv file - ok cool
now when i use a filter from one selected column i want it to count for me how many records its showing. sometimes it does and sometimes it doesnt!

ie. 100 out of 500 in bottom left corner shows when it does work but when it doesnt it says 'filter mode' or blank....

Please help!

Thanks
 TN 02 Aug 2006
In reply to Adders:

Hi! Muz is an Excel whizz - drop him an email or phone him if you don't get an answer quickly. He won't mind. In fact he'd probably enjoy a distraction from being bored...
KevinD 02 Aug 2006
In reply to Adders:

most likely is if you have added rows since creating the filter (although not sure why it would be blank).

one option would be to use the subtotal function. This gives count, sum etc (if you stick it into the help says exactly how it works).
This is what i tend to use, primarily on the grounds i would want to do things with that count inside excel.
satori 02 Aug 2006
In reply to Adders:

If you filter a list in-place in Microsoft Excel, the status bar may display the following message:
Filter Mode
This message is incorrect. Instead, the status bar should display the following message:
number of number records found
where number is the appropriate number of records.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213886

This problem may occur when the following conditions are true: • You have 51 or more formulas in a list.

-and-
• You filter the list in-place (that is, you click AutoFilter on the Data menu, and then select a value from the AutoFilter list; or you click Advanced Filter on the Data menu, click Filter the list, in-place, and then select a value from the filter list).

-and-
• Each formula contains at least one cell reference.

-and-
• Excel makes a change to the status bar to indicate the calculation of formulas before the filter process is completed.

Back to the top

WORKAROUND
To temporarily work around this problem, prevent the formulas from calculating when you run a filter. To do this, follow these steps: 1. On the Tools menu, click Options.
2. In the Options dialog box, click the Calculation tab.
3. On the Calculation tab, click Manual under Calculation.
4. Filter the list to see the filter results in the status bar.
To restore calculation, on the Tools menu, click Options. Click the Calculation tab, and then click Automatic under Calculation.
OP Adders 02 Aug 2006
In reply to satori: Genuis! thats exactly what i needed.its working now ive gone to manual.

Thanks!
dinkypen 02 Aug 2006
In reply to Adders:
> (In reply to satori) Genuis!

Is that a rare type of genius?! ;-P
OP Adders 02 Aug 2006
In reply to dinkypen: its a bad state of affairs when your only form of wit is spell checking mate.
you need a holiday!
New Topic
This topic has been archived, and won't accept reply postings.
Loading Notifications...