Numbered, Filtered List

djl0525

djl0525

Well-known Member
Joined
Dec 11, 2004
Messages
1,240
I have a list which is filtered. The results of the filter consists of 10 rows. Is there a way to get Excel to number the results for me (1-10)?

DJ
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Sort by date Sort by votes
Let A1:B7 be the area to which you apply AutoFilter or Advanced Filter in place...

Enter a label in C1.
In C2 enter & copy down:

=SUBTOTAL(3,$A$1:A1)
 
Upvote 0
Beautiful man, just beautiful! This subtotal formula is just what I needed. I recently read the difference between subtotal and running total and I didn't get it. I get it now. I have 16,000 rows to filter so it takes a few seconds to calculate, but when it's done my results are numbered from top to bottom!

THANKS!

DJ
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Vstack, Chooserows & Dollar
2
Replies
18
Views
375
Nathan Asius
N
T
  • Question
Multiple filters on filtered list
Replies
1
Views
218
Cubist
Cubist
excelbytes
  • Solved
COUNTIFS With Lists Of Multiple Criteria
Replies
5
Views
212
Fluff
Fluff
J
  • Solved
Filter date time data so I only get one data point per hour
2 3
Replies
24
Views
502
Peter_SSs
Peter_SSs
T
  • Solved
filter function
Replies
5
Views
155
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,011
Messages
6,122,677
Members
449,092
Latest member
tayo4dgacorbanget

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top