microsoft+excel+training - Advanced filter

Hi Katrin thank you for your question.

You need to first enter in a range of cells seperate fom your list your criteria. This is called your criteria range and needs to have the field name in the top row and your criteria below the relevent field.

Next you click an individual cell in your list and go to the Data, Filter, Advanced Filter and make sure your list is correct in your list range and then enter your criteria range in the appropriate box.

Finally select whether you want to filter list in place or in another location. Click OK to perform the filtering.

Thanks you for using the delegate support forum.

Regards

BEST Training

PS. Don't forget to recommend the forum and our services to your friends, family and collegues.