Autofiltering then filling down numbers.

[XLFanatico]

After filtering a column( let's say by month), the A column where I have
numbers
starting by 1, the option of filling down series(right click in lower right
part of
cell) is not available anymore.
Is there another way of numbering 1 to 500 automatically( after filtering).
Tx.

 

[Sheeloo]

You can not because the filtered rows are not contiguous...

Workaround...
You can sort before filtering...

Then enter 1 in the first cell (say A6), select remaining cells and enter
=A6+1
and press CTRL-Enter

or even better
(assuming Column B is the one you want to filter on and header in row 1)
=COUNTIF($B$2:B2,B2)

and copy down

 

[XLFanatico]

Thanks Sheelo but did not do what I need.
If it can't be done, then can't be done.
Thanks.

 

[T. Valko]

It sounds like you want to sequentially number the filtered rows.

If your filter is on column B, from B3:Bn...

Enter this formula in A3 and copy down to the end of data in column B:

=SUBTOTAL(3,B$3:B3)

 

[XLFanatico]

Yes, exactly the needed answer Sir.
Thank you.

It sounds like you want to sequentially number the filtered rows.

If your filter is on column B, from B3:Bn...

Enter this formula in A3 and copy down to the end of data in column B:

=SUBTOTAL(3,B$3:B3)

 

[T. Valko]

You're welcome. Thanks for the feedback!