I have to define some 12 categories, satisfying conditions from multiple different columns(some are string, some are no.). How should I go on proceeding with this. If I use nested if, it will take 12 if statements. Is there a faster and nice way to do this.
E.g. Cat 1 if it satisfies conditions from Col A, B,F,Y (some of these columns are string like Yes/No, names and some are no.)
Cat 2 if it satisfies conditions from Col B, E,G,I,M,O,U (some of these columns are string like Yes/No, names and some are no.)
Cat 3 if it satisfies conditions from Col D, H,L,N,Y,Z (some of these columns are string like Yes/No, names and some are no.)
and so on..
How to go on about this
Bookmarks