Hello all,
Not a star excel user but am trying hard to increase my knowledge
Have a situation here where am trying to link dynamic data from a drop down list (Based on a sales rep name Cell A17) so that it returns the exact 2 top customers names based on the total product sold.
AM stuck with following formulae =VLOOKUP(LARGE(B3:B14,1),B3:$D$14,3,FALSE) and not able to find out how to link it to the drop down.
What am looking for is for Sales rep Estelle, the result is the name for her top 2 customers. Thus result being CAR LTD and Apple LTD.
Thanking you in advance.
<tbody>
</tbody><colgroup><col><col span="2"><col></colgroup>
Not a star excel user but am trying hard to increase my knowledge
Have a situation here where am trying to link dynamic data from a drop down list (Based on a sales rep name Cell A17) so that it returns the exact 2 top customers names based on the total product sold.
AM stuck with following formulae =VLOOKUP(LARGE(B3:B14,1),B3:$D$14,3,FALSE) and not able to find out how to link it to the drop down.
What am looking for is for Sales rep Estelle, the result is the name for her top 2 customers. Thus result being CAR LTD and Apple LTD.
Thanking you in advance.
1 | A | B | C |
2 | No of Products Sold | Sales Representative | Customer Name |
3 | 120 | Mike | Airplane Ltd |
4 | 10 | Estelle | Apple LTD |
5 | 30 | Lalanirina | Banana LTD |
6 | 90 | Lalanirina | Bicycle Ltd |
7 | 100 | Khadeeja | Boat Ltd |
8 | 80 | Heri | Bus Ltd |
9 | 70 | Estelle | Car Ltd |
10 | 40 | Khadeeja | Kiwi LTD |
11 | 60 | Mike | Litchi LTD |
12 | 50 | Yoshini | Mango LTD |
13 | 110 | Yoshini | Motorcycle Ltd |
14 | 20 | Heri | Orange LTD |
15 | |||
16 | Sales Rep | ||
17 | Estelle | ||
18 | |||
19 | Top 2 Customers per Sales Rep | ||
20 | Airplane Ltd | ||
21 | Boat Ltd |
<tbody>
</tbody><colgroup><col><col span="2"><col></colgroup>