Having tried for hours to work out the solution myself I am throwing in the towel, can anyone please help me out? I will be doing this many times so would like to avoid using pivot table and copy paste from that.
So I am trying to use VBA to go through a document and delete all duplicate rows with a high number
My data looks like this (hundres of rows):
<tbody>
</tbody>
The macro should then return a document that will look like this: (having deleted all rows with high values on duplicates, but retained low values on duplicates and non-duplicates)
<tbody>
</tbody>
There must be a way to do this?
So I am trying to use VBA to go through a document and delete all duplicate rows with a high number
My data looks like this (hundres of rows):
Part Number | Price |
20040 | 1500 |
20038 | 1000 |
20038 | 1300 |
20034 | 4000 |
20040 | 3000 |
20040 | 1200 |
<tbody>
</tbody>
The macro should then return a document that will look like this: (having deleted all rows with high values on duplicates, but retained low values on duplicates and non-duplicates)
Part Number | Price |
20040 | 1200 |
20038 | 1000 |
20034 | 4000 |
<tbody>
</tbody>
There must be a way to do this?