Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Or use Advanced Filter to remove every other row
of the original results. ListA ListB ListB 0 7 7 4 11 15 8 15 23 12 19 31 16 23 39 20 27 47 24 31 55 28 35 63 32 39 71 36 43 79 40 47 44 51 48 55 52 59 56 63 60 67 64 71 68 75 72 79 76 80 Criteria Test =NOT(MOD(ROW(ListB),2)) Create the first ListB by copying down your original formula. Advanced Filter creates the second ListB, filtered with Criteria. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A general question regarding Financials Formulas in Microsoft Exce | Excel Worksheet Functions | |||
Copying formulas to new rows, 20000 times | Excel Discussion (Misc queries) | |||
Excel if then formulas auto copying | Excel Discussion (Misc queries) | |||
Copying formulas (relative) give always original value | Excel Worksheet Functions | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) |