# Thread: Need a formula that only show the set cost figure once for each unique User Id Thanks: 0 Likes: 0

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

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

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

2. ## Re: Need a formula that only show the set cost figure once for each unique User Id

Try something like this.

Set Cost

 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

 Cell Formula C2 =IF(AND(COUNTIFS(A2:A\$10,A2,B2:B\$10,B2)=COUNTIF(A2:A\$10,A2),COUNTIFS(A\$1:A2,A2,B\$1:B2,B2)=1),B2,"")

Excel tables to the web >> Excel Jeanie HTML 4  Reply With Quote

3. ## Re: Need a formula that only show the set cost figure once for each unique User Id

Hi Peter

That formula works treat Thank You Vey Much.

The Leicester Fox  Reply With Quote

4. ## Re: Need a formula that only show the set cost figure once for each unique User Id

Cheers. Thanks for the follow-up.   Reply With Quote

## User Tag List

cost, formula, set, user, £5.00 