Hi,
I have a table of data that looks like below.
I need to be able to rank seperately both the TS & TM division sales whilst only looking at certain criteria, in this case 66 and 67 but these numbers just a small sample.
My actual worksheet is a dump with over 30 different Area's.
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
I have a table of data that looks like below.
I need to be able to rank seperately both the TS & TM division sales whilst only looking at certain criteria, in this case 66 and 67 but these numbers just a small sample.
My actual worksheet is a dump with over 30 different Area's.
Division | Area | Sales | Rank 66 & 67. | |
TS | 66 | 50 | 2 | |
TS | 66 | 50 | 3 | |
TS | 67 | 1 | 5 | |
TS | 68 | 90 | ||
TM | 66 | 80 | 1 | |
TS | 67 | 50 | 4 | |
TM | 66 | 60 | 2 | |
TM | 68 | 70 | ||
TM | 67 | 60 | 3 | |
TS | 66 | 100 | 1 |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>