Quote:
|
Does this work? I've changed it to only look at column 2 for deleting duplicates and only look at column 3 for your word count. Is that right?
|
This Condition was exactly right and above codes work exactly but there was a mismatch of WC through VBA & Manual doing.
WC should be calculated after deleting a duplicate rows and range for WC is from 4th row & 3rd Column, Please find the above ZIP attachment for sample doc.
Through VBA WC is 86 & Manully WC is 73.
Its work very closely...
Plesee find the below link....
https://www.linkpicture.com/q/Macro_...-Duplicate.jpg
https://www.linkpicture.com/q/Manully_1.jpg