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

Formulas
 

Perhaps you want
datafilterautofilter

--
Don Guillett
SalesAid Software

"ohana" wrote in message
...
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