Notifications
Clear all
Topic starter
Hello,
I'm looking for a function that can:
TRUE every unique value,
FALSE if there is "Cancelled" in the same row column C
FALSE all of the duplicates, but mark the last duplicate with TRUE.
Thank you very much for your time and help!
Posted : 15/01/2023 8:01 am
In cell B1 enter :
=IF(C1="Cancelled","False",IF(COUNTIFS(A1:$A$13,A1,C1:$C$13,""&"Cancelled")=1,"True","False"))
Posted : 17/01/2023 11:50 am
