| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbering rows
How can I number rows but omit any hidden rows from the numbering sequence?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering rows
Hi,
This assumes your have date in column B that you will filter. Put this in A2 and fill down and it will number the rows and auto update if you change the filter. =SUBTOTAL(3,B$2:B2) Mike "nbslarson" wrote: How can I number rows but omit any hidden rows from the numbering sequence? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering rows
I may not be clear. I have information in rows 1,2,3,4. Row 5 is hidden.
Information in row 6,7,8,9,10. I want the numbering to exclude the hidden row 5 so that the unhidden rows will be numbered: 1,2,3,4,5,6. . . "Mike H" wrote: Hi, This assumes your have date in column B that you will filter. Put this in A2 and fill down and it will number the rows and auto update if you change the filter. =SUBTOTAL(3,B$2:B2) Mike "nbslarson" wrote: How can I number rows but omit any hidden rows from the numbering sequence? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering rows
Had you tried my suggestion you would have found that is exactly what it does.
"nbslarson" wrote: I may not be clear. I have information in rows 1,2,3,4. Row 5 is hidden. Information in row 6,7,8,9,10. I want the numbering to exclude the hidden row 5 so that the unhidden rows will be numbered: 1,2,3,4,5,6. . . "Mike H" wrote: Hi, This assumes your have date in column B that you will filter. Put this in A2 and fill down and it will number the rows and auto update if you change the filter. =SUBTOTAL(3,B$2:B2) Mike "nbslarson" wrote: How can I number rows but omit any hidden rows from the numbering sequence? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering rows
Thank you, Mike. I did try your suggestion before I wrote the last post.
When I do that, the hidden rows are still included in the "numbering" sequence of the un-hidden rows. "Mike H" wrote: Had you tried my suggestion you would have found that is exactly what it does. "nbslarson" wrote: I may not be clear. I have information in rows 1,2,3,4. Row 5 is hidden. Information in row 6,7,8,9,10. I want the numbering to exclude the hidden row 5 so that the unhidden rows will be numbered: 1,2,3,4,5,6. . . "Mike H" wrote: Hi, This assumes your have date in column B that you will filter. Put this in A2 and fill down and it will number the rows and auto update if you change the filter. =SUBTOTAL(3,B$2:B2) Mike "nbslarson" wrote: How can I number rows but omit any hidden rows from the numbering sequence? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering rows
Try =SUBTOTAL(103,B$2:B2)
which accounts for manually hidden rows and rows hidden by filtering. 2003 and later versions. Gord Dibben MS Excel MVP On Thu, 29 Oct 2009 12:13:02 -0700, nbslarson wrote: Thank you, Mike. I did try your suggestion before I wrote the last post. When I do that, the hidden rows are still included in the "numbering" sequence of the un-hidden rows. "Mike H" wrote: Had you tried my suggestion you would have found that is exactly what it does. "nbslarson" wrote: I may not be clear. I have information in rows 1,2,3,4. Row 5 is hidden. Information in row 6,7,8,9,10. I want the numbering to exclude the hidden row 5 so that the unhidden rows will be numbered: 1,2,3,4,5,6. . . "Mike H" wrote: Hi, This assumes your have date in column B that you will filter. Put this in A2 and fill down and it will number the rows and auto update if you change the filter. =SUBTOTAL(3,B$2:B2) Mike "nbslarson" wrote: How can I number rows but omit any hidden rows from the numbering sequence? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering rows
try using 9 instead of the 3 in the formula Mike gave you:
=SUBTOTAL(9,B$2:B2) "nbslarson" wrote: Thank you, Mike. I did try your suggestion before I wrote the last post. When I do that, the hidden rows are still included in the "numbering" sequence of the un-hidden rows. "Mike H" wrote: Had you tried my suggestion you would have found that is exactly what it does. "nbslarson" wrote: I may not be clear. I have information in rows 1,2,3,4. Row 5 is hidden. Information in row 6,7,8,9,10. I want the numbering to exclude the hidden row 5 so that the unhidden rows will be numbered: 1,2,3,4,5,6. . . "Mike H" wrote: Hi, This assumes your have date in column B that you will filter. Put this in A2 and fill down and it will number the rows and auto update if you change the filter. =SUBTOTAL(3,B$2:B2) Mike "nbslarson" wrote: How can I number rows but omit any hidden rows from the numbering sequence? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbering Rows | Excel Worksheet Functions | |||
| Numbering Rows | Excel Worksheet Functions | |||
| numbering of rows | Excel Discussion (Misc queries) | |||
| Numbering Rows | Excel Discussion (Misc queries) | |||
| How do I do numbering of rows in Excel when there are blank rows? | Excel Discussion (Misc queries) | |||
Linear Mode
