+ Reply to Thread
Results 1 to 5 of 5

Sort rows

  1. 10-11-2010, 01:00 PM #1
    Migration
    Migration is offline
    Registered User
    Join Date
    10-11-2010
    Location
    D.F., Mexico
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question Sort rows

    I have the following problem:
    I have a list of people in Column A
    In Column B are some of these people
    In Column C are additional informtion to the persons in B

    Example
    Columns:
    A B C
    A B 2
    B D 4
    C
    D
    E

    I want to order Column B and C, so that the same names allign in the same row with the additional information and if there is no match there shall be a blank row:

    Columns:
    A B C
    A
    B B 2
    C
    D D 4
    E

    I so far managed to allign the names in the same rows, but couldnt figure out how to add the additional information in the column to the right...

    I used: =if(countif(B:B,A1),A1, "")

    I hope there is a simple solution.
    Thanks for showing interest!
    Last edited by Migration; 10-12-2010 at 12:46 PM.
    Reply With QuoteRegister To Reply
  2. 10-11-2010, 01:44 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Sort rows

    Welcome to the forum.

    See http://www.excelforum.com/excel-gene...s-a-and-b.html

    http://www.excelforum.com/excel-prog...e-columns.html

    http://www.excelforum.com/excel-work...o-columns.html

    http://www.excelforum.com/excel-gene...r-columns.html

    .. the same code in all cases.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 10-11-2010, 05:35 PM #3
    Migration
    Migration is offline
    Registered User
    Join Date
    10-11-2010
    Location
    D.F., Mexico
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Sort rows

    Thanks for your rapid answer, but that didn't help me so far...
    You said it is the same code for all of those four links, but I encountered different code everywhere...

    I tried it with a pivit table but that didnt work, and what is this VBE?
    It a place where I can add formulars? How do i access it...

    I am still lost, well I keep browsing, maybe someone has another tip for me.

    Anyway, thanks
    Reply With QuoteRegister To Reply
  4. 10-11-2010, 07:49 PM #4
    beaunydal
    beaunydal is offline
    Forum Contributor
    Join Date
    01-28-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: Sort rows

    Say you name the column B values "Bstuff" and the column C values "Cstuff", then, assuming headings in row 1...
    Please Login or Register  to view this content.
    in a spare row 2 cell filled down to the last row of column A values repositions the appropriate values for the Bstuff, and... 
    Please Login or Register  to view this content.
    in another spare row 2 cell filled down the same number of rows repositions the appropriate Cstuff values.
    Reply With QuoteRegister To Reply
  5. 10-12-2010, 12:46 PM #5
    Migration
    Migration is offline
    Registered User
    Join Date
    10-11-2010
    Location
    D.F., Mexico
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Sort rows

    Thanks a lot for your rapid answer!
    I still have so much to learn with Excel ^^
    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)

Tags for this Thread

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