PDA

View Full Version : Get Max Value - Compare cloumn with condition



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

shrivallabha
03-10-2012, 01:11 AM
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
03-10-2012, 05:10 AM
Dear Shrivallabhaji,

Thanks for your reply, will serve my purpose.