So say you have 3 ranks, rank1 the most important, rank2 & rank3 to
break ties

How about looking at:
Rank = rank1 + rank2/1000 + rank3/1000000

(Assuming you've got <1000 sales guys...)


On 4 Feb, 19:29, "T. Valko" wrote:
UDF?

User Defined Function

The file looks like a demonstration file for a custom UDF that calculates
ranks.

Biff

"Michael Chappell" wrote in message

...

In article ,
T. Valko wrote:
That file really doesn't help. There's no raw data. What about that UDF?

Biff

UDF?

Michael