Sort a list in referenced to code

Hi all,

Hope everyone is having an awesome day. I am trying to autosort (semi-autosort I guess) a list. I have a list of names in column A, in column B I want to put in a 'code/status'. whatever code I place in B would correspond with the name in A and output that name in another column (say E) which is for that particular code/status. i have attached a sample xls to get a better picture of the results. thank you in advance.

regards,

SN

Which version of Excel do you have? This is doable with a formula. Do you specifically want VBA?

2208 is a release number, not a version - if it's MS365, then please update your profile NOW.

For MS365:

=FILTER(A2:A10,B2:B10="good")
=FILTER(A2:A10,B2:B10="bad")
=FILTER(A2:A10,B2:B10="in progress")

Any questions?

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Please update your profile to MS365 NOW. Thanks.

Did you clear the entire results area first? Did you look at my sample workbook?

You still have not updated your profile - this is not just me nagging; it's IMPORTANT.

Why?

Please update your profile (for the fifth time of asking).

Just one last thing if I leave the code blank the output cell shows #CALC! error is there a way to get rid of it, so if there isn't a code attached it just shows a blank cell, not the #CALC! msg? can I use an IFERROR function in someway here?
thanks again