+ Reply to Thread
Results 1 to 2 of 2

Match and Sort and Align two columns

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Vancouver
    Posts
    2

    Match and Sort and Align two columns

    Hello I have to sort and match two colums and don't know how; please show me how to write such formula. Thanks in advance!!

    This is what I have, match & sort column B to column A in a uqiue and non repeating way:
    A-- B
    11 11
    22 22
    33 33
    33 33
    33 66
    44 88
    55 99
    66
    66
    77
    88

    After sorting & matching I would like to have something like this in column C (matched) and column D (not matched):
    A--B--C--D
    11 11 11 99
    22 22 22
    33 33 33
    33 33 33
    33 66
    44 88
    55 99
    66 ---66
    66
    77
    88 ---88

    *please ignore that dash, they are just there to put the numbers in the correct column on this forum page.

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    Why only "99" in column D? 44 55 77 ?
    I don't understand you very well. But if you need to find matched data, you can use the formula of "Match" just a equal sign "="
    I need your support to add reputations if my solution works.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match and align cells
    By anita.r in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2008, 07:07 PM
  2. Excel Align equal values in adjoining Columns
    By egan-23 in forum Excel General
    Replies: 2
    Last Post: 09-13-2006, 12:28 PM

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