sort & match
 

I have a 21 page sheet that I have to match and sort columns b & d. I sort by
column b and then by d, but when they do not match each other I am having to
manually move each one. Is there any way for me to sort and match the
columns?

A B C D
E
11/21/2006 83225185 $93.09 83225185 $93.09
11/21/2006 83225223 $190.23 83225223 $190.23
11/21/2006 83225969 $49.99 83225969 $49.99
11/21/2006 83225971 $49.66 83225971 $49.66
11/21/2006 83225983 $0.01 83225995 $89.99
11/21/2006 83225995 $89.99 83226579 $268.01
11/20/2006 83226579 $268.01 83226593 $41.17
11/20/2006 83226593 $41.17 83226605 $222.59

sort & match
 

-Hi Rae:

I assume that all the data is on one sheet and that it merely prints out on
21 pages.

Why not sort columns A:C using two keys B and C B ascending C ascending
and then D:E using two keys D and E D ascending E ascending

This should match them up and then you can check using
if(and(b1=d1,c1=e1),"","<<<")

The one issue that you do not discuss is the relevance of the date. Does it
matter that cells d and e are moved to another date?

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Rae" wrote:

I have a 21 page sheet that I have to match and sort columns b & d. I sort by
column b and then by d, but when they do not match each other I am having to
manually move each one. Is there any way for me to sort and match the
columns?

A B C D
E
11/21/2006 83225185 $93.09 83225185 $93.09
11/21/2006 83225223 $190.23 83225223 $190.23
11/21/2006 83225969 $49.99 83225969 $49.99
11/21/2006 83225971 $49.66 83225971 $49.66
11/21/2006 83225983 $0.01 83225995 $89.99
11/21/2006 83225995 $89.99 83226579 $268.01
11/20/2006 83226579 $268.01 83226593 $41.17
11/20/2006 83226593 $41.17 83226605 $222.59