View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cdavidson cdavidson is offline
external usenet poster
 
Posts: 13
Default 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!