Performance Grouping

[Barry Taylor]

Hi All,

I have a list of values sorted in ascending order with an accompanyin
ID(name) for each value in the adjacent column e.g.
3 D
5 K
6 Z
7 J
8 S
10 P
12 A
13 T
16 L

I am looking for a way to assign performance levels to the ID's (names
such that :
- Level 1 consists of the top value and any other value/s within *two
of this value - (3D & 5K)
- Level 2 consists of the next value (6Z) and any other value/s withi
*two* of this value - (7J and 8S)
- Level 3 consists of the next value (10P) and any other value/s withi
*four* of this value (12A and 13T)

16L falls outside the range of the three levels and would return a nul
value.

Any sort of a workaround of the problem would be great - it doesn'
have to be accomplished with one formula.

Thanks in advance for any assistance.

Barr