Creating 2 lists by extracting unique values but values in each list are based off each other

[Zacharygolf]

Title may be a little confusing, I apologize. I have expense reports that contain multiple cost codes, job numbers, and expenses. What I want are 3 columns: a list of cost codes, a list of job numbers, and a $ total. I also want this list to e self propagating, meaning that I do not have to edit the formulas for they to work.

Cost	Job #	Acct #		Acct #	Job #	Total
$1.00	123	789		789	123	$1.00
$3.00	123	910		789	456	$12.00
$5.00	456	789		910	123	$3.00
$7.00	456	789		910	456	$9.00
$9.00	456	910

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

On the left is my test data, on the right is what I want to appear. So far I am able to extract the unique values and make them into a list using this formula(in cell A9):

{=INDEX($C$2:$C$6,MATCH(0,COUNTIF($A$8:A8,$C$2:$C$6),0))}

789

910

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

And I figured that using COUNTIFS( would do the trick but I can't get the formula to work properly. Any Help?

 

[Zacharygolf]

Never mind got it to work