Finding mismatched data automatically.
This query is : Resolved
01 December 2010
Dear All,
I have a master data sheet in excel format and it has to be compared with another work book on daily basis then please tell me that how I can find the data by a unique fourmula which indicate about the data which is differ by last updated data.
I have a master data sheet in excel format and it has to be compared with another work book on daily basis then please tell me that how I can find the data by a unique fourmula which indicate about the data which is differ by last updated data.
22 December 2010
Simply, Get both data in third sheet.
If your data has unique keys, get keys from master in one row and keys from other file in second row, and compare with "=".
e.g. =A1=B1
If a1 is equal to b1, it will give "True"
If a1 is not equal to b1, it will give "False".
If your data has unique keys, get keys from master in one row and keys from other file in second row, and compare with "=".
e.g. =A1=B1
If a1 is equal to b1, it will give "True"
If a1 is not equal to b1, it will give "False".
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- TDS 194-T applicability
- GST ITC REVERSE
- Fixe term employment
- Is any professional CA is here please reply
- Regarding Applicability of Tax Audit u/s 44AB
- Putting a heading on received mail
- RCM ISSUE ON RENT AND TRANSPORTATION CHARGES
- Consolidated financials
- TDS on TRUST
- Withdrawal in cash from partners capital account by partner
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
