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
- CG Tax On residential property
- Applicable TDS for Purchase of Flat from NRI
- Claiming exemption of perquisite for employee-owned car under New Tax Regime in ITR-2
- Pass word to open justification report for Q1 for FY 2026-27
- Gift of mutual fund units to daughter
- PPF interest-As Exempt Income disclosure
- Under construction property in ITR
- Not able to file ITR
- Building tax payment deduction in rental Income
- NRI ITR2 account in 2025-26 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
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
