a/l

trying to adapt https://www.get-digital-help.com/match-two-criteria-and-return-multiple-rows-in-excel/ to work for me. my version of the formula is: =INDEX($AK$7:$AK$15, SMALL(IF(COUNTIF($AG$5,$AJ$7:$AJ$15)*COUNTIF($AG$6,$AJ$7:$AJ$15)*COUNTIF($AG$7,$AJ$7:$AJ$15)...

I have created an annual leave tracker for use at work. My problem is that although you can pick from a dropdown A/L pending, A/L Approved and A/L denied, with conditional rules to change colours, at the moment anyone with access can at the moment do all three. Is there a way to ensure that only...

i NEED HELP TO LOOK UP BASED ON CRITERIA 1. NAME 2. DATE RANGE FILES : TIMEDB AND PAYROLL <colgroup><col><col><col span="2"></colgroup><tbody> NAME DATE TIME IN TIME OUT YOGHESRAJ A/L PERUMAL May 2, 2018 8:00 22:00 YOGHESRAJ A/L PERUMAL May 3, 2018 8:00 22:00 YOGHESRAJ A/L PERUMAL May...