ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   filtering common fields (https://www.excelbanter.com/excel-discussion-misc-queries/142637-filtering-common-fields.html)

Ajit Munj

filtering common fields
 
I have two sheets having data fed in by two diff depts of the same assessees
and for same period but some fields are matching and some fields are
mis-matching as it is fed in by two diff. depts. Now I want to delete the
rows having matching fields i.e. same month, same ecc_code, ecc_name,
challan_no,date_deposit. How can I do so?
sheet1 & sheet2
month ecc_code ecc_name amount challan_no date_deposit
Pl help.
Thanx
Ajit

--
Knowldege is Power


All times are GMT +1. The time now is 01:46 AM.

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