| Author |
 Topic  |
|
|
JayJay685
Germany
2 Posts |
 Posted - 04/25/2022 : 06:43:14 AM
|
Hello there,
I have a problem and I hope someone can help about this.
Like in this picture I wanna copy the first 10 data points from column G to I. This is going well.
Additional I wanna copy data points 11 to 40 from column H to I as well starting at row 11.
How does this work? I can't figure out.
Greetings and thanks for help. |
|
|
YimingChen
1592 Posts |
Posted - 04/25/2022 : 09:46:34 AM
|
You need to click the green lock on col(I) and set recalculate mode to None. Then you should be able to copy data to I[11-40].
James |
 |
|
|
ChaoC
USA
165 Posts |
Posted - 04/25/2022 : 09:53:12 AM
|
Hi,
If you want to use a column formula you can write:
IF(i<11,G,H)
This is if you have exactly 40 rows in your H column.
If you have more than 40 rows you can write:
IF(i<11,G,(IF(i>10 && i<41,H)))
Chao |
|
|
|
JayJay685
Germany
2 Posts |
Posted - 04/25/2022 : 10:30:01 AM
|
quote:
Originally posted by YimingChen
You need to click the green lock on col(I) and set recalculate mode to None. Then you should be able to copy data to I[11-40].
James
That would be one possibility. But I don't wanna do a copy&paste job for a lot of data. But thanks.
quote:
Originally posted by ChaoC
Hi,
If you want to use a column formula you can write:
IF(i<11,G,H)
This is if you have exactly 40 rows in your H column.
If you have more than 40 rows you can write:
IF(i<11,G,(IF(i>10 && i<41,H)))
Chao
Works very fine. Thanks very much. Instead of "," I had to use ";".
Cheers |
|
|
| |
Topic |
|
|
|
Two column data points into one