I am building a list of university supporters based on their constituent code. My export into excel includes a variety of possible codes. They are not presented in a uniform order. One person may be an alumnus, a board member and a parent. Another may be listed as a parent, an alumnus and a board member. I wish to distribute the column contents so that alumni are always in the first column, board members always in the second column, and parents always in the third column, and so on for up to 20 categories. Using an if= formula, I am able to do some basic distribution of the codes, but I don't know how to account for complexities. Can I combine requests in a formula, e.g. if b12 has alumni, write alumni in b15; if b12 has board member, write board member in b16. Or do I need to write a series of indivdiual formulas?
See tab two of attachment. annual report construction notes.xlsx
Bookmarks