Extracting data with multiple criteria and values
I have a spreadsheet that I am working on for a game I am playing. I have information from two different sports team rosters. As such, all of the players show twice on the raw data sheet. I would like to separate them and their stats into separate team sheets and only have the highest value for each stat show up.
|