Need Array formula to multiple match different column with different rows and get result in EXCEL 2007
As you can refer to the picture I want to check Year between 2000 and 2010 along with Month, Day & Type common in all 11 rows i.e. 1, 1 & A
I need to check total 11 Rows having all same criteria from ROW 2 Y=2000, ROW 2 M=1, ROW 2 D=1, ROW 2 TYPE=A, Y=2001,CELL 249 M=1, ROW 249 D=1, ROW 249 TYPE=A, ........ROW 2480 Y=2010, ROW 2480 M =1, ROW 2480 D=1, ROW 2480 TYPE=A .....IF all these are satisfied only then Mark "X" Else ""