@Gopigk
Member
Dear all,
we need here to find duplicate values in excel sheet in one column based on other column(s).
we receive daily many number of invoices from multiple sources, i.e., from vendors, from Plants, from marketing people & sometimes from other sources, to one place for accounting. Here, we used to enter all these Invoice receipt data in one excel sheet at one point, i.e, at courier help desk, and from there that person forward these Invoices to various people to process. In these scenario, we are receiving so many duplicate Invoices sometimes receiving one invoice many times. Now we want a Excel Formula/Macro to eliminate these duplicates at Initial state only, i.e., at Courier desk point only, so that it will help others (processors) to save their time that not to spent time to find these as a duplicate at process level.
Request to do the needful on this issue, it will help us a lot.
Thanks in advance
we need here to find duplicate values in excel sheet in one column based on other column(s).
we receive daily many number of invoices from multiple sources, i.e., from vendors, from Plants, from marketing people & sometimes from other sources, to one place for accounting. Here, we used to enter all these Invoice receipt data in one excel sheet at one point, i.e, at courier help desk, and from there that person forward these Invoices to various people to process. In these scenario, we are receiving so many duplicate Invoices sometimes receiving one invoice many times. Now we want a Excel Formula/Macro to eliminate these duplicates at Initial state only, i.e., at Courier desk point only, so that it will help others (processors) to save their time that not to spent time to find these as a duplicate at process level.
Request to do the needful on this issue, it will help us a lot.
Thanks in advance
