• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Xls formula

Niranjan1979

New Member
Is there a excel formula, I have to check first 7 column to see if 2 appears at least 3 times in a week, same have to be checked for 2, 3 and 4th week... if a week doesnt meet the criteria, those week have to be higlighted. I have attached an xls file that has 4 weeks.. the formula should be in column AD. In first row I have marked 1 week ...2nd week and so..
 

Attachments

  • Book1.xlsx
    10.1 KB · Views: 6
Use conditional formatting for each week. For week 1 use =COUNTIFS($A3:$G3,2)>=3.
In AD3 enter:
=IF(AND(COUNTIFS(A3:G3,2)>=3,COUNTIFS(H3:N3,2)>=3,COUNTIFS(O3:U3,2)>=3,COUNTIFS(V3:AB3,2)>=3),"Met","Not Met") can be entered in AD3 and copied down.
 
Last edited:
Back
Top