Aug 20 2021 07:50 AM
I have a spread sheet with only two columns, Model Number and Price. Right now I have a ton of duplicate Model Numbers, but with different prices. I want to remove the Model numbers with the lower price and keep the higher price. Is there a way to do that with a formula or maybe a macros?
For Example:
4DCY4024C1060* | $3891.93 | Keep |
4DCY4024C1060* | $3502.43 | Delete |
4DCY4030D1070* | $4115.38 | Keep |
4DCY4030D1070* | $3704.35 | Delete |
4DCY4036B3075* | $4289.00 | Keep |
4DCY4036B3075* | $3860.00 | Delete |
Aug 20 2021 07:58 AM
SolutionYou might create a pivot table based on the data.
Add the Model Number field to the Rows area and the Price field to the Values area.
Change the summary function for the Value Field from the default Sum to Max.
Aug 20 2021 09:10 AM
Aug 20 2021 07:58 AM
SolutionYou might create a pivot table based on the data.
Add the Model Number field to the Rows area and the Price field to the Values area.
Change the summary function for the Value Field from the default Sum to Max.