Filtering In Excel - Again!

[andy-hughes]

OK, I give up!

I have tried everything to filter the material I want, and I still can't get it to work. I am sure it is really simple if you know how -

I have an end column which has the word 'Slow' marked against some entries.

I want to gather all the 'Slow' entries together on a sheet so I can check it.

Please can someone explain to me how I do that? In English for the hard-of-thinking!!!!

Many thanks again.

[andy-hughes]

It's OK, I have sorted it!!!!

[New Judge]

Do you want to filter or do you want to sort?

If you want to filter click "Data" then "Filter". Small arrows will appear at the top of each column. Click the one in the column where "Slow" can be found. You will see an option "Slow". Click on that and only your "slow" rows will be shown. Note that this does not gather together your slow entries. You will note from the row numbers that they are not consecutive. The rows without "slow" will be hidden.

If you really want to gather your "slow" entries together you need to sort the spreadsheet. To do this click "Data" then "Sort". Your data will be highlighted and a dialogue box displayed. In that box you need to choose the column containing "slow". Choose that and the data will be sorted. Your "slows" will then appear together.

[TheWinner]

If you have sorted it, tell us all how you did it, as Excel baffles me all the time!

[andy-hughes]

I just figured out how to do what NewJudge has advised - follow his excellent instructions, and it will work for you too.