B
BenjieLop
Assume I have the following data that tabulates the sale of widgets b
each salesperson for the firt half of the year (6 months):
******* JAN FEB MAR APR MAY JUNE
Richards 10 15 20 25 30 35
Jones 2 4 6 8 10 12
Smith 1 3 5 7 9 11
Watkins 3 6 9 12 15 18
Blake 5 10 15 20 25 30
If I need to know how many widgets, say, Smith sold in the month o
May, I will get an answer of 9 (This procedure I can formulate i
Excel).
Here is where I am stuck at. My first situation is:
1. I want to know who sold, say, 9 widgets in May
and my second situation is:
2. I want to know, say, what month Smith sold 9 widgets.
I hope someone out there can help me with the formulas.
Thanks in advance.
BenjieLo
each salesperson for the firt half of the year (6 months):
******* JAN FEB MAR APR MAY JUNE
Richards 10 15 20 25 30 35
Jones 2 4 6 8 10 12
Smith 1 3 5 7 9 11
Watkins 3 6 9 12 15 18
Blake 5 10 15 20 25 30
If I need to know how many widgets, say, Smith sold in the month o
May, I will get an answer of 9 (This procedure I can formulate i
Excel).
Here is where I am stuck at. My first situation is:
1. I want to know who sold, say, 9 widgets in May
and my second situation is:
2. I want to know, say, what month Smith sold 9 widgets.
I hope someone out there can help me with the formulas.
Thanks in advance.
BenjieLo