Like data... like insanity

[Guest]

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

 

[Anne Troy]

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

 

[Russell Hauf]

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

 

[Guest]

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)