Please view the attached photo.
Column J, looks at column H. If it says "Active", then it displays "Last Name, First Name" from columns B & C.
Column K, looks at column H. If it says "In Active", then it displays "Last Name, First Name" from columns B & C.
In columns L & M, while it is displaying the same names - there is NO FORMULA at work there. It's an example of what I am trying to accomplish.
I would like column L, to look at column J and (1) group all names to top of list and (2) names are sorted alphabetically.
Is it possible to do what I am looking for, while only using a formula - and a basic formula at that? :)
I know what I want is possible via the use of formulas, I would just prefer the solution to be fairly easy to incorporate into my workbook.
Thank you in advance for your help!