DayTraderKevin
New Member
- Joined
- Dec 23, 2022
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Column's C-G are capturing data every minute. I'm trying to also capture what is happening every two minutes, starting at column I. When I try to copy/paste the formula started in column's I & J, Excel does not see that I'm trying to only capture every OTHER cell from the table on the left.
In reality I'm trying to capture every two and five minutes; hundreds of columns from market open to market close.
Is there a way to continue the formula in column's I & J, to column K and further?
In reality I'm trying to capture every two and five minutes; hundreds of columns from market open to market close.
Is there a way to continue the formula in column's I & J, to column K and further?
A | B | C | D | E | F | G | H | I | J | K |
1 | Time | 6:00 | 6:01 | 6:02 | 6:03 | 6:04 | 6:00 | 6:02 | 6:04 | |
2 | Stock 1 | $12 | $13 | $11 | $16 | $13 | =C2 | =E2 | ||
3 | Stock 2 | $17 | $22 | $13 | $12 | $18 | =C3 | =E3 |