Forum Discussion
IF statement
Hi Everyone , Happy to E meet you all ..!! Please help me out with this "Number of shows are “n” which have been split commonly between “m” variable campaigns , if any “m” campaigns has shared ...
=SUMPRODUCT(($C$4:$C$9=C4)*($D$4:$D$9<>D4))For the data layout of the example you can try this rule for conditional formatting if you want to highlight the date for a campaign that was promoted at more than 1 show.
OliverScheurich Thank you so much for the reply . But this is not helping .