Remove duplicates from column A with unique should pick latest cost from cost column B

%3CLINGO-SUB%20id%3D%22lingo-sub-2213240%22%20slang%3D%22en-US%22%3ERemove%20duplicates%20from%20column%20A%20with%20unique%20should%20pick%20latest%20cost%20from%20cost%20column%20B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2213240%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EI%20have%20number%20of%20rows%20in%20excel%2C%26nbsp%3B%20have%20one%20column%20of%20consist%20of%20product%20code%20(Column%20A)%20and%20one%20column%20consist%20of%20cost%20of%20that%20product%20(Column%20B)%2C%20and%20also%20other%20columns%20consists%20of%20date%20of%20in%20%2C%20description%20etc.%20Now%20i%20want%20to%20make%20(column%20A)%20my%20product%20code%20be%20unique%26nbsp%3B%20with%20no%20duplicates%2C%26nbsp%3B%20but%20that%20unique%20code%20should%20pick%20latest%20cost%20from%20Cost%20column%20(column%20B)%2C%20by%20referencing%20date%20column.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EPlease%20help%20me%20by%20replying%20or%20calling%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%2B91-8801222475%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%2B971-501689744%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Eskype%20%3A%20kazim.kazim41%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2213240%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have number of rows in excel,  have one column of consist of product code (Column A) and one column consist of cost of that product (Column B), and also other columns consists of date of in , description etc. Now i want to make (column A) my product code be unique  with no duplicates,  but that unique code should pick latest cost from Cost column (column B), by referencing date column.

 

Please help me by replying or calling

+91-8801222475

+971-501689744

skype : kazim.kazim41

2 Replies

@Mohammed_Kazim I think pivot table can do your job, but ensure that your dates are sorted in pivot table , then you can see for each product latest price

@Mohammed_Kazim 

I this the sort of thing you have in mind (it requires Excel 365)?

image.png

= INDEX(Table1, 
  XMATCH(UNIQUE(Table1[Product Code]), Table1[Product Code],0,-1),
  {1,2,5,4})