I have data with a lot of rows and 7 columns. I then want get the largest number of all the numbers in column 1 where the cells in column 2-7 match certain criteria’s. So if the cells in column 2-7 of a row don’t match the criteria’s, the number in column 1 of that row should not be accounted for when finding the max value.