Autofill help

sonnydkij

New Member
Joined
Jun 2, 2008
Messages
12
Hi Guys,

I have over 3000 rows of payment informations and I filtered in down to 91. I am trying to put reference numbers in descending order in those selected row. Since I have hidden rows, it is screwing up the autofill. How can I autofill only in the visible rows, not in the hidden rows? Do I need to manually type in 1 through 91? I hope there's a better way. Thank you so much for your help.

SDK
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
so it's just the numbers 1 to 91 (or 91 to 1)?

Are you going to print them?

I'm just thinking there's a way of doing this on the unfiltered data using formulas, that will update when you apply the filter.

Unfiltered, place an extra column in your table

Say it's column A, you have headers on row 1, so your data starts in row 2 and goes to row 3000

put the following formula in A2 and copy to the bottom of your data

Code:
=SUBTOTAL(3,$B$2:$B$3000)-SUBTOTAL(3,B2:$B$2)+1

When you apply your filters, you should end up with sequential numbering.

Hope that helps
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,313
Members
414,052
Latest member
Dual Showman

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
Top