Maybe you can apply data|filter|autofilter to that column and then use a custom
filter to show the cells that Contain pioneer.

Jessica wrote:

Hi,

How can I find/ sort all Part no. of Project Pioneer from below table?

Part no. Description Project 1 Project 2
50-00117 A Rose -
50-01009 B Rose -
50-00118 C Excel Pioneer
50-01010 D Pioneer Super
50-01011 E Pioneer Super

Thanks a lot.

Jessica from HK

--

Dave Peterson