The Origin Forum

The Origin Forum

All Forums

Origin Forum

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

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

The Origin Forum