Hi All,
As shown below, column A & B are my source data. D2 is a drop down to select a month, and E2 is a drop down to select a client code. What I am looking for is a formula that will go into cell F2, that tells me the position no i.e. rank that the client code is from a unique listing of the client nos available in that month.
i.e. formula will say
Step 1) How many unique client nos do I have in the selected month.
Step 2) In that list of unique client nos, what position no is the selected client no.
Thank you
H
As shown below, column A & B are my source data. D2 is a drop down to select a month, and E2 is a drop down to select a client code. What I am looking for is a formula that will go into cell F2, that tells me the position no i.e. rank that the client code is from a unique listing of the client nos available in that month.
i.e. formula will say
Step 1) How many unique client nos do I have in the selected month.
Step 2) In that list of unique client nos, what position no is the selected client no.
Excel Workbook | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Client Code | Month | Month | Client Code | Position No. | |||
2 | 2 | Jan | Jan | 8 | 2 | |||
3 | 2 | Jan | ||||||
4 | 8 | Jan | ||||||
5 | 8 | Jan | ||||||
6 | 8 | Jan | ||||||
7 | 11 | Jan | ||||||
8 | 11 | Jan | ||||||
9 | 11 | Jan | ||||||
10 | 11 | Jan | ||||||
11 | 12 | Jan | ||||||
12 | 12 | Jan | ||||||
13 | 2 | Feb | ||||||
14 | 2 | Feb | ||||||
15 | 8 | Feb | ||||||
16 | 8 | Feb | ||||||
17 | 8 | Feb | ||||||
18 | 11 | Feb | ||||||
19 | 11 | Feb | ||||||
20 | 11 | Feb | ||||||
21 | 12 | Feb | ||||||
22 | 12 | Feb | ||||||
23 | 12 | Feb | ||||||
24 | 12 | Feb | ||||||
Sheet1 |
Thank you
H