Need a brief test of duplicates in Excel.
1. There is a parent Excel file with 8000 single-value (such as emails or a uniqe number).
2. There is an additional (another) file of 1500 single-value data (such as emails or a uniqe number).
The purpose is to highlight (color or similar) in order to check that there are no duplicates of emails.
In other words the quick output is that the small file (1500) will show those lines who are aleady exist in the father file
80 фрилансеров(-а) в среднем готовы выполнить эту работу за $28
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hello, Just share the file and I will highlight the duplicate cells and revert the file with highlighted cells for duplicate values. it will take 5 min. for me to complete. Thanks, Ramveer
I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start
Hello, You can easily do this with a conditional formatting: Select all data, goto Home -> Conditional Formatting -> Highlight Cell Rules -> Duplicated values. Kind regards, Sorin