Converting columns of data
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Converting columns of data

  1. #1
    Guest

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    337
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com