software

This is probably pretty standard but how to I sort columns containing the
same data but in different orders. eg. Column A has 1-10 listed in ascendinf
order, and column B has them listed in descending order, how could I sort
them so that 1 and 1, 2 and 2 etc pair up?

Just sort one of them in the opposite direction.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Tomquot; gt; wrote in message
...
gt; This is probably pretty standard but how to I sort columns containing the
gt; same data but in different orders. eg. Column A has 1-10 listed in
ascendinf
gt; order, and column B has them listed in descending order, how could I sort
gt; them so that 1 and 1, 2 and 2 etc pair up?
That was a poor example... heres the story

I have got over 4500 rows containing stock info - column 1 being the stock
code (numeric), the column 2 stock description etc etc.

Of those '4500' stock codes I have got '900' on a separate spreadsheet, I
need to match those numbers up against the '4500' on the other... therefore
having two coloumns next to some items with the stock code. I can then delete
those and be left with the '3600' that I didn't have the code for...

quot;Bob Phillipsquot; wrote:

gt; Just sort one of them in the opposite direction.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;Tomquot; gt; wrote in message
gt; ...
gt; gt; This is probably pretty standard but how to I sort columns containing the
gt; gt; same data but in different orders. eg. Column A has 1-10 listed in
gt; ascendinf
gt; gt; order, and column B has them listed in descending order, how could I sort
gt; gt; them so that 1 and 1, 2 and 2 etc pair up?
gt;
gt;
gt;


Tom,

Using a helper column in the 4500 row sheet, do a vlookup back to the
900 row block =VLookup(A1,B1:B900,1,false) and the ones that work are
the ones you need to delete.

Sort over this column and delete the 900 that are not #N/A
then re-sort over your part number.

Hope this helps.

--

Tom Wrote:
gt; That was a poor example... heres the story
gt;
gt; I have got over 4500 rows containing stock info - column 1 being the
gt; stock
gt; code (numeric), the column 2 stock description etc etc.
gt;
gt; Of those '4500' stock codes I have got '900' on a separate spreadsheet,
gt; I
gt; need to match those numbers up against the '4500' on the other...
gt; therefore
gt; having two coloumns next to some items with the stock code. I can then
gt; delete
gt; those and be left with the '3600' that I didn't have the code for...
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Just sort one of them in the opposite direction.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;Tomquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; This is probably pretty standard but how to I sort columns
gt; containing the
gt; gt; gt; same data but in different orders. eg. Column A has 1-10 listed in
gt; gt; ascendinf
gt; gt; gt; order, and column B has them listed in descending order, how could
gt; I sort
gt; gt; gt; them so that 1 and 1, 2 and 2 etc pair up?
gt; gt;
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=538797