willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 893
- Office Version
- 365
- Platform
- Windows
I need help with a formula to help me match column C with A, find the max value in column B and return that value.
The formula would be in column D (see below image). These are the results I am hoping to get. Unfortunately there are letters mixed in with numbers so I am unsure how to get around this.
Thank you to anyone who can help.
The formula would be in column D (see below image). These are the results I am hoping to get. Unfortunately there are letters mixed in with numbers so I am unsure how to get around this.
Thank you to anyone who can help.