Unique Values

Hi everyone,

I have a spreadsheet whereby I'm trying to work out the Per Capita values based off Cost Centres. Currently, I'm using sumif to workout the totals of the cost centres within the raw data to work out the PC. But I want these values to appear in the raw data once per cost centre listed so I can use the info within a pivot table. Any idea how this can be done?

Please see attached sample.

Raw: Require the per capita data calculated on the 'Unique' tab to appear in the PC column but only once per cost centre listed (so I can use sum within a pivot table).
Uniques: Per capita calculated here based on all the unique cost centres.


Thanks for any help!
Mike