Thread: Matching and sorting

Hello, I'm trying to sort and align 2 sets of columns so they match. I would like to sort by Items that match by amount and ticket number and identify items that are unique and don't match with any of the amounts in column D.

Example:

Sheet looks like this
A------------------- B---------------- ----------- C -----------------------D
-Net Remit A Ticket number A------------Ticket number B----- Net remit B
--- 976.80 --------7985238727 ----------------548970369 ------------($33.78)
--------------------------------------------------------- 7985238727------------$976.80
0.00 ----- 7990825365 ------------- ------------7990825365----------------$0.00
27.50 ------7992340215--------------------------7990825365--------------$0.00
0.00 --------7992889099--------------------------7992340215-------- -----$27.50
$20.00 ---------7993027979---------------------7992341333------------($18.57)
----------------------------------------------------- 7993027979------------------- $20.00



But I want it to look like this:

A ------------------------------B-------------------------------C---------------------------D
Net Remit A Ticket number A Ticket number B Net remit B
-------------------------------------------------------------548970369---------------($33.78)
$976.80-------------------7985238727-------------7985238727--------------$976.80
$0.00 ------------------- 7990825365------------ 7990825365------------ $0.00
$27.50 ------------------- 7992340215------------ 7992340215------------ $27.50
-------------------------------------------------------------7992341333------------ ($18.57)
20.00 ------------------- --- 7993027979----------- 7993027979------------ $20.00