You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.
  • Because it will take advantage of the spill functionality excel now has:

    =FILTER(Table1_1[Patient Forename],Table1_1[Patient Date of Birth]=$B$7,0)

About

Avatar for Chalfie @Chalfie started