numbering rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

olga - 13 Feb 2007 20:08 GMT

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???????????????

Reply to this Message

ShaneDevenshire - 19 Feb 2007 08:45 GMT

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.

Signature

Cheers,
Shane Devenshire

> 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???????????????

Reply to this Message