How do you filter an Excel sheet...

Joe 90 · 09-06-2009, 18:07

I've just been passed on a rather long and poorly organised Excel sheet.

Its our options for a new car, I want to be able to filter this list of around 600 rows.

First filter that'd be perfect would be to select all diesels so they could be copied onto their own sheet. Theres a much more manageable 266 diesels so i figure thats a good start.

Any ideas? I don't really know how to manipulate the search results.

09-06-2009, 18:07	#1
Joe 90 Absinthe Join Date: Jan 2007 Location: Chester Posts: 2,345	How do you filter an Excel sheet... I've just been passed on a rather long and poorly organised Excel sheet. Its our options for a new car, I want to be able to filter this list of around 600 rows. First filter that'd be perfect would be to select all diesels so they could be copied onto their own sheet. Theres a much more manageable 266 diesels so i figure thats a good start. Any ideas? I don't really know how to manipulate the search results. __________________ 360 Blog \| Join GiffGaff \| Twitter