Hi,
Please refer to file attached.
Clause one formula - =IF(AND(COUNTIF($A$5:$A$6,A16)=1,INDEX($B$5:$B$6,MATCH(A16,$A$5:$A$6,0))<>B16),"Check ","True")
Clause two formula - = IF(AND(COUNTIF($A$5:$A$6,A17)<>1,VALUE(MID(B17,4,2))=MONTH($B$1),(VALUE(RIGHT(B17,4))=YEAR($B$1))),"TRUE","Check-Date")
No idea how to combine it together. Please help.
Thanks
Bookmarks