View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg
 
Posts: n/a
Default 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.