Prev: 2007 Find_Replace - default on workbook?
Next: Creating a value from a variable result
From: Chris on 19 Apr 2010 13:03
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
From: Jim Thomlinson on 19 Apr 2010 13:05
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
From: Chris on 19 Apr 2010 13:19
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
 | 
Pages: 1
Prev: 2007 Find_Replace - default on workbook?
Next: Creating a value from a variable result