Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Like data... like insanity

  1. #1
    Guest

    Default

    Can someone help me please?
    I am trying to have Excel arrange two similar columns by identical values.
    Is there a way to do this? My brain is taxed from the Excel help.
    Thank you

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hmmm...not sure if this is what you're asking for, but...

    Data-Sort, first by column A, then by...

    or

    New column.
    =a1&b1 in first cell.
    Copy down.
    Copy all new cells, don't move cursor.
    Hit edit-paste special-values.
    Sort by new column?


    ____edited...

    Now that I've read it again, are you trying to sort those columns separately? Select JUST that column and sort.

    [ This Message was edited by: Dreamboat on 2002-02-22 08:48 ]

  3. #3
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you could post an example of your data, and an example of what you want the result to look like it would be helpful.

    -rh

  4. #4
    Guest

    Default

    Thanks guys. I jammed around in Access and finally got the two different sheets arranged, sorted, aligned and tweaked properly. I utilized access to make tables of the two sheets, and then pulled them into a single form. Fortunately, access associated the proper fields automatically and then I was able to have a master listing of all accounts and thier applicable data. What made this insane was that the two sheets had one column apiece that were similar...the other fields were unique. I DO apprecite the response though....I thought I was going to hemmorage. LOL
    Thanks,
    EITA (Egypt is the Answer)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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