Hello,
Ive got two columns with staff ID numbers which Id like to firstly match
and then sort so that identical ID numbers are on the same row. For example,
unsorted the columns look like this:
A B
3345 3876
3654 3980
2872 3545
3980 2872

Id like to have the ID numbers matched and sorted by row like this:
A B
3345 3345
3654
2872 2872
3980 3980
3876

Column A has about 3000 entries and Column B has about 400 entries, so that
not all ID numbers in Column B appear in Column A. Columns D, E, F etc have
other information such as the persons name, telephone number, email address
etc. How do I do this? I am a very basic Excel user so Im not very familiar
with formulas etc. I'm using Excel 2007.

Thanks in advance,
Eilean