I need a formula that will do the following: I want to copy A1:A3 to
different cells A10:A12. if the upper cells have identical entries I want the
lower cells to have the duplicated entry only once.

A
1 Joe
2 Bill
3 Joe
Because Joe was entered twice in the upper cells I want
the result to look like the lower cells. Essentually grouping like entries in
the upper cell to one entry in the lower cell.
A
10 Bill
11 Joe
12

Any help regarding this matter will be greatly appreciated. Thanks for your
time.