Thread: how can the necessary information be extracted?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default how can the necessary information be extracted?
On 12 Jan 2007 09:17:57 -0800, "Herbert Seidenberg"
wrote:

Same as above, but shorter formula:
=MODE(IF(List1=D1,List2,""))

Not quite the same. If there are no duplicate data points, you formula returns
#N/A


Ron's formula returns one of the values which, based on the OP's example, would
seem to be what he wants.
--ron
Reply With QuoteReply With Quote