Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A general question regarding Financials Formulas in Microsoft Exce Swhouston055 Excel Worksheet Functions 5 October 4th 05 06:48 PM
Copying formulas to new rows, 20000 times Box Excel Discussion (Misc queries) 3 September 2nd 05 02:20 PM
Excel if then formulas auto copying bf Excel Discussion (Misc queries) 2 July 3rd 05 01:56 PM
Copying formulas (relative) give always original value Eddyd Excel Worksheet Functions 5 May 12th 05 11:44 AM
Excel 2002 - copying formulas across worksheets Greg Excel Discussion (Misc queries) 1 January 27th 05 10:45 PM


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"