nitika.manhas
Member
Hello to all the experts,
I have attached the file for more clarity. Please look at the file to follow my question-
I have some duplicate item numbers in the sheet; I only want to keep the items with lower qty on hand. For example, Item number 100-00373 is listed twice (row 5 and 6), one is 307, and another one is 258, I want to keep 258 and delete the other line from the file. I want to do this for all the duplicate lines.
Please suggest some easy way as I am currently doing it manually.
Regards
Nitika
I have attached the file for more clarity. Please look at the file to follow my question-
I have some duplicate item numbers in the sheet; I only want to keep the items with lower qty on hand. For example, Item number 100-00373 is listed twice (row 5 and 6), one is 307, and another one is 258, I want to keep 258 and delete the other line from the file. I want to do this for all the duplicate lines.
Please suggest some easy way as I am currently doing it manually.
Regards
Nitika