numbering rows

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

Guest

i need to number my rows in a seperate column to count my inventory, but when
i filter my coulmns and do a custom filter my number column filters along
with the others even if the number column is not filtered???????????????
 
If I understand your question you want to see the visible rows numbered in
sequence? If so assume your data is in column A with titles on row 1, in the
column you want the row numbers to appear (say column B for this example),
enter the following formula in cell B2:

=SUBTOTAL(3,A$2:A2)

Copy this formula down.
 
Back
Top