Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put series of number in excel while filters applied?
1. I applied filters in my excel
2. I need to put series of number 3. By using this " =COUNTIF(Z$1:Z19,"<") " formula we can able to fill the number series when the filters are applied for the excel. But this working fine when we drag the same for the rest of the rows 4. I need a solution for the same scenario when we double click on the right corner of the selected cells (to autofill the number series for the remaining cells instead of draggging) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put series of number in excel while filters applied?
If I understand what you want...sequentially number a filtered list...
Try this: =SUBTOTAL(3,Z$1:Z1) Copy down to the last row of unfiltered data. -- Biff Microsoft Excel MVP "bhanu reakha" wrote in message ... 1. I applied filters in my excel 2. I need to put series of number 3. By using this " =COUNTIF(Z$1:Z19,"<") " formula we can able to fill the number series when the filters are applied for the excel. But this working fine when we drag the same for the rest of the rows 4. I need a solution for the same scenario when we double click on the right corner of the selected cells (to autofill the number series for the remaining cells instead of draggging) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put series of number in excel when the filter is applied? | Excel Discussion (Misc queries) | |||
User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
How to use color from a datasheet to be applied to same series on | Charts and Charting in Excel | |||
filters how do i keep the display list empty until filter applied | Excel Discussion (Misc queries) | |||
Automatic Fills Applied To Cells After Entering a Number | Excel Discussion (Misc queries) |