Like data... like insanity
VBA Telemetry pings you when your VBA projects fail
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,581
    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,605
    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)

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
  •  

 

 
DMCA.com