Return a value based on two criteria
Column A contains various text (e.g. Player, Cut)
Column B contains numeric scores (e.g. -1, 0, 5, 6, 11, etc.)
All I want is a formula which will return the largest value from column B,
where column A contains the text 'Player'
Thanks for the assistance!
|