Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a productivity spreadsheet, where I track the productivity
numbers for a number of individuals. Each worksheet ("tab" if you prefer) is a different persons name. Each tab has columns for: A: week#, B: time, items, C: errors, D: items per hour, E: accuracy. I know I can find the max value across the sheets by using: =MAX('1st:End'!D3), but that doesn't tell me which person achieved that number. I'd be happy with it either returning the tab name, or the contents of cell A1. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning contents of a cell in another sheet in same workbook | Excel Discussion (Misc queries) | |||
how do i list the name off all my worksheets on a sheet | Excel Worksheet Functions | |||
returning a sheet to blank orginal status? | Excel Discussion (Misc queries) | |||
Returning data to Excel sheet from MS query | Excel Discussion (Misc queries) | |||
vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) |