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? |
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? |
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? |
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 - |
All times are GMT +1. The time now is 12:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com