I have a large amount of data with columns for Division, Department, and Account. I want to assign a category to every row of data based on complex criteria in those columns. Here are some examples:
Category is "Absorption" if Division is not 000, Department is either 000 or in the range of 500-599, and Account is in the range of 60000-69999.
Category is "Logistics" if Department is in the range of 700-799 and Account is in the range of 60000-69999 but is not 64600 or 64625.
I can do this with multiple advanced filters but was wondering if there is a way to do this with formulas. Any help would be greatly appreciated!
Category is "Absorption" if Division is not 000, Department is either 000 or in the range of 500-599, and Account is in the range of 60000-69999.
Category is "Logistics" if Department is in the range of 700-799 and Account is in the range of 60000-69999 but is not 64600 or 64625.
I can do this with multiple advanced filters but was wondering if there is a way to do this with formulas. Any help would be greatly appreciated!
