Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 113
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excell error "Can't find Project or Library" Project VBAProject Lost in Excel Excel Worksheet Functions 0 April 12th 07 04:42 PM
cant find project or library pcor New Users to Excel 2 January 5th 07 03:52 AM
Excel sort application should work with Project WBS Ribas Excel Worksheet Functions 1 February 10th 06 04:10 PM
want to find what project is not on one list jerry Excel Discussion (Misc queries) 1 July 11th 05 07:45 AM
Can't find project or library Tracey Excel Discussion (Misc queries) 4 January 5th 05 05:19 PM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"