SOLVED

(Help) How do I leave just one value per contract?

Copper Contributor

So, I have a table of contracts and each contract has its own value, but the same contract can have multiple guarantees. However, the contract value repeats for each type of guarantee, meaning that the total sum ends up wrong. Here's an example:
vykvykvyk_0-1704919270939.png
How can I do this for the whole table?

 

2 Replies
best response confirmed by vykvykvyk (Copper Contributor)
Solution

@vykvykvyk 

=IF(COUNTIF($A$2:A2,A2)=1,B2,"")

 

I'd apply this formula in order to return the contract value only once for each contract. The table on the right in your screenshot seems as if there are merged cells which you should always avoid working with since merged cells cause problems.

contract value.png

@OliverScheurich thank you so much for the quick response, it works!

1 best response

Accepted Solutions
best response confirmed by vykvykvyk (Copper Contributor)
Solution

@vykvykvyk 

=IF(COUNTIF($A$2:A2,A2)=1,B2,"")

 

I'd apply this formula in order to return the contract value only once for each contract. The table on the right in your screenshot seems as if there are merged cells which you should always avoid working with since merged cells cause problems.

contract value.png

View solution in original post