ChatterBank2 mins ago
Filtering In Excel - Again!
4 Answers
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.
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.
Answers
1 to 4 of 4
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...
19:19 Thu 02nd Aug 2018
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.
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.
1 to 4 of 4
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.