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

[PRADEEPB270]

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

[6StringJazzer]

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.

[malnahar]

Hi Pradeep,

Alternatively you can use the following formula in E5 : =IF(RIGHT(C5,1)="C",C5,"") and then drag it down to the end,

Then you can sort the data in another column


Regards

[martindwilson]

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

[6StringJazzer]

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!)

[martindwilson]

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