Hi All,

I have a list of values sorted in ascending order with an accompanying 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 within two of this value - (7J and 8S)
- Level 3 consists of the next value (10P) and any other value/s within four of this value (12A and 13T)

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

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

Thanks in advance for any assistance.

Barry