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)
@Chalfie started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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)