I want to delete duplicate rows in Excel using Data Table. In this example, I want to delete rows where the item_no and amount are the same and I need only one record.
I want to delete rows highlight in yellow. If there is solution, please provide me. Thanks.
I also attached file for reference.
New.xlsx (9.0 KB)