Thread: How to look up a value in a list and return multiple corresponding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
worksheet functions worksheet functions is offline
external usenet poster
  
Posts: 1
Default How to look up a value in a list and return multiple corresponding
I can make the formula look up anumber but i need it to look for a specific
word. What can i replace "SMALL" with to have the formula bring all intances
of the word "Active" =SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1) )
Reply With QuoteReply With Quote