SOLVED

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

Copper Contributor

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

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:

How can I do this for the whole table?

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

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

=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.

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

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

1 best response

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

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

=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.