Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identifying adjacent cells
If there is a better way to do this, I am certainly open to suggestions, but here it is. I have 2 worksheets. Worksheet 1 has the master set of data. There is a list of people with scores for each one in a variety of games. On worksheet 2, I want to list the bottom 5 scores in each game with the name of the person next to each score. I can identify the lowest 5 scores with the small function. I want sheet 2 to display the name that is in the cell next to the lowest score found on sheet 1. The name can be displayed in the same cell or in an adjacent cell on sheet 2. Hope this problem description makes sense. Thanks for any help. -- daddioja ------------------------------------------------------------------------ daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024 View this thread: http://www.excelforum.com/showthread...hreadid=547728 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Fill cells if adjacent cell match criteria | Excel Discussion (Misc queries) | |||
Text comparison in adjacent cells | Excel Discussion (Misc queries) | |||
Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) |