C
carl
I am trying to create a table based on data in 2 other
tables.
Table1 has my products listed in rows and assigned sales
people in columns. There is a 1 in the cell if the
salesperson has been assigned to sell the product.
Table1
JIM BOB JOE ED
BOX1 1 1 1
BOX2 1 1 1 1
BOX3 1 1
Table2 records sales. Only sales people that have made
sales in one of the products gets recorded on the
table2 - thus not all salespeople are listed in table2.
Table2
BOB ED
BOX1
BOX2 22 10
BOX3 10
I am trying to create a 3rd table that will have the same
rows and columns as table1, but look at table2 and tell
me if a salesperson was assigned but did not sell the
product. For example, Since JIM is assigned to sell BOX1
(Table1) but did not sell any BOX (Table2), Table3 tell ne
to check JIM/BOX1.
Table3
JIM BOB JOE ED
BOX1 check check check
BOX2 check check
BOX3 check
I think this is possible but cannot get it done.
Thank you very much (in advance).
tables.
Table1 has my products listed in rows and assigned sales
people in columns. There is a 1 in the cell if the
salesperson has been assigned to sell the product.
Table1
JIM BOB JOE ED
BOX1 1 1 1
BOX2 1 1 1 1
BOX3 1 1
Table2 records sales. Only sales people that have made
sales in one of the products gets recorded on the
table2 - thus not all salespeople are listed in table2.
Table2
BOB ED
BOX1
BOX2 22 10
BOX3 10
I am trying to create a 3rd table that will have the same
rows and columns as table1, but look at table2 and tell
me if a salesperson was assigned but did not sell the
product. For example, Since JIM is assigned to sell BOX1
(Table1) but did not sell any BOX (Table2), Table3 tell ne
to check JIM/BOX1.
Table3
JIM BOB JOE ED
BOX1 check check check
BOX2 check check
BOX3 check
I think this is possible but cannot get it done.
Thank you very much (in advance).