| T O P I C R E V I E W |
| JayJay685 |
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. |
| 3 L A T E S T R E P L I E S (Newest First) |
| JayJay685 |
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 |
| ChaoC |
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 |
| YimingChen |
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 |
|
|
