Graciously requesting assistance aligning columns based on identical data in cells

Excel 2010

I have 3 lists of user names:

List 1 - Active Employees - 1200 items
List 2 - Active Email Addresses - 2200 items
List 3 - Active AD accounts - 4400 items

I am trying to align the columns to match like data.

EX:
current
A B C
1 a b b
2 b c d
3 c f e
4 d j f
5 e k k

desired
A B C
1 a * *
2 b b b
3 c c *
4 d * d
5 e * e
6 * f f
7 * j *
8 * k k

So far all of my attempts have failed, as there is not always a match; a name may appear in only one column.

My methodology may be flawed; if anyone has any suggestions, it would be very appreciated.

I have uploaded a small sample of the data.

maybe so

Please Login or Register  to view this content.

Thank you for the response.

You are a beautiful human being; worked perfectly. /bow