Get Max Value - Compare cloumn with condition

[pmari]

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

[shrivallabha]

You can do this by using Pivot Table and formula. Alternatively only formula can also be used. Even VBA can be implemented as well but it can be achieved using Excel's native capabilities.

See the attachment.

[pmari]

Dear Shrivallabhaji,

Thanks for your reply, will serve my purpose.