Delete duplicate cells in a row based on the best price in anothercell from another row

T

The Riot

I have the following information:

CUSIP A Sz(M) A Px
313380FJ1 29000 100
313380FJ1 14000 100
313380FJ1 25275 100
3133EAH68 48000 99.925
3133EAH68 46200 99.925
313380F44 19000 100
313380F44 23000 100
3133EAH27 29000 99.825
3133EAH27 9535 99.844

I have duplicate cells in the CUSIP column of which I want deleted based on (#1) the lowest price in the "A PX" column. If the price turns out to be the same for each then I would like to keep the cells in the column with highest "A Sz"

Thanks for your help.
 
D

Don Guillett

I have the following information:



CUSIP A Sz(M) A Px

313380FJ1 29000 100

313380FJ1 14000 100

313380FJ1 25275 100

3133EAH68 48000 99.925

3133EAH68 46200 99.925

313380F44 19000 100

313380F44 23000 100

3133EAH27 29000 99.825

3133EAH27 9535 99.844



I have duplicate cells in the CUSIP column of which I want deleted based on (#1) the lowest price in the "A PX" column. If the price turns out to be the same for each then I would like to keep the cells in the column with highest "A Sz"



Thanks for your help.
Click to expand...

You need a more complete explanation and examples.
send me your file dguillett @gmail.com if desired
 
Top