Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
web performance metrics chart help | Charts and Charting in Excel | |||
Protected cells and grouping | Excel Discussion (Misc queries) | |||
worksheet tabs do not respond to grouping | Excel Discussion (Misc queries) | |||
How to unprotect Grouping controls | Excel Worksheet Functions | |||
grouping of cells in protected sheets | Excel Worksheet Functions |