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..