Leicester City Fox
Board Regular
- Joined
- Oct 7, 2016
- Messages
- 91
- Office Version
- 2019
- Platform
- Windows
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>
</tbody>
If anybody got any ideas of simply formula that can do this,please let me know?
Many Thanks
Leicester Fox
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