Find the part codes having some indication and arrange them in a new column

My question is how many parts havinig end with C?Also arrange these parts in ascending order in a new column.

Please refer to the attached file and expected result also.

Regards

Pradeep Kumar Gupta

Here is a solution that requires two manual steps which you will perform every time you need to refresh the list. I have added a row that includes the criterion you are looking for. From there you need to use Advanced Filter. As your List Range, select your part numbers, including the header. As your Criteria Range, select the line I added (=*C) plus the header above. Check Copy to another location and select the desired location for output. To sort them, select the results and then use Sort.

If you want this to automatically keep your list up to date every time you make a change, you will need a VBA solution.

here's another way
btw @
6StringJazzer
i think youve posted the wrong workbook!

Originally Posted by martindwilson

here's another way
btw @
6StringJazzer
i think youve posted the wrong workbook!

Looks OK to me. Oddly enough it looks like you modified the workbook I posted. (And your solution is cooler!)

my apologies i didnt see the advanced filter criteria at the top ! and just assumed it was the original and used it myself