Hi All,

I have a spreadsheet with 4 columns :

A = invoice numbers
B = invoice values
C= invoice numbers
D = invoice values

Columns A&B are List 1.
Columns C&D are List 2.

Column A and Column C contain have invoices that match and also other invoices that do not match.

I wish to have the invoice numbers in List 1 and List 2 sorted so that matched invoice numbers appear in the same row and thus I can check whether their respective invoice values also match.

I also need any unmatched invoices to remain in their respective columns, so that I can investigate further.

What I was going to do was to sort the two lists and then manually match them through cutting and pasting the two columns downwards so that matched invoice numbers appear in the same rows.

Can anyone suggest a quicker way of doing this?