How do I filter rows based upon a column value

[Jack]

I have a spreadsheet that contains multiple agency id's in a column. When
generating reports, I would like to filter per agency and display only the
rows associated with that agency.

Is there a tutorial or sample on how to do this?

 

[Andy B]

Hi

It sounds like you are looking for Data / Filter / AutoFilter. Have a look
here for some basics:
http://www.contextures.com/xlautofilter01.html

 

[Ron de Bruin]

Hi Jack

Have you try Autofilter
http://www.contextures.com/xlautofilter01.html

 

[Jack]

Hi

It sounds like you are looking for Data / Filter / AutoFilter. Have a look
here for some basics:
http://www.contextures.com/xlautofilter01.html

This is working, however it placed filters in all of the column headers... I
just want to filter on one column. Turning it off appears to be all or
nothing.

 

[Andy B]

Hi

The AutoFilter arrows will show in all related columns, but will not be
active unless you make them active. The arrows will be blue if they are set
to filter, and black if they are not. Don't worry about the others!

 

[Don Guillett]

Place your cursor on the range you want to filter>then apply autofilter.