LinkBack URL
About LinkBacks
Hi,
I am looking for a VBA code to find duplicate document numbers but having different voucher no. Please refer to attached file for more information.
Thanks in advance
Hi,
I am looking for a VBA code to find duplicate document numbers but having different voucher no. Please refer to attached file for more information.
Thanks in advance
You may try following code:
Of course this is just a test and show approach. But it can be used as a backbone to for instance write comments next to each duplicate, list them in a separate table, store all in a string variable and show only one comment at the end of processing, etc.
Please Login or Register to view this content.
Last edited by Kaper; 03-13-2020 at 04:20 AM.
Best Regards,
Kaper
Exactly. But, can you help me to built a public function like =duplicate() to find this duplicates. Sorry, but I am a beginner and do not know how to built public function
Try:
Please Login or Register to view this content.
Sorry, but how to use this? What i have to type?
Anyone please help me. I am looking for public function (so that I can use in Column 'C') to find duplicates Or else, please suggest a macro to get 'Duplicates' in column 'C'.
I don't want a message box saying it. Instead I want the same thing in the column 'C' against said line item.
Please help me in change the above public function or VBA code.
For such application there is really no need to use VBA at all.
Standard function would do it perfectly well.
Try in C2:
and copy the C2 cell down. The easiest way is by selecting C2 and double click on filling handle (a small black square in lower-right corner of selection frame)Formula:
Please Login or Register to view this content.
You are genius. Thanks for the formula.Originally Posted by Kaper
For such application there is really no need to use VBA at all.
Standard function would do it perfectly well.
Try in C2:
and copy the C2 cell down. The easiest way is by selecting C2 and double click on filling handle (a small black square in lower-right corner of selection frame)Formula:Please Login or Register to view this content.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a not-so-frequent visitor of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
The formula is working fine..but i m having 15000 rows and thereby it is taking too much time..
Can you help me to find duplicate document number from 15000 rows in column C
Please help.. How to use this countifs function faster on 15000 rows
Having no more clues (like: are rows sorted by document number + how many documents of one type could be present in dataset) I would say:
Copy the formula down. Let the spreadsheet calculate once (press F9 to force it if needed).
Select all but first cells with formula (now displaying results) copy it and paste special in the same range as values only.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks