Hi All,
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?
Thanks in advance.
Regards,
S
