Number Visible Only Cells

[lipipe]

Hello!

I am working on renumbering a product file in excel and I need to assign new items numbers. I am filtering the products and I want to filter the results only numbering them:

00010
00020
00030 etc
00040
00050

When I try to do it with filter cells I get

00010
00020
00050

I believe I need a formula that will do my base number 00010 then add 10 for each visible cell, but I can't get it to work. I though SUBTOTAL would do it, but no luck. Please help. Thanks in advance.

Jack

 

[jasonb75]

Assuming you're starting in row 2

=TEXT(SUBTOTAL(3,A$2:A2)*10,"00000")

and fill down. Note that the column used in the formula range must not be the column holding this formula, however the column used must contain data.