> > 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
