| T O P I C R E V I E W |
| j1623 |
Posted - 03/28/2022 : 07:23:17 AM
Greetings!
I have a worksheet with >1000 columns of data. I want to produce another worksheet with log value of these data. I can input the f(x) manually (like log(Sheet1!B), log(Sheet1!C), ...) but it will take forever. Is there smarter method to finish this task?
Thank you! |
| 2 L A T E S T R E P L I E S (Newest First) |
| j1623 |
Posted - 03/28/2022 : 09:57:40 AM
quote:
Originally posted by ChaoC
Hi,
You can duplicate your worksheet, then go to Columns>Set Multiple Column Values. In the "wcol(j)=" box, enter log(This).
Chao
Thank you so much Chao! |
| ChaoC |
Posted - 03/28/2022 : 09:15:33 AM
Hi,
You can duplicate your worksheet, then go to Columns>Set Multiple Column Values. In the "wcol(j)=" box, enter log(This).
Chao |
|
|
