Hello,
I have a simple table: header row is clients, 1st column are employees. Each
employee is assigned a primary client and 1 or more secondary clients. Where
the employee meets the primary client, a "P" is put in the cell. "S's" are
put in cells where employees meet their 2ndary client(s). These P's and S's
may vary daily.
I want to use a function to build two tables out of this data: one with all
the employees names and their corresponding primary and secondary clients,
and one with the clients name and their "primary" corresponding employee.
This would change when the P's and S's would move in the main table.
I tried the LOOKUP function and it worked for most employees but not all.
The order in which the P's and S's are is not what's affecting this.
Should I use a different function altogether? Will I have problem having
more than one S in several rows? (If so, I can rename S1, S2, etc...)
Thank you,
Caroline

Have you looked into Data | AutoFilter?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Caroline" wrote in message
...
Hello,
I have a simple table: header row is clients, 1st column are employees.
Each
employee is assigned a primary client and 1 or more secondary clients.
Where
the employee meets the primary client, a "P" is put in the cell. "S's" are
put in cells where employees meet their 2ndary client(s). These P's and
S's
may vary daily.
I want to use a function to build two tables out of this data: one with
all
the employees names and their corresponding primary and secondary clients,
and one with the clients name and their "primary" corresponding employee.
This would change when the P's and S's would move in the main table.
I tried the LOOKUP function and it worked for most employees but not all.
The order in which the P's and S's are is not what's affecting this.
Should I use a different function altogether? Will I have problem having
more than one S in several rows? (If so, I can rename S1, S2, etc...)
Thank you,
Caroline

No, I don't see how filters would work for this particular example...

"Bernard Liengme" wrote:

Have you looked into Data | AutoFilter?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Caroline" wrote in message
...
Hello,
I have a simple table: header row is clients, 1st column are employees.
Each
employee is assigned a primary client and 1 or more secondary clients.
Where
the employee meets the primary client, a "P" is put in the cell. "S's" are
put in cells where employees meet their 2ndary client(s). These P's and
S's
may vary daily.
I want to use a function to build two tables out of this data: one with
all
the employees names and their corresponding primary and secondary clients,
and one with the clients name and their "primary" corresponding employee.
This would change when the P's and S's would move in the main table.
I tried the LOOKUP function and it worked for most employees but not all.
The order in which the P's and S's are is not what's affecting this.
Should I use a different function altogether? Will I have problem having
more than one S in several rows? (If so, I can rename S1, S2, etc...)
Thank you,
Caroline

You could extract (then copy and paste) just those records with P, and again
just those records with S
But maybe I am misreading the question
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Caroline" wrote in message
...
No, I don't see how filters would work for this particular example...

"Bernard Liengme" wrote:

Have you looked into Data | AutoFilter?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Caroline" wrote in message
...
Hello,
I have a simple table: header row is clients, 1st column are employees.
Each
employee is assigned a primary client and 1 or more secondary clients.
Where
the employee meets the primary client, a "P" is put in the cell. "S's"
are
put in cells where employees meet their 2ndary client(s). These P's and
S's
may vary daily.
I want to use a function to build two tables out of this data: one with
all
the employees names and their corresponding primary and secondary
clients,
and one with the clients name and their "primary" corresponding
employee.
This would change when the P's and S's would move in the main table.
I tried the LOOKUP function and it worked for most employees but not
all.
The order in which the P's and S's are is not what's affecting this.
Should I use a different function altogether? Will I have problem
having
more than one S in several rows? (If so, I can rename S1, S2, etc...)
Thank you,
Caroline