Mar 16 2021 02:08 AM
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
Mar 16 2021 02:46 AM
@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
Mar 16 2021 04:03 AM
I this the sort of thing you have in mind (it requires Excel 365)?
= INDEX(Table1,
XMATCH(UNIQUE(Table1[Product Code]), Table1[Product Code],0,-1),
{1,2,5,4})