Save Rs 499 on a 2-Year Ad-Free CAclubindia Pro Membership. Subscribe Now!

banner_ad

Finding mismatched data automatically.

This query is : Resolved

Share Report Follow Query Ask a Query

Dharam Prakash Singh

Dharam Prakash Singh (Querist)
Follow

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.

Ramkrishna Mokashi

Ramkrishna Mokashi (Expert)
Follow

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".

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CCI Pro

Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

CCI Pro

Meet our CAclubindia PRO Members

Pro Member Selvaraj K

Selvaraj K

Pro Member Sasidhar B

Sasidhar B

Pro Member Credible HRM

Credible HRM

Pro Member vinay

vinay

Pro Member Leena Rachh

Leena Rachh

Follow us

add to google news

Answer Query

Quick Links

Browse by Category

Latest Job Openings

View all

16 May 2026

Account & Audit Asst

RAHUL KHANDEBHARAD & ASSOCIATES

Nashik

B.Com

View Details

07 May 2026

CA Assistant

amit desai and co

Mumbai

CA Final

View Details

09 May 2026

Audit Manager

Kanna and Associates

Coimbatore

CA Inter

View Details

26 May 2026

CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details

11 May 2026

Post office

Post office

Anakapalle

Others

View Details

18 May 2026

MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details

08 May 2026

CHARTERED ACCOUNTANT

SHAH LADHA AND ASSOCIATE

Ahmedabad

CA

View Details

11 May 2026

CA Dropout

Patron Accounting LLP

Pune

CA Inter

View Details