I have a spreadsheet and want to find the MAX value in a column, but only if the number in another column equals say 1 for instance. What formula would I need to use?
For example I have 10 rows in column A the max number is 40 and the lowest is 13. In column B are various numbers from 1-5, and 4 of them are 1's. In want to know what the Max number is in column A, on the 4 1's. I could do this by filtering for simple info like this, but I need to know for 1000's of rows.
Any help would be great.