G G KP New Member Aug 16, 2016 #1 I need excel help regarding Data validation dropdownlist I have attached a file and mentioned the query.... Attachments New Microsoft Office Excel Worksheet (2).xlsx New Microsoft Office Excel Worksheet (2).xlsx 10 KB · Views: 6
I need excel help regarding Data validation dropdownlist I have attached a file and mentioned the query....
J Jake Collins Active Member Aug 16, 2016 #2 Dear G KP This formula in C19 should work and can be copied across. =COUNTIF(OFFSET($C$6,0,MATCH($B$18,$D$5:$J$5,0),9),C18)
Dear G KP This formula in C19 should work and can be copied across. =COUNTIF(OFFSET($C$6,0,MATCH($B$18,$D$5:$J$5,0),9),C18)
B bosco_yip Excel Ninja Aug 16, 2016 #3 Another option………. OFFSET is a volatile function and causes recalculation of the formula. Try to consider the INDEX non-volatile function instead. In C19, formula copy across : =COUNTIF(INDEX($D$6:$J$14,0,MATCH($B$18,$D$5:$J$5,0)),C18) Regards Bosco
Another option………. OFFSET is a volatile function and causes recalculation of the formula. Try to consider the INDEX non-volatile function instead. In C19, formula copy across : =COUNTIF(INDEX($D$6:$J$14,0,MATCH($B$18,$D$5:$J$5,0)),C18) Regards Bosco
