I have an array formula that works pretty good for me. I get a great deal of data with employees division, rank, and name. My array formula sepeartes them by division.

I want to add on to my array formula so that it seperates personnel by division and ALSO by one type of rank. I'm stuck.

Thanks for your help. I've included an example.

EMPLOYEE ARRAY.xlsx