filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi and sorry for my english
when i use the authomatic filter i need that the results are numbered in a
near column.
Is it possible?
 
zolabus,

For example, insert a new column A, and put this formula into cell A2

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

Then copy down to match your unfiltered list. When you filter, the numbers will update.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

VBA to Filter on variable column 5
count & If fomula 5
need help on either doing a loop and counting specific values orusing subtotal function 2
Filtering Using Values In A Specific Cell 3
Select rows which satisfy 2 criteria 16
Excel Filter Listview userform VBA 0
Macro to copy value in field and insert it into filter 2
Formula to sum the digits 14

Back
Top