renumbering a column

  • Thread starter Thread starter mangchik
  • Start date Start date
M

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel, How do I make column A renumber itself if I remove a row? 1
Sort and Renumber 4
Excel Column Renumbering Question 3
Renumbering footnotes 8
Running a Code multiple times 2
Pivot Table Calculated Fields 4
Problems with AutoFilter macro 2
Help with autofilter and filtering a specific column 1

Back
Top