LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 06-26-2017, 10:17 AM   #1
secondchanti
LQ Newbie
 
Registered: Jul 2010
Posts: 24

Rep: Reputation: 15
finding differences between two sheets


Friends,
I am having the follwing data in two sheets:

sheet 1:

BO SR POL
A 11 111
A 11 112
B 12 121
C 13 131
C 13 132
D 14 141
E 15 151


sheet 2 :

BO SR POL
A 11 111
A 11 113
B 12 121
C 13 131
G 17 171
K 19 199

differences manually i have arrived are :

in sheet 1 but not in sheet 2
A 11 112
C 13 132
D 14 141
E 15 151


in sheet 2 but not in sheet 1
A 11 113
G 17 171
K 19 199

how i have to write formula to get these differences in sheet 3.

pl guide me.

Thanks
 
Old 06-26-2017, 10:26 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,520

Rep: Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944Reputation: 7944
Quote:
Originally Posted by secondchanti View Post
Friends,
I am having the follwing data in two sheets:

sheet 1:
Code:
BO	SR 	POL
A	11	111
A	11	112
B 	12	121
C	13	131
C	13	132
D	14	141
E	15	151
sheet 2 :
Code:
BO	SR 	POL
A	11	111
A	11	113
B 	12	121
C	13	131
G	17	171
K	19	199
differences manually i have arrived are : in sheet 1 but not in sheet 2
Code:
A	11	112
C	13	132
D	14	141
E	15	151
in sheet 2 but not in sheet 1
Code:
A	11	113
G	17	171
K	19	199
how i have to write formula to get these differences in sheet 3. pl guide me.
Since you've been a member here for seven years now, you should be familiar with the LQ Rules about text-speak and not using it. And read the "Question Guidelines" link in my posting signature. We are happy to help you with things, but we are not going to write your scripts for you. So post what you have written/done/tried so far, tell us where you're stuck, and provide details. We don't even know what language you're doing this in.
 
Old 06-26-2017, 12:10 PM   #3
Demosa
Member
 
Registered: Feb 2013
Distribution: Fedora 25, RHEL7, RHCI stack
Posts: 38

Rep: Reputation: Disabled
Check out the "diff" command.

Beyond that, this sounds like homework.
 
Old 06-27-2017, 12:08 AM   #4
dugan
LQ Guru
 
Registered: Nov 2003
Location: Canada
Distribution: distro hopper
Posts: 11,193

Rep: Reputation: 5307Reputation: 5307Reputation: 5307Reputation: 5307Reputation: 5307Reputation: 5307Reputation: 5307Reputation: 5307Reputation: 5307Reputation: 5307Reputation: 5307
Is this in Excel, in Windows? Are you looking for VBA help?

Last edited by dugan; 06-27-2017 at 12:10 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing A3 size using A4 sheets hcgrant Linux - Software 6 09-30-2016 10:55 AM
Can we compare two excel sheets? prakash.akumalla Linux - Newbie 7 10-29-2008 01:48 AM
amarok and cue sheets cmj_21 Linux - Software 2 12-31-2006 03:54 AM
style sheets... in konqueror? patolfo Debian 1 09-23-2006 01:58 PM
Amarok 1.4 and cue sheets wetnose23 Slackware 1 05-24-2006 03:08 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 11:06 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration