AjayneACopper ContributorNov 16, 2022IFERROR +1 I am trying to create a spreadsheet to show me who the duty person is on a particular day. I have managed to get my formula to show me the name of the days' duty person however some days there are tw...Show MoremtarlerNov 16, 2022AjayneA if you have 365 then you can use:=FILTER(Sheet2!$C$5:$C$18,"Duty"=Sheet2!D5:D18,"")and it will 'spill' the list of all people listed on 'duty'
mtarlerNov 16, 2022AjayneA if you have 365 then you can use:=FILTER(Sheet2!$C$5:$C$18,"Duty"=Sheet2!D5:D18,"")and it will 'spill' the list of all people listed on 'duty'
mtarlerNov 16, 2022AjayneA if you have 365 then you can use:=FILTER(Sheet2!$C$5:$C$18,"Duty"=Sheet2!D5:D18,"")and it will 'spill' the list of all people listed on 'duty'
mtarlerSilver Contributor to AjayneANov 16, 2022Glad to help. Glad it works for you. and hopefully next time you won't wait a week before reaching out 🙂
