Thread: how can the necessary information be extracted?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default how can the necessary information be extracted?
Same as above, but shorter formula:
=MODE(IF(List1=D1,List2,""))

Reply With QuoteReply With Quote