Results 1 to 7 of 7

calculate the difference between each possible pair of data

Threaded View

  1. #1
    Registered User
    Join Date
    08-11-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    4

    calculate the difference between each possible pair of data

    Hey everyone,

    So basically what i am trying to do is as follows: I have around 26 lists of data, call them A to Z. What I want to do is write a code that will calculate the difference between each possible pair of data, and if possible plot it as a matrix. E.g. if A has data: 3, 9, 24 and B has data: 1,5,13, when running my macro i will get a list: 1,4, 11. Then i want to do this for A vs C, A vs D, C vs D etc etc.

    Obviously doing it manually would take a very long time, If you could tell me what kind of thing could work or any references it would be much appreciated. Thank you!
    Last edited by JBeaucaire; 08-12-2012 at 06:44 PM. Reason: Corrected thread title to topic only, as per forum rules

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