Results 1 to 6 of 6
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Matching values (2000, 2002)

    I don't understand what you want. Could you include an example of what you expect the result to look like?

  2. #2
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Matching values (2000, 2002)

    Please see the attached example.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Matching values (2000, 2002)

    I don't understand how the original file would lead to these results.

    What do you want the results of the original file to look like at the end...

    Could you place an example of the results that you want?

    Steve

  4. #4
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Matching values (2000, 2002)

    dont worry about it... I''ll leave it as it is.

    Thanks,

  5. #5
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Matching values (2000, 2002)

    Hi all,

    I have four columns in my spreadsheet. On the first column I have got values that are assigned to the second column. ( i.e. first column money in and second column customer ID). The same applies to the third and fourth columns (3rd column money in fourth column customer ID). Most of the Costumer ID's are the same on the 2 and fourth column, and there are some ID's that are on the second column but not on the fourth column and vise versa. I want to sort second and fourth column alphabetically, the values should match when sorting . please see the attached spreadsheet.

  6. #6
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Matching values (2000, 2002)

    Is it like sorting out with two column in parallelly?

    Indra

Posting Permissions

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