SOLVED

Removal Question with two Values...(maybe macros question)

Copper Contributor

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.93Keep
4DCY4024C1060*$3502.43Delete
4DCY4030D1070*$4115.38Keep
4DCY4030D1070*$3704.35Delete
4DCY4036B3075*$4289.00Keep 
4DCY4036B3075*$3860.00Delete
2 Replies
best response confirmed by rnelsch (Copper Contributor)
Solution

@rnelsch 

You 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.

 

S0699.png

Brilliant...thank you
1 best response

Accepted Solutions
best response confirmed by rnelsch (Copper Contributor)
Solution

@rnelsch 

You 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.

 

S0699.png

View solution in original post