Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
Hello folks,
I'm trying to use Offset in my formula but I'm getting nowhere. Your advice will be most appreciated.
In cell E33 I have: =max(E8:E31)
In cell D33 I want to show the corresponding name (in A8:A31) to the maximum value shown in E33. It is possible that there might be more than one name to display. How might I achieve this?
Mel
I'm trying to use Offset in my formula but I'm getting nowhere. Your advice will be most appreciated.
In cell E33 I have: =max(E8:E31)
In cell D33 I want to show the corresponding name (in A8:A31) to the maximum value shown in E33. It is possible that there might be more than one name to display. How might I achieve this?
Mel