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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate entry in a column/row 14
Reposition Cells in a Column based on another 2
loop until empty row and column problem (format cells until the lastrow and column in a report) 4
Array with many cells from a row but not in order or together 11
Populate cells based on row selection 1
Hghlight the best price for each row 5
Row highlight based on the 1-31 day of the month 8
Named cells in an array to a column and to a row 3

Top