numbering rows in a filtered worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

olga - 13 Feb 2007 19:34 GMT

i created a cloumn (not filtered) to number each of my rows but when i filter
my rows my number column oes not stay numbered it filters along with the
others even thow its not filtered!?!

Reply to this Message

David Biddulph - 13 Feb 2007 20:17 GMT

Select the exact range of cells you wish to filter before you apply your
filter.

Signature

David Biddulph

>i created a cloumn (not filtered) to number each of my rows but when i
>filter
> my rows my number column oes not stay numbered it filters along with the
> others even thow its not filtered!?!

Reply to this Message

Gord Dibben - 13 Feb 2007 20:53 GMT

Olga

All columns on a worksheet will be filtered when any one column is filtered.

The hidden rows are the entire row, not just the column(s) you select to filter
upon.

Gord Dibben MS Excel MVP

>i created a cloumn (not filtered) to number each of my rows but when i filter
>my rows my number column oes not stay numbered it filters along with the
>others even thow its not filtered!?!

Reply to this Message

Debra Dalgleish - 13 Feb 2007 21:42 GMT

You can use a formula to calculate the row number. For example, in
column A, enter the following:
=SUBTOTAL(3,$B$2:B2)

where column B contains no blank cells.
Copy the formula down to the last row of data.

NOTE: Don't use this formula in conjunction with the Data>Subtotal
feature. When you choose to Remove Subtotals, it deletes the lines that
contain a Subtotal formula.

> i created a cloumn (not filtered) to number each of my rows but when i filter
> my rows my number column oes not stay numbered it filters along with the
> others even thow its not filtered!?!

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message