Hi,
I'm looking for macro that would get me a result after specific criteria as follows in attached workbook.
1 : database sheet
2 : Analysis sheet where the results should be
What formula to apply to get result in ANALYSIS SHEET B3
CRITERIA 1 C3:F12(DATA SHEET)=MODULE NUMBER A(ANALYSIS SHEET)
CRITERIA 2 G3:J12 (DATA SHEET)= WEEK NUMBER 1(ANALYSIS SHEET)
CRITERIA 3 A3:A (DATA SHEET)= FACTORY NAME JOHN(ANALYSIS SHEET)
Thank you for help!
Bookmarks