| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbering rows in a filtered worksheet
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!?! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
numbering rows in a filtered worksheet
Select the exact range of cells you wish to filter before you apply your
filter. -- David Biddulph "olga" wrote in message ... 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!?! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
numbering rows in a filtered worksheet
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 On Tue, 13 Feb 2007 11:34:01 -0800, olga wrote: 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!?! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
numbering rows in a filtered worksheet
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 DataSubtotal feature. When you choose to Remove Subtotals, it deletes the lines that contain a Subtotal formula. olga wrote: 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!?! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Numbering rows in a worksheet | Excel Worksheet Functions | |||
| How do I do numbering of rows in Excel when there are blank rows? | Excel Discussion (Misc queries) | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| Why does # of filtered rows appear in status bar only sometimes? | Excel Discussion (Misc queries) | |||
Linear Mode
