Forum Discussion
Solved
(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 t...
=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!