Hello All, I have a collumn called problem, in that collum i recieved a mapped value but it is doing it wrong.
I need the formula to get the highest value in "*Kgs*" Column (criteria same *date*, same *code_number)*. Based on the *Kgs *Maximum value, it has to get the "*code*" on the left side column and then map it to the 3 Letter Code on the right table. But there is a small problem, is that all the files that are smaller than the maximum that have the same *date *and *code_numbe*r number should also have the same 3 Letter code as the maximum. PS: Formula is in portuguese ,i believe PROCV is Vlookup or Lookup and SOMARPRODUTO is SUMPRODUCT -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
max.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
