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

Leicester City Fox

Board Regular
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 .

A
B
C
User ID
Set Cost
Result Want
A123
£5.00
£5.00
A123
£5.00
B234
£5.00
B234
£10.50
£10.50
B234
£10.50
C245
£8.24
£8.24
<tbody> </tbody>

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

 

Peter_SSs

MrExcel MVP, Moderator
Try something like this.

Excel Workbook
ABC
1User IDSet CostResult Want
2A1235
3A1235
4B2345
5B23410.510.5
6B23410.5
7C2458.248.24
8
Set Cost
 

Some videos you may like

This Week's Hot Topics

Top