Forum Discussion
(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?
=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.
=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.
OliverScheurich thank you so much for the quick response, it works!
