Hi
I've got three groups of data over 9 rows.
Each group has duplicates and I'd like to delete the duplicate rows based on data in column C, which has Cash Sales.
In the table below,
column A has Product IDs,
column B has Product Names,
column C has Cash Sales and
column D has the Group ID
If a duplicate row is in the data, as is the case with rows 2 and 3, I would like to delete the row where the Cash Sales in column C are either greater OR equal to the other row where there is a duplicate Product ID.
So with rows 2 and 3, row 2 would be deleted because the Cash Sales in column C for row 2 are 100.
Whilst the Cash Sales in column C for the same product in row 3 are 50.
Has anyone done this before? Any thoughts would be greatly appreciated! TIA
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I've got three groups of data over 9 rows.
Each group has duplicates and I'd like to delete the duplicate rows based on data in column C, which has Cash Sales.
In the table below,
column A has Product IDs,
column B has Product Names,
column C has Cash Sales and
column D has the Group ID
If a duplicate row is in the data, as is the case with rows 2 and 3, I would like to delete the row where the Cash Sales in column C are either greater OR equal to the other row where there is a duplicate Product ID.
So with rows 2 and 3, row 2 would be deleted because the Cash Sales in column C for row 2 are 100.
Whilst the Cash Sales in column C for the same product in row 3 are 50.
Has anyone done this before? Any thoughts would be greatly appreciated! TIA
Product ID | Product Name | Cash Sales | Group ID |
1234 | Nice Marmalade 70g | 100 | 1234 |
1234 | Nice Marmalade 70g | 50 | 1234 |
2 | Nice Jam 70g | 0 | 1234 |
5678 | Cool Strawberry Juice 50ml | 200 | 5678 |
5678 | Cool Strawberry Juice 50ml | 100 | 5678 |
5 | Cool Orange Juice 50ml | 0 | 5678 |
2345 | Great Raspberry 70ml | 500 | 2345 |
7 | Great Grapefruit 70ml | 0 | 2345 |
2345 | Great Raspberry 70ml | 500 | 2345 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>