Try Data Filter AutoFilter.....then select YES from the drop down arrow
atop that column....

Vaya con Dios,
Chuck, CABGx3


"claw" wrote in message
...
I need to pull information from one collumn. If the collumn is comprised
of
yes's and no's, can excel create a list of just the yes's?