+ Reply to Thread
Results 1 to 3 of 3

Comparing two sets of data

  1. #1
    Registered User
    Join Date
    10-23-2006
    Posts
    11

    Comparing two sets of data

    Hi,

    Im having some problems comparing data. Ive had a look about the net but I cant seem to find what im looking for.

    Basicall I have two sets of data, one being 1700 cells long and the other around 5000. The second set of data also has an cash amount in the column next to it, so what I need is to be left with only the 1700 from the first list with the corrosponding cash value from the collumn.

    Ive got an example below:

    First Set of data
    269 803 425
    274 524 032
    273 725 580
    273 486 886
    273 191 015
    273 758 540
    273 435 610
    273 499 038
    269 603 072

    Second Set of data Amount
    255 097 339 £83.69
    269 524 032 £83.69
    269 803 425 £83.69
    255 094 856 £83.69
    255 094 815 £83.69
    255 094 773 £83.69
    255 095 101 £83.69
    257 811 562 £10.00
    255 271 801 £91.00
    257 818 559 £91.00
    257 818 591 £10.00
    255 195 109 £10.00
    255 194 953 £10.00
    255 194 912 £10.00
    255 194 565 £106.81
    255 174 427 £10.00
    255 134 595 -£15.98
    255 093 684 -£15.98
    255 216 491 £43.50
    255 216 368 £10.00
    255 221 657 £43.50


    In this case i would be left with only:

    269 803 425 £83.69

    Any help would be great.

    Thanks,
    Ross.
    Last edited by sheargraphix; 06-25-2007 at 10:49 AM.

  2. #2
    Forum Contributor
    Join Date
    10-14-2004
    Location
    San Diego, CA
    Posts
    213
    Hello Ross:

    I think this is what you are asking for.

    Matt
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-14-2004
    Location
    San Diego, CA
    Posts
    213
    Sorry Ross it seems I made a mistake in my caculations, here's a correction.
    Attached Files Attached Files

+ Reply to Thread

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