ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting duplicate rows based on 3 column match (https://www.excelbanter.com/excel-programming/435013-deleting-duplicate-rows-based-3-column-match.html)

rajakp123

Deleting duplicate rows based on 3 column match
 

from attachment row no 3 or 5 should be deleted since processor id, WIR
NO and worktype is matching.


+-------------------------------------------------------------------+
|Filename: Stats Report.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=324|
+-------------------------------------------------------------------+

--
rajakp123
------------------------------------------------------------------------
rajakp123's Profile: http://www.thecodecage.com/forumz/me...hp?userid=1051
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=144717


Simon Lloyd[_1271_]

Deleting duplicate rows based on 3 column match
 

Rajakp123, posting in these newsgroup forums means that the good folk
here cannot see your attachment, you will need to give a better
explanation of what you have and what you would like to see happen!

rajakp123;526925 Wrote:
from attachment row no 3 or 5 should be deleted since processor id, WIR
NO and worktype is matching.



--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=144717



All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com