| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return value from range of worksheets
I am trying to return the name of a person who worked the most hours in my
volunteer table. The columns include the person's name, date worked, number of hours per shift and total hours worked. There are 100+ people that each have their own worksheet. I would like to use a lookup to return the name of the person with the most hours. How would I do this? I tried grouping the sheets and referencing the ranges I want to use. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return date if in range, else return blank | Excel Worksheet Functions | |||
| compare two worksheets and return a corresponding column | Excel Discussion (Misc queries) | |||
| Compare 2 Worksheets and return differences in a third. | Excel Worksheet Functions | |||
| matching two worksheets and return to different value | Excel Worksheet Functions | |||
| Function to Return another Worksheets Name | Excel Worksheet Functions | |||
Threaded Mode
