pmari
03-09-2012, 11:32 PM
Hi Friends,
I am working in an Excel file with product code and price with date of price in 3 different columns.
I need to retain rows with highest price for each product.
File having 20k plus rows and 4K product codes.
If result sheet may in same sheet after deleting rows or separate sheet.
Any guidance highly appreciated.
With Best Regards,PM
I am working in an Excel file with product code and price with date of price in 3 different columns.
I need to retain rows with highest price for each product.
File having 20k plus rows and 4K product codes.
If result sheet may in same sheet after deleting rows or separate sheet.
Any guidance highly appreciated.
With Best Regards,PM