Try this:

Enter this column Header in B1: Name

Enter this data in B2:B6: 1;2;3;1;4

Enter this formula in A2 and copy down to A6:

=SUBTOTAL(3,B$2:B2)

Now, apply the filter...

Select cell B1
Goto the menu DataFilterAutoFilter
Excel automatically includes column A in the filter.
Filter column B on 1 and note the results.

When you apply the filter you have to make sure Excel doesn't include column
A in the filtered range.

--
Biff
Microsoft Excel MVP


"Glenn" wrote in message
...
T. Valko wrote:
Just make sure you put the formula column *outside* of the filtered
range. Otherwise, you could get incorrect filtered data.



Not sure what you mean. I didn't see any problems...