Hello to everyone. I need some help filtering information on my spreadsheet. I h

Question

Hello to everyone. I need some help filtering information on my spreadsheet. I have a large spreadsheet in which one of the columns contains the names of organizations (so text, not numbers.) Sometimes the organizations collaborate with others and are listed in cells with other organizations. So a straight alphabetical sort will not bring up all of the informati!on I need in one place. Is there a way I can set a filter to find, for example, all references to "Organization A"?? Then, how would I saave that filtered information into its own document?

I appreciate any help you can give me, this document is huge and well, let's just say that using Excel is far from my specialty! Thanks in advance!!!

Explanation / Answer

My apologies... a feeble memory combined with false assumptions led me to provide insufficient information :-} You are correct -- the Filter button you see in the Help article is on the Excel 2011 Ribbon (which 2008 doesn't have) & Standard Toolbar, but not on the Excel 2008 Standard Toolbar. [There is an AutoFilters button that can be added to a toolbar if you wish.]

In Excel 2008:

Alternatively, if you use Insert> List to apply the List Manager to the data you'll be provided with a special List Toolbar containing the optional button mentioned above. The List Manager also provides a number of additional features that can be quite useful.!!

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.