Converting columns of data

Feb 28th, 2002, 08:55 AM

I am fairly new to excel and have to convert a large number of columns of data in different files. I asked this question before but got an answer that only converts data one value at a time. I need to convert large columns of data to there Ln value and cannot do this one at a time. Is there a way to do this that is not so time consuming? Thanks

Ziggy · Mar 1st, 2002, 09:48 PM

I'm not familiar with your data or how large they actually are. I'm just visualizing using the LN function and then copying it down the whole column.

data is in A2

then type in which ever column you want to see the result
=LN(A2)
on the same row.
then copy/paste down the row.

Alternately try linking each sheet as Access tables in a database. setup queries with the same formula. Then your data will be refreshed instantly whenever the excel sheets are refreshed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 08:55 AM	#1
Guest Posts: n/a	I am fairly new to excel and have to convert a large number of columns of data in different files. I asked this question before but got an answer that only converts data one value at a time. I need to convert large columns of data to there Ln value and cannot do this one at a time. Is there a way to do this that is not so time consuming? Thanks

Mar 1st, 2002, 09:48 PM	#2
Ziggy Board Regular Join Date: Feb 2002 Location: Ontario, Canada Posts: 326	I'm not familiar with your data or how large they actually are. I'm just visualizing using the LN function and then copying it down the whole column. data is in A2 then type in which ever column you want to see the result =LN(A2) on the same row. then copy/paste down the row. Alternately try linking each sheet as Access tables in a database. setup queries with the same formula. Then your data will be refreshed instantly whenever the excel sheets are refreshed.