Selecting entire rows based on contents of cell?

Hi there,

I have a large set of data regarding the activities going on in particular rooms. The data contains activity name, start time, day, duration, room and size.

I would like to select all rows that contain a cell in the activity name column which contain the words 'VideoConference'.

I have tried to Search, Select All then index the remaining data using =iferror(index(etc. However some activities occur in more than one room and all variables apart from 'Room' are the same. Thus when I have tried to index the room column I get the same room for both rows.

Please see attached spread sheet for the raw data and my desired result.

Thanks in advance.

ps the raw data set consists of +28000 rows so I can not simply look through and copy.

One method would be to use autofilter:
1. Ctrl+A to select all your data.
2. Select menu option data->filter->autofilter
3. You should get drop down boxes in row 1, select the drop down box in A1 and then select "custom"
4. There are many options for filtering, you need to select to show rows where Activity Name "contains" "VideoConference"

Try this with helper column.
You can also change word for criteria in B1

Cheers thank you all!