sharky12345
Wellknown Member
 Joined
 Aug 5, 2010
 Messages
 3,373
 Office Version

 2016
 Platform

 Windows
I'm trying to use a MAX formula but with criteria as below;
On Sheet2, a formula that will look at the column C2 to the last used row on Sheet1. If the cell matches the value of A2 on Sheet2, then look at the range A2 to last used column on Sheet1 and identify the highest number and display that number. The issue may be that the values in the range A2 onwards on Sheet1 are like this and are formatted as general;
If that can be achieved, I want to do the same but extract the minimum number.
On Sheet2, a formula that will look at the column C2 to the last used row on Sheet1. If the cell matches the value of A2 on Sheet2, then look at the range A2 to last used column on Sheet1 and identify the highest number and display that number. The issue may be that the values in the range A2 onwards on Sheet1 are like this and are formatted as general;
CRHT01267
If that can be achieved, I want to do the same but extract the minimum number.