You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"XLFanatico" wrote in message
...
Yes, exactly the needed answer Sir.
Thank you.


"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"XLFanatico" wrote in message
...
Thanks Sheelo but did not do what I need.
If it can't be done, then can't be done.
Thanks.
"Sheeloo" wrote:

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" wrote:

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.