If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I choose alternate rows in a column?
My requirement is to be able to create a column whose elements consist of
difference between adjacent elements in a column, say column A. If I can choose alternate elements and create 2 new columns then I can just subtract the 2 columns easily. |
#2
|
|||
|
|||
How can I choose alternate rows in a column?
Huh?
"pnair" wrote in message news My requirement is to be able to create a column whose elements consist of difference between adjacent elements in a column, say column A. If I can choose alternate elements and create 2 new columns then I can just subtract the 2 columns easily. |
#3
|
|||
|
|||
How can I choose alternate rows in a column?
Hi,
I don't quite understand what you want to do. Let's suppose that the data are in A1:A100. If you want, B2 to be equal to A2-A1, B3 to be equal to A3-A2, ........, B100 to be equal to A100-A99, enter the formula =A2-A1 in B2 and click ENTER. B1 wil be blank. Click again on B2, and autofill the formula down to B100 (for this, click on B2, move the cursor to the bottom right side corner of the cell (the cursor will change into a "+" sign), hold the left-side mouse button and drag down the rows to B100). If you, on the other hand, want only ALTERNATE cells in column B (i.e., B2, B4, B6, ... B100) show the difference between A values of the corresponding and the previous rows (i.e., B1, B3, B5, ... B99 will be blank), do the following. Enter the same formula (i.e., =A2-A1) in B2. Now select B1 and B2, and autofill the column down to B100. Now B2 will show A2-A1, B3 will be blank, B4 will show A4-A3, B5 will be blank, B6 will show A6-A5, ..., and ..B100 will show A100-A99. Regards, B. R. Ramachandran "pnair" wrote: My requirement is to be able to create a column whose elements consist of difference between adjacent elements in a column, say column A. If I can choose alternate elements and create 2 new columns then I can just subtract the 2 columns easily. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need rows in Column A removed if they fully or partially match with any Column B row | [email protected] | General Discussion | 1 | August 21st, 2005 11:41 PM |
match and count words | David | Worksheet Functions | 5 | July 4th, 2005 02:24 AM |
Formula to compare multiple rows values based on another column? | Murph | Worksheet Functions | 4 | February 21st, 2005 02:44 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Need to Sum one column for each row that is part of a group and then filter out dups | kukarooza | Worksheet Functions | 1 | July 8th, 2004 02:30 PM |