Hello Paul,
Thanks its working fine.
I have one more question is there any way we can prevent deleting rows
using VBA.
Regards,
Chandru
On Wed, Jul 25, 2018 at 5:42 PM, Paul Schreiner
wrote:
> You can use:
>
> =IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>
> 0),"Yes","No")
>
You can use:
=IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>0),"Yes","No")
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long
Hello,
Need formula which should check Column A and B For Ex: If CPI have both A &
B then its Yes. IF CPI has only A or B then it should be No.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of t
