Hi Guys,
I have big excel file I have unique ID then client and price the issue i have unique ID can be the same on 7 raws I need to remove all of inuqie ids based if price is lower then 3 but I need to delete all 7 raws as price of first can be 2.94 but second 4.54 see example:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>So I want to delete top4 and then keep next because Price is over 5.8
Thank u
I have big excel file I have unique ID then client and price the issue i have unique ID can be the same on 7 raws I need to remove all of inuqie ids based if price is lower then 3 but I need to delete all 7 raws as price of first can be 2.94 but second 4.54 see example:
121518578 | 2.989445 | |
121518578 | 4.065677 | |
121518578 | 8.4 | |
121518578 | 170.6262 | |
121637552 | 5.855528 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Thank u