This evening, I've taught myself the TEXTJOIN, MID, and SEARCH functions. Can't work out why my IF SEARCH isn't returning the false value but an error when the true value returns fine...
@goatermaths.bsky.socialExplore
@goatermaths.bsky.social@goatermaths.bsky.socialDoing some fun looking up of classes of yr 12 students in order to know who to target to recruit more to #COREMaths using xlookup - so handy :D