without sample workbook just with luck .
=IF(D1>0,IF(AND(H1="ok",COUNTIF(M3:M7,K1)=0),"ok",IF((COUNTIF(M3:M7,K1)+COUNTIF(M3:M7,H1))>0,"Check this entry","")),"")
M3 to M7 contains:
Check this entry
102
103
112
*
without sample workbook just with luck .
=IF(D1>0,IF(AND(H1="ok",COUNTIF(M3:M7,K1)=0),"ok",IF((COUNTIF(M3:M7,K1)+COUNTIF(M3:M7,H1))>0,"Check this entry","")),"")
M3 to M7 contains:
Check this entry
102
103
112
*
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks