Should be simple, but I'm banging my head against the wall. If I have the below data in cells A1:B9, how do I pull the max B-column value for each A-column category. E.g. I want to ask "Considering ONLY the rows with JAN in the A-column, what's the max value in the B-column?" (So formula would return: 30 for Jan, 5 for Feb, 27 for Mar, and 8 for Apr)
Jan 1
Jan 8
Feb 5
Mar 13
Jan 7
Mar 27
Feb 1
Apr 8
Jan 30
Jan 1
Jan 8
Feb 5
Mar 13
Jan 7
Mar 27
Feb 1
Apr 8
Jan 30