Evening Excel geniuses,
I’ve hit a brick wall, I wonder if you can help.
I’m trying to analyse some data based on Cancer type. Such that if a certain Cancer type is selected in Cell A1 (‘Patient demographics’ worksheet), I want to filter my data in Sheet 2 (column B for example – which has a...