S
Steved
Hello from Steved
A1 B1 C1 D1
1-Feb Sun 40793 1
E3 F3 H3
Sun Mon Tue
1 2 3
40793
=INDEX($B:B:C:C,SMALL(IF(B:$B=$E$3,ROW($B:B)-ROW($B:B)
+1,ROW($B:B)+1), $D$5),2)
The Above Formula works, but I would like to work without
the D Column is used for week 1, week 2, week 3, week
4,week 5 and week 6. I have nine rows of Data *month =
270 rows of data. A1 changes to the next month.
Any Idea's Please
A1 B1 C1 D1
1-Feb Sun 40793 1
E3 F3 H3
Sun Mon Tue
1 2 3
40793
=INDEX($B:B:C:C,SMALL(IF(B:$B=$E$3,ROW($B:B)-ROW($B:B)
+1,ROW($B:B)+1), $D$5),2)
The Above Formula works, but I would like to work without
the D Column is used for week 1, week 2, week 3, week
4,week 5 and week 6. I have nine rows of Data *month =
270 rows of data. A1 changes to the next month.
Any Idea's Please