SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2669485%22%20slang%3D%22en-US%22%3ERemoval%20Question%20with%20two%20Values...(maybe%20macros%20question)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2669485%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spread%20sheet%20with%20only%20two%20columns%2C%20Model%20Number%20and%20Price.%26nbsp%3B%20Right%20now%20I%20have%20a%20ton%20of%20duplicate%20Model%20Numbers%2C%20but%20with%20different%20prices.%26nbsp%3B%20I%20want%20to%20remove%20the%20Model%20numbers%20with%20the%20lower%20price%20and%20keep%20the%20higher%20price.%26nbsp%3B%20Is%20there%20a%20way%20to%20do%20that%20with%20a%20formula%20or%20maybe%20a%20macros%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Example%3A%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22281px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22165px%22%3E4DCY4024C1060*%3C%2FTD%3E%3CTD%20width%3D%2274.9844px%22%3E%243891.93%3C%2FTD%3E%3CTD%20width%3D%2240.0156px%22%3EKeep%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22165px%22%3E4DCY4024C1060*%3C%2FTD%3E%3CTD%20width%3D%2274.9844px%22%3E%243502.43%3C%2FTD%3E%3CTD%20width%3D%2240.0156px%22%3EDelete%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22165px%22%3E4DCY4030D1070*%3C%2FTD%3E%3CTD%20width%3D%2274.9844px%22%3E%244115.38%3C%2FTD%3E%3CTD%20width%3D%2240.0156px%22%3EKeep%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22165px%22%3E4DCY4030D1070*%3C%2FTD%3E%3CTD%20width%3D%2274.9844px%22%3E%243704.35%3C%2FTD%3E%3CTD%20width%3D%2240.0156px%22%3EDelete%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22165px%22%3E4DCY4036B3075*%3C%2FTD%3E%3CTD%20width%3D%2274.9844px%22%3E%244289.00%3C%2FTD%3E%3CTD%20width%3D%2240.0156px%22%3EKeep%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22165px%22%3E4DCY4036B3075*%3C%2FTD%3E%3CTD%20width%3D%2274.9844px%22%3E%243860.00%3C%2FTD%3E%3CTD%20width%3D%2240.0156px%22%3EDelete%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2669485%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2669511%22%20slang%3D%22en-US%22%3ERe%3A%20Removal%20Question%20with%20two%20Values...(maybe%20macros%20question)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2669511%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1059276%22%20target%3D%22_blank%22%3E%40rnelsch%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20might%20create%20a%20pivot%20table%20based%20on%20the%20data.%3C%2FP%3E%0A%3CP%3EAdd%20the%20Model%20Number%20field%20to%20the%20Rows%20area%20and%20the%20Price%20field%20to%20the%20Values%20area.%3C%2FP%3E%0A%3CP%3EChange%20the%20summary%20function%20for%20the%20Value%20Field%20from%20the%20default%20Sum%20to%20Max.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0699.png%22%20style%3D%22width%3A%20451px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304645i807A247F2E9FF748%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0699.png%22%20alt%3D%22S0699.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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