Solved

Excel Question

Posted on 2014-10-16
3
88 Views
Last Modified: 2014-10-16
Hello

I am looking to do in Excel the following thing

1) I have in Sheet1 about 2000 rows with clients like:
002345 CLIENT1...
003323 CLIENT2
004432 CLIENT3
004433 CLIENT4
004434 CLIENT5
...
005601 CLIENT1999
005645 CLIENT2000

2) I have in sheet2 a SUBSET of  1000 clients of Sheet1. Example
004432 CLIENT3
004433 CLIENT4
...
005601 CLIENT1999

My purpose is to find all rows that DO belong to Sheet1 BUT NOT belong to sheet2
For Example it will return
002345 CLIENT1
003323 CLIENT2
...
005645 CLIENT2000

Is ther an easy way to do that ?
THank you
0
Comment
Question by:gadsad
3 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,

You could use

=IF(COUNTIF(Sheet2!A:A,Sheet1!A1)=0,"Yes","No")

See example

EDIT You can then filter them and copy the result elsewhere
EE20141016.xlsx
0
 
LVL 8

Expert Comment

by:Wilder_Admin
Comment Utility
Using Vlookup

This function is commonly used to search and compare data in an Excel worksheet quickly. “V” in Vlookup stands for “Vertical.” This function has four parts – the lookup value, table range containing the value, the column to display once the match is found and the type of match. You can play around with this in various ways to compare or find differences in your data.

https://www.udemy.com/blog/excel-diff/
0
 

Author Closing Comment

by:gadsad
Comment Utility
thank you very much,
it works fine
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now