I have a huge data sheet with columns such as VendorName, AcctDesp,JournalName,Amount etc and one blank column 'Category' on which I have to perform analysis . As a result of analysis this column should be populated with different categories.
To sort this data in categories I have rule sheet which has list of Vendor name With Category.
Like this I have other rulesheet with AccDesp and Category and few more.
I also have to define rules for amounts>some value and amount<somevalue.
Everything has priority and where the rules clashes the first rule should be given the priority.
Can any one suggest me the best way to do this please?