Thread: look for text not using vlookup and sum if
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default look for text not using vlookup and sum if
=OFFSET(A1,MATCH(MAX(B:B),B:B)-1,0)

--
Gary''s Student - gsnu200836
Reply With QuoteReply With Quote