Need a formula that only show the set cost figure once for each unique User Id

[Leicester City Fox]

Hi There

Good Morning

Need a formula that only show the set cost figure once for eachunique User Id

I am looking for a formula that give me the result in ColumnC, The formula needs to only count the set cost figure that doesn’t change (ColumnB) for the user ID (Column A) just once .

<tbody> [TD="width: 160, bgcolor: transparent"]

A​

[/TD]
[TD="width: 189, bgcolor: transparent"]

B​

[/TD]
[TD="width: 151, bgcolor: transparent"]

C​

[/TD]
[TD="width: 160, bgcolor: transparent"]

User ID​

[/TD]
[TD="width: 189, bgcolor: transparent"]

Set Cost​

[/TD]
[TD="width: 151, bgcolor: transparent"]

Result Want​

[/TD]
[TD="width: 160, bgcolor: transparent"]

A123​

[/TD]
[TD="width: 189, bgcolor: transparent"]

£5.00​

[/TD]
[TD="width: 151, bgcolor: transparent"]

£5.00​

[/TD]
[TD="width: 160, bgcolor: transparent"]

A123​

[/TD]
[TD="width: 189, bgcolor: transparent"]

£5.00​

[/TD]
[TD="width: 151, bgcolor: transparent"]

​

[/TD]
[TD="width: 160, bgcolor: transparent"]

B234​

[/TD]
[TD="width: 189, bgcolor: transparent"]

£5.00​

[/TD]
[TD="width: 151, bgcolor: transparent"]

​

[/TD]
[TD="width: 160, bgcolor: transparent"]

B234​

[/TD]
[TD="width: 189, bgcolor: transparent"]

£10.50​

[/TD]
[TD="width: 151, bgcolor: transparent"]

£10.50
​

[/TD]
[TD="width: 160, bgcolor: transparent"]

B234​

[/TD]
[TD="width: 189, bgcolor: transparent"]

£10.50​

[/TD]
[TD="width: 151, bgcolor: transparent"]

​

[/TD]
[TD="width: 160, bgcolor: transparent"]

C245​

[/TD]
[TD="width: 189, bgcolor: transparent"]

£8.24​

[/TD]
[TD="width: 151, bgcolor: transparent"]

£8.24​

[/TD]
</tbody>

If anybody got any ideas of simply formula that can do this,please let me know?
Many Thanks
Leicester Fox

 

[Peter_SSs]

Try something like this.

Excel Workbook
	A	B	C
1	User ID	Set Cost	Result Want
2	A123	5	5
3	A123	5
4	B234	5
5	B234	10.5	10.5
6	B234	10.5
7	C245	8.24	8.24
8
Set Cost

 

[Leicester City Fox]

Hi Peter

That formula works treat

Thank You Vey Much.

The Leicester Fox

 

[Peter_SSs]

Cheers. Thanks for the follow-up.