I'm a new here. I have a question please.
First, i'll do this with Excel 2010 but I really need the formula or whatever to be compatible with Excel 2003 because the person this is for has Excel 2003.
I have a volunteer's list for a charity. One column is called "Help Areas", with different options:
Food Bank Centres
Maintenance / DIY
Driving, Heavy Lifting
Administration / IT
I'd like to have a drop down menu with all the choices above BUT also being able to choose multiple options for each individual.
Also, if possible, I'd like these options to be selectable in the sort field at the top (see screenshot attached).
Thank you so much for your much appreciated help.