Displaying entire row

[Chris]

Hi, I would like to display an entire row based on a category selection. I´ve
been trying to do this using PivotTables with no success.

For example:
East | Carl | 402-4567 | Home
West | Kevin | 535-3677 | Work
East | Karin | 455-7454 | Cell

If the user selects "East" I would like the output to be:
Carl | 402-4567 | Home
Karin | 455-7454 | Cell

How can I do this?

Thanks!
Chris

 

[Jim Thomlinson]

Have you tried an autofilter

Data -> Filter -> AutoFilter

 

[Chris]

Perfect, thanks.

Have you tried an autofilter

Data -> Filter -> AutoFilter