Prev: List top five
Next: Cells Fill Automatically on Another Workbook
From: jackie on 15 Mar 2010 12:07
Hi All- I need help returning a list of names on a separate sheet. I'll
enter "manager 1" in an input cell, and i want to return a list of
corresponding sales reps until i run out.

I am not sure which formula is best: Index, Lookup etc.


A B
manager 1 sales rep 1
manager 1 sales rep 2
manager 1 sales rep 3
manager 2 sales rep 4
manager 2 sales rep 5

thanks!
From: Ashish Mathur on 15 Mar 2010 12:19
hi,

you may refer to my article at the following website -
http://office.microsoft.com/en-us/excel/HA012260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"jackie" <jackie(a)discussions.microsoft.com> wrote in message
news:2E85CCE9-E441-47B9-BB5B-04DCD72A76D2(a)microsoft.com...
> Hi All- I need help returning a list of names on a separate sheet. I'll
> enter "manager 1" in an input cell, and i want to return a list of
> corresponding sales reps until i run out.
>
> I am not sure which formula is best: Index, Lookup etc.
>
>
> A B
> manager 1 sales rep 1
> manager 1 sales rep 2
> manager 1 sales rep 3
> manager 2 sales rep 4
> manager 2 sales rep 5
>
> thanks!

From: Teethless mama on 15 Mar 2010 13:17
> I am not sure which formula is best: Index, Lookup etc.

None.

Pivot table is the best option


"jackie" wrote:

> Hi All- I need help returning a list of names on a separate sheet. I'll
> enter "manager 1" in an input cell, and i want to return a list of
> corresponding sales reps until i run out.
>
> I am not sure which formula is best: Index, Lookup etc.
>
>
> A B
> manager 1 sales rep 1
> manager 1 sales rep 2
> manager 1 sales rep 3
> manager 2 sales rep 4
> manager 2 sales rep 5
>
> thanks!
From: T. Valko on 15 Mar 2010 13:48
Is the data sorted or grouped together by manager as is shown in your sample
data?

--
Biff
Microsoft Excel MVP


"jackie" <jackie(a)discussions.microsoft.com> wrote in message
news:2E85CCE9-E441-47B9-BB5B-04DCD72A76D2(a)microsoft.com...
> Hi All- I need help returning a list of names on a separate sheet. I'll
> enter "manager 1" in an input cell, and i want to return a list of
> corresponding sales reps until i run out.
>
> I am not sure which formula is best: Index, Lookup etc.
>
>
> A B
> manager 1 sales rep 1
> manager 1 sales rep 2
> manager 1 sales rep 3
> manager 2 sales rep 4
> manager 2 sales rep 5
>
> thanks!


From: Max on 15 Mar 2010 18:25
Although there are formulae routes, I'd not dismiss the ease of a pivot table
(in the "separate sheet" that you specify). Assume the col headers of your
source data are: Mgr, Rep. In Layout, drag n drop Mgr into PAGE area, Rep
into both ROW & DATA areas (set to Count). Click to Finish off the wizard.
And that's it. Go to the pivot sheet, just click to "filter" the Mgr droplist
created by any manager to surface the corresponding list of sales reps below
....
--
Max
Singapore
---
"jackie" wrote:
> Hi All- I need help returning a list of names on a separate sheet. I'll
> enter "manager 1" in an input cell, and i want to return a list of
> corresponding sales reps until i run out.
>
> I am not sure which formula is best: Index, Lookup etc.
>
>
> A B
> manager 1 sales rep 1
> manager 1 sales rep 2
> manager 1 sales rep 3
> manager 2 sales rep 4
> manager 2 sales rep 5
>
> thanks!
 | 
Pages: 1
Prev: List top five
Next: Cells Fill Automatically on Another Workbook