+ Reply to Thread
Results 1 to 3 of 3

How to sort & match 2 columns?

  1. 10-24-2012, 12:01 PM #1
    wearwestern
    wearwestern is offline
    Registered User
    Join Date
    10-23-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    9

    How to sort & match 2 columns?

    How do you match the text between two columns?

    Example: 
    Please Login or Register  to view this content.
    Last edited by wearwestern; 10-24-2012 at 12:59 PM. Reason: clearer
    Reply With QuoteRegister To Reply
  2. 10-24-2012, 02:33 PM #2
    mahju
    mahju is offline
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: How to sort & match 2 columns?

    Hi

    Please upload a sample sheet to see the layout and other data

    Regards
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju
    Reply With QuoteRegister To Reply
  3. 10-24-2012, 02:39 PM #3
    Pepe Le Mokko
    Pepe Le Mokko is online now
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: How to sort & match 2 columns?

    Try 
    Please Login or Register  to view this content.
    eneterd as an array forrmula with Ctrl+Shift+Enter

    It will fail if you have two sets of digits or no digits at all
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1