If I need to find a specific item on a spreadsheet ie: all mentions of maths, what is the best method to use. I often get calls to find all our teachers with qualifications in a particular subject across a certain region and it would be great to have a method set up so I can save time.

All depends on how your spreadsheet is layed out. It can be done, but not easily.

It's easy to do in MS Access if you are able to do it in that rather than Excel, but if you have to do it in Excel, then I'm sure we can work out a way if you provide more information on how your workbook is laid out.

Hi Bronagh

Sorry i haven't got back to you sooner the best way to search for the info you need is to run a filter, highlight the cells you want to search then go to the data menu, then filter and auto filter.

When you see then drop down arrows choose the option you want to filter from the desired drop down to find just the thing you are after

You can additionally have more than one filter running at once, try this out see if it helps

Mark East