Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put series of number in excel when the filter is applied?
1. I applied filters in my excel.
2. I tried to put series of number using fill series option 3. Fill series is not working. Kindly provide me whether there is any option for the filling the series of numbers after after applying the filters? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put series of number in excel when the filter is applied?
Suppose your filters are in row 1 with headers, and that you want the
numbers in column Z and that the first visible row after filtering is row 20. Put this formula in Z20: =COUNTIF(Z$1:Z19,"<") Then you can copy this formula down the rest of the visible cells in column Z to give you sequential numbers. If you don't have a header in Z1, you can do it with this: =COUNTIF(Z$1:Z19,"<")+1 then copy this down. Note the cell Z19 is the cell immediately above the first visible cell, so adjust this to suit your data. When you remove the filters the sequential numbers will still be there, but only in the cells that were visible. Hope this helps. Pete On Aug 3, 3:11*pm, bhanu reakha wrote: 1. I applied filters in my excel. 2. I tried to put series of number using fill series option 3. Fill series is not working. Kindly provide me whether there is any option for the filling the series of numbers after after applying the filters? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put series of number in excel when the filter is applie
Thanks a ton for the solution.
"Pete_UK" wrote: Suppose your filters are in row 1 with headers, and that you want the numbers in column Z and that the first visible row after filtering is row 20. Put this formula in Z20: =COUNTIF(Z$1:Z19,"<") Then you can copy this formula down the rest of the visible cells in column Z to give you sequential numbers. If you don't have a header in Z1, you can do it with this: =COUNTIF(Z$1:Z19,"<")+1 then copy this down. Note the cell Z19 is the cell immediately above the first visible cell, so adjust this to suit your data. When you remove the filters the sequential numbers will still be there, but only in the cells that were visible. Hope this helps. Pete On Aug 3, 3:11 pm, bhanu reakha wrote: 1. I applied filters in my excel. 2. I tried to put series of number using fill series option 3. Fill series is not working. Kindly provide me whether there is any option for the filling the series of numbers after after applying the filters? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put series of number in excel when the filter is applie
You're welcome - thanks for feeding back.
Pete On Aug 5, 7:22*am, bhanu reakha wrote: Thanks a ton for the solution. "Pete_UK" wrote: Suppose your filters are in row 1 with headers, and that you want the numbers in column Z and that the first visible row after filtering is row 20. Put this formula in Z20: =COUNTIF(Z$1:Z19,"<") Then you can copy this formula down the rest of the visible cells in column Z to give you sequential numbers. If you don't have a header in Z1, you can do it with this: =COUNTIF(Z$1:Z19,"<")+1 then copy this down. Note the cell Z19 is the cell immediately above the first visible cell, so adjust this to suit your data. When you remove the filters the sequential numbers will still be there, but only in the cells that were visible. Hope this helps. Pete On Aug 3, 3:11 pm, bhanu reakha wrote: 1. I applied filters in my excel. 2. I tried to put series of number using fill series option 3. Fill series is not working. Kindly provide me whether there is any option for the filling the series of numbers after after applying the filters?- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
How to use color from a datasheet to be applied to same series on | Charts and Charting in Excel | |||
Refresh with Advance Filter Applied | Excel Discussion (Misc queries) | |||
FILTER applied to many coloumns | Excel Discussion (Misc queries) | |||
filters how do i keep the display list empty until filter applied | Excel Discussion (Misc queries) |