Results 1 to 2 of 2

Cannot get data movement percentage

Threaded View

  1. #1
    Registered User
    Join Date
    12-10-2003
    Posts
    3

    Cannot get data movement percentage

    Hello,
    I have a sheet that contains 30 columns of data. I want to be able to have a new column 31 that will show the biggest movement between each column. i.e. columnA - columnB columnB-columnC columnC - columnD etc etc. in order to see how the data is changing & to highlight instances were the movement is large.
    I would also like to show this as a percentage movement.
    Can anyone help please?
    It would be much appreciated.

    e.g if the columns were

    2 2 2 3 3 2 2 3 then the new column would be 1
    2 2 15 15 15 12 12 12 then the new column would be 13

    Hope this makes sense!

    Cheers
    Steve G
    Last edited by steve.griffiths; 09-19-2011 at 06:38 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1