Displaying entire row
 

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

Displaying entire row
 

Have you tried an autofilter

Data - Filter - AutoFilter
--
HTH...

Jim Thomlinson


"Chris" wrote:

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

Displaying entire row
 

Perfect, thanks.

"Jim Thomlinson" wrote:

Have you tried an autofilter

Data - Filter - AutoFilter
--
HTH...

Jim Thomlinson


"Chris" wrote:

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