Please Help!
I got these codes of running duplicates but it seems that it only recognizes TEXT but i am looking for duplicates according to Number/Series.
I have an attached sample.
Thanks
Please Help!
I got these codes of running duplicates but it seems that it only recognizes TEXT but i am looking for duplicates according to Number/Series.
I have an attached sample.
Thanks
Hello candyfreak,
I find all in order, and cannot see any duplicated text or numbers that are not listed on the "Duplicated Report".it only recognizes TEXT but i am looking for duplicates according to Number/Series.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Thankyou for your reply Winon..
if duplicate. ast the "number of duplicates" column will count and list down how many times the number or series appears. and if there is no duplicate.. i dont want it to appear in the Duplicate tab..
For instance, in 1st sheet Column A I have 123 and in the 2nd sheet Column A I have 123
Then, in the Duplicate Report will post 123 and the agent/s could not be the same and how many time it appears like "2"
So, if 123 doesnt have any match or duplicates in the next sheet then don't let it appear at the duplicate report.
Sorry if it's confusing.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks