Hi everyone.
How can i copy duplicated records from sheet1 to sheet 2 automaticaly. By formula.
Hi everyone.
How can i copy duplicated records from sheet1 to sheet 2 automaticaly. By formula.
You cannot "copy" by formula, you can display cell results or identify them, however you would have to copy the formula down for as many duplicates as you think you may have, when the source data changes then so will the results on sheet 2, the only way to find and copy all your duplicates is via code which then gives rise to other questions, do you want to show a duplicate and then a count of how many or just display the duplicates, would you want to delete the duplicates on the source sheet?, do you want to show the address of the duplicate?....just to name a few questions!
Not all forums are the same - seek and you shall find
Thank you very much. I want to select duplicated records and to separate them. If i can, copy duplicated record to new sheet, even may be their addresses.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks