Thread: Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ohana
 
Posts: n/a
Default Formulas

In column E I want a formula to select all the rows with the number two and
from that data I want a formula to select all the rows with the number 17.
Is there a formula that can do this? I have tried several different
formulas but they do not do both functions.

Column E Column F
2 17
2 17
2 33
2 19
1 17
1 32