I have a spreadsheet that I need help so that I'm not duplicating information. On any individual 6-digit project number (arranged in a column) I may have three different people who worked on that particular project. Their names are also in a different column but have the same project number associated with them. The estimated revenue on that project number is displayed as many times as I have people that worked on that project. I don't mind having the revenues show up once for each person who worked on a project number, but I can't have the same person (whose name may be associated with that project number more than once) show the revenues multiple times. How can I only show the revenue once for each person involved in that project number when the same person may be listed more than once? In other words.........if the values below come through like I typed them, I'd like to end up with my repeat person "Bill" show the revenues of $6,000 only once.


My Data: What I want to end up with:

121458 Bill $6000 121458 Bill $6000
121458 Tom $6000 121458 Tom $6000
121458 Bill $6000 121458 Bill $0
121458 Mary $6000 121458 Mary $6000
121459 Joe $7499 121459 Joe $7499
121460 Sally $1185 121460 Sally $1185



Thanks.