Please check file :
http://www.4shared.com/document/83CL1IDO/teste.html
On this file i can get results from a mapping, i have a problem.
Mapping is being done wrong. Result is given in column G.
Funcionality:
The function should check if the Date is the same day, and also if the Registo is the same, if yes then it should see the maximum value of Kgs, after this it should map this to 3 letters, it should also map all the other values that belong to the same date and registo. So for exampe if the maximum value is mapped to AAA then all the others should also be AAA.
What is wrong:
It is not checking for the maximum in the Kgs column, so mapping is not beeing done correctly.
I will be waiting for your feedback.
Thx and regards.
Bookmarks