willisjules
New Member
- Joined
- Jul 6, 2010
- Messages
- 3
Hi everyone. I have what is probably a very simple quesion, but despite having spent the morning searching online and trying formulas I can't get anything to work. 
I have a simple spreadsheet to track people booking onto events. Columns A to G cover personal data, then we capture everyone's 1st, 2nd, 3rd choice event in columns H, I and J. These are completed using a drop-down list of all events.
I'm trying to obtain a list of all the people wanting a specific event, so I need a formula to say whether H, I or J equals horseriding (for example). I need to return the full data where this is true as opposed to just counting the results.
Ideally I would like to then export the filtered list columns A to G to a new workbook. This is less important than the formula though because there's always cut n paste
Thanks for reading.

I have a simple spreadsheet to track people booking onto events. Columns A to G cover personal data, then we capture everyone's 1st, 2nd, 3rd choice event in columns H, I and J. These are completed using a drop-down list of all events.
I'm trying to obtain a list of all the people wanting a specific event, so I need a formula to say whether H, I or J equals horseriding (for example). I need to return the full data where this is true as opposed to just counting the results.
Ideally I would like to then export the filtered list columns A to G to a new workbook. This is less important than the formula though because there's always cut n paste

Thanks for reading.