renumbering a column

[mangchik]

I have column like below

serialno requester qty
1. richard 6
2. jack 4
3. richard 3
4. jack 3

Howver once I activated "Data/Filter/Autofilter" on requestor, I wish to have the "serialno" renumbered in sequence. Tq.

Mangchik

[Tom Ogilvy]

Assume serial numbers are in column A starting in A2

in A2 put in

=Subtotal(3,$B$2:B2) & "."

then drag fill down the column.


--
Regards,
Tom Ogilvy

"mangchik" wrote:

>
> I have column like below
>
> serialno requester qty
> 1. richard 6
> 2. jack 4
> 3. richard 3
> 4. jack 3
>
> Howver once I activated "Data/Filter/Autofilter" on requestor, I wish
> to have the "serialno" renumbered in sequence. Tq.
>
> Mangchik
>
>
> --
> mangchik
> ------------------------------------------------------------------------
> mangchik's Profile: http://www.excelforum.com/member.php...o&userid=35993
> View this thread: http://www.excelforum.com/showthread...hreadid=558871
>
>

[mangchik]

Kind regards - Mangchik