ADVANCE FORMULE OF GOOGLE SHEET

ADVANCE FORMULE  OF GOOGLE SHEET 

'=ARRAYFORMULA(if(Row(A:A)=1,"Duplicate Check",if(C:C="","",if(countif(C:C,C:C)>1,"Duplicate",""))))

=ARRAYFORMULA(if(Row(A:A)=1,"Check for Duplicates",If(B:B="","",if(countif(B:B,B:B)>1,"Duplicate",iferror(if(match(B:B,blist,0),"Bounced","NA"))))))

=ARRAYFORMULA(if(Row(A:A)=1,"Send NL #",if(C:C="","",VLOOKUP(C:C,schedule,3,false))))

=ARRAYFORMULA(if(Row(A:A)=1,"Sched Date",if(C:C="","",VLOOKUP(C:C,schedule,5,false))))

="Pending to Sched: "&counta(B3:B)-counta(C3:C)

=ARRAYFORMULA(if(Row(A:A)=1,"Send Tmpl #",if(C:C="","",if(D:D="","NA",if(D:D=0,0,if(VLOOKUP(D:D,scheduled,3,false)="","NA",VLOOKUP(D:D,scheduled,3,false)))))))

=if(E9=today(),match(E9,F9:BA9,0),"")

'=if(OR(A3="",sum(F3:BA3)=0),"", iferror(min(filter(F3:BA3,F3:BA3>=today()))))

  =if(P149="","",image(concatenate("http://drive.google.com/uc?export=view&id=",index(split(P149,"="),0,2))))

=IF(T150,T150,IF(U150="yes",NOW(),""))

=IF(COUNTIF(E9:E19,E9)>1,E9,"")

 =IF(VALUE(RIGHT(G13,1))=0,"",1)

 =LARGE(J6:J12,{1,2,3})

 =SMALL(J6:J12,{1,2,3})