Sorting columns

T

Tom

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?
 
B

Bob Phillips

Just sort one of them in the opposite direction.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
T

Tom

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...
 
B

Bryan Hessey

Tom,

Using a helper column in the 4500 row sheet, do a vlookup back to th
900 row block =VLookup(A1,B1:B900,1,false) and the ones that work ar
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.

--
 
Top