ExcelBanter - How can I find/ sort all Part no. of Project Pioneer?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I find/ sort all Part no. of Project Pioneer? (https://www.excelbanter.com/excel-discussion-misc-queries/139701-how-can-i-find-sort-all-part-no-project-pioneer.html)

Jessica

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

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

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

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

All times are GMT +1. The time now is 08:45 AM.