ellyzadg
Board Regular
- Joined
- May 9, 2016
- Messages
- 75
Hi Everyone,
Would like to ask correct formula on how to deal with ranking tie ups. Thank you in advance!
Below are my sample data and desired result
[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee ID[/TD]
[TD]Sales Person[/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD]S00001[/TD]
[/TR]
[TR]
[TD]S00002[/TD]
[/TR]
[TR]
[TD]S00003[/TD]
[/TR]
[TR]
[TD]S00004[/TD]
[/TR]
[TR]
[TD]S00005[/TD]
[/TR]
[TR]
[TD]S00006[/TD]
[/TR]
[TR]
[TD]S00007[/TD]
[/TR]
[TR]
[TD]S00008[/TD]
[/TR]
[TR]
[TD]S00009[/TD]
[/TR]
[TR]
[TD]S00010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 125"]
<tbody>[TR]
[TD]Richard Tan[/TD]
[/TR]
[TR]
[TD]Bernadeth Milante[/TD]
[/TR]
[TR]
[TD]Isamael Gamba[/TD]
[/TR]
[TR]
[TD]Grace Dineros[/TD]
[/TR]
[TR]
[TD]Jenette Calderon[/TD]
[/TR]
[TR]
[TD]Joseph Solidum[/TD]
[/TR]
[TR]
[TD]Leny Patricio[/TD]
[/TR]
[TR]
[TD]Marvin Delacroix[/TD]
[/TR]
[TR]
[TD]Jace Balaren[/TD]
[/TR]
[TR]
[TD]Liliana Vess[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD] $ 45,441.00[/TD]
[/TR]
[TR]
[TD] $ 12,543.00[/TD]
[/TR]
[TR]
[TD] $ 45,441.00[/TD]
[/TR]
[TR]
[TD] $ 23,144.00[/TD]
[/TR]
[TR]
[TD] $ 12,354.00[/TD]
[/TR]
[TR]
[TD] $ 35,311.00[/TD]
[/TR]
[TR]
[TD] $ 42,645.00[/TD]
[/TR]
[TR]
[TD] $ 42,623.00[/TD]
[/TR]
[TR]
[TD] $ 19,820.00[/TD]
[/TR]
[TR]
[TD] $ 16,336.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Outcome
[TABLE="width: 500"]
<tbody>[TR]
[TD]Rank[/TD]
[TD]Sales[/TD]
[TD]Salesperson (what i get)[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD][TABLE="width: 91"]
<tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD] $ 45,441.00[/TD]
[/TR]
[TR]
[TD] $ 45,441.00[/TD]
[/TR]
[TR]
[TD] $ 42,645.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD]Richard Tan[/TD]
[/TR]
[TR]
[TD]Richard Tan[/TD]
[/TR]
[TR]
[TD]Leny Patricio[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD]Richard Tan[/TD]
[/TR]
[TR]
[TD]Ismael Gamba[/TD]
[/TR]
[TR]
[TD]Leny Patricio[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks!
Would like to ask correct formula on how to deal with ranking tie ups. Thank you in advance!
Below are my sample data and desired result
[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee ID[/TD]
[TD]Sales Person[/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD]S00001[/TD]
[/TR]
[TR]
[TD]S00002[/TD]
[/TR]
[TR]
[TD]S00003[/TD]
[/TR]
[TR]
[TD]S00004[/TD]
[/TR]
[TR]
[TD]S00005[/TD]
[/TR]
[TR]
[TD]S00006[/TD]
[/TR]
[TR]
[TD]S00007[/TD]
[/TR]
[TR]
[TD]S00008[/TD]
[/TR]
[TR]
[TD]S00009[/TD]
[/TR]
[TR]
[TD]S00010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 125"]
<tbody>[TR]
[TD]Richard Tan[/TD]
[/TR]
[TR]
[TD]Bernadeth Milante[/TD]
[/TR]
[TR]
[TD]Isamael Gamba[/TD]
[/TR]
[TR]
[TD]Grace Dineros[/TD]
[/TR]
[TR]
[TD]Jenette Calderon[/TD]
[/TR]
[TR]
[TD]Joseph Solidum[/TD]
[/TR]
[TR]
[TD]Leny Patricio[/TD]
[/TR]
[TR]
[TD]Marvin Delacroix[/TD]
[/TR]
[TR]
[TD]Jace Balaren[/TD]
[/TR]
[TR]
[TD]Liliana Vess[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD] $ 45,441.00[/TD]
[/TR]
[TR]
[TD] $ 12,543.00[/TD]
[/TR]
[TR]
[TD] $ 45,441.00[/TD]
[/TR]
[TR]
[TD] $ 23,144.00[/TD]
[/TR]
[TR]
[TD] $ 12,354.00[/TD]
[/TR]
[TR]
[TD] $ 35,311.00[/TD]
[/TR]
[TR]
[TD] $ 42,645.00[/TD]
[/TR]
[TR]
[TD] $ 42,623.00[/TD]
[/TR]
[TR]
[TD] $ 19,820.00[/TD]
[/TR]
[TR]
[TD] $ 16,336.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Outcome
[TABLE="width: 500"]
<tbody>[TR]
[TD]Rank[/TD]
[TD]Sales[/TD]
[TD]Salesperson (what i get)[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD][TABLE="width: 91"]
<tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD] $ 45,441.00[/TD]
[/TR]
[TR]
[TD] $ 45,441.00[/TD]
[/TR]
[TR]
[TD] $ 42,645.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD]Richard Tan[/TD]
[/TR]
[TR]
[TD]Richard Tan[/TD]
[/TR]
[TR]
[TD]Leny Patricio[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD]Richard Tan[/TD]
[/TR]
[TR]
[TD]Ismael Gamba[/TD]
[/TR]
[TR]
[TD]Leny Patricio[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks!
Last edited: