Hmmm...

Here's what I get when column A (the formula column) is included in the
filter:

http://img339.imageshack.us/img339/751/filterafu4.jpg

Here's what I get when column A (the formula column) is not included in the
filter:

http://img339.imageshack.us/img339/2381/filterbid8.jpg

????

Biff

"Roger Govier" wrote in message
...
Hi Biff

Comes out as 1 2 in both cases for me, with either 2 yes's showing or 2
no's.

--
Regards

Roger Govier


"T. Valko" wrote in message
...
Also, don't include the numbered list in the filter.

Try this:

A1 = header = Count
B1 = header = Answer

B2:B5 = yes,no,yes,no

A2 = formula: =SUBTOTAL(3,B$2:B2) copied down to A5

Select B1 and apply the filter. Excel automatically includes column A in
the filter. Filter on "yes" in the Answer column. See what happens? The
last "no" is included in the filter.

Now, "show all", remove the filter. Reapply the filter selecting *only*
column B. Filter on "yes". See the difference?

Why does that happen?

Biff

"Peo Sjoblom" wrote in message
...
Also if for some reason she would filter on blanks it won't work

--
Regards,

Peo Sjoblom



"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Louise,

I should have stressed that you need to have all cells showing (the
list unfiltered, or use show all) prior to entering and copying the
formula.

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Louise,

Use this formula in cell A2:

=SUBTOTAL(3,$B$2:B2)

and copy down to match your list. It will update when filtered to
always show a correctly numbered list.

HTH,
Bernie
MS Excel MVP


"Louise" wrote in message
...
Hi all

I have a large worksheet and have set an AutoFilter on the data, to
display
the information I need, however, I now need to insert a new column
(A) and
number the entries on the filtered list as 1, 2, 3 etc.

When I enter 1 and 2, highlight them both and drag down, it doesn't
fill in
with 3, 4 etc. it gives me a list of 1's. I am presuming this is
because it
recognises the list is filtered.

Is there any way I can auto-number this filtered list?

THank you.
Louise