Copying Formulas Question
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.
|