Sorting Question in relation to numerical sequential column

[D Eckert]

Column A is a numerical sequence of 1 to 10 but I need to sort the data based on column C.

Is there a formula that will constantly reset column A to numerical sequence 1 to 10, no matter how the data after it is sorted it?

I really don't want to have to select the rows and columns excluding column A

 

[SirJB7]

Hi, D Eckert!
You have two choices:
a) exclude column A from sorted range
b) if that worksheet has n title rows, at cell A(n+1) write this formula:
=ROW()-n
Regards!

 

[bosco_yip]

Numbering in filter,

In A2, formula copy down :

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

Regards
Bosco

 

[D Eckert]

View attachment 43335

Numbering in filter,

In A2, formula copy down :

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

Regards
Bosco

Bosco, that worked perfectly. Thank you.