Like data... like insanity

Feb 22nd, 2002, 09:39 AM

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 · Feb 22nd, 2002, 09:47 AM

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 · Feb 22nd, 2002, 09:47 AM

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

Feb 22nd, 2002, 02:06 PM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 09:39 AM	#1
Guest Posts: n/a	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

Feb 22nd, 2002, 09:47 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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 ]

Feb 22nd, 2002, 09:47 AM	#3
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	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

Feb 22nd, 2002, 02:06 PM	#4
Guest Posts: n/a	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)