Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 02-10-2022, 11:38 PM
ranjan ranjan is offline Removing  Identical Rows Windows 10 Removing  Identical Rows Office 2019
Advanced Beginner
Removing  Identical Rows
 
Join Date: May 2021
Posts: 80
ranjan is on a distinguished road
Default

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
Reply With Quote
 

Tags
delete, identical



Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing  Identical Rows Removing rows when mail merging Richystab Mail Merge 3 12-07-2020 03:05 AM
Identical computers MeCasa Office 0 09-23-2019 03:43 PM
Removing duplicate rows when identical value in a column ballpoint Excel 1 01-05-2018 08:54 AM
how to delete every blank and non-numeric rows without removing the header enuff Excel 3 08-24-2017 05:56 AM
Removing  Identical Rows How to find an identical sentences? Bill K Word 1 12-03-2015 12:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft