Performance Grouping
 

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


--
Barry Taylor
------------------------------------------------------------------------
Barry Taylor's Profile: http://www.excelforum.com/member.php...o&userid=20541
View this thread: http://www.excelforum.com/showthread...hreadid=511644