Insights Blog
-- Browse All Articles --
Physics Articles
Physics Tutorials
Physics Guides
Physics FAQ
Math Articles
Math Tutorials
Math Guides
Math FAQ
Education Articles
Education Guides
Bio/Chem Articles
Technology Guides
Computer Science Tutorials
Forums
Chemistry
Biology and Medical
Earth Sciences
Computer Science
Computing and Technology
DIY Projects
Trending
Featured Threads
Log in
Register
What's new
Search
Search
Search titles only
By:
Chemistry
Biology and Medical
Earth Sciences
Computer Science
Computing and Technology
DIY Projects
Menu
Log in
Register
Navigation
More options
Contact us
Close Menu
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Forums
Other Sciences
Computing and Technology
Spreadsheet help: compare two lists to find exceptions
Reply to thread
Message
[QUOTE="DaveC426913, post: 6850165, member: 15808"] [B]TL;DR Summary:[/B] Compare a column of each of two spreadsheets to pull out exceptions (I am using OpenOffice Calc, though I have access to Excel). I have coerced two lists of patients into two sheets on a spreadsheet. [B]I need to determine who is missing from [I]each [/I]list.[/B] So, schematically, something like this output: [B]List 1:[/B] Alice Bob [COLOR=rgb(184, 49, 47)]Carol[/COLOR] Dave [B]List 2:[/B] Alice [COLOR=rgb(184, 49, 47)]Bill[/COLOR] Bob Dave or something like this is fine too: [B]List 1:[/B] Carol [B]List 2:[/B] Bill I'm not really picky. I am compiling my report manually, so "cheap and cheerful" is the word-of-the-day. The only reason I need to automate parts of it is because of the sheer volume: 70 doctors, totaling 16,000 patients.I'm not sure how to Google search for such operations - whether it's "conditional formatting" or "compare sheets", etc. Which is why I'm asking for direction/inspiration.As for comparing sheets, [B][COLOR=rgb(184, 49, 47)]note that the two lists are not currently normalized:[/COLOR][/B] One list might be: [B]Last Name, First name, Address, Gender, etc.[/B] The other list list might be: [B]Doctor, Phone#, Full name, Gender, etc.[/B] (The point I'm making is that a straight up "compare two sheets" is not really what this is. A "compare two sheets" operation is likely expecting a majority of overlap with only data/content differences.) Normalizing them [I]could[/I] be done, but that's even more work. I'm sure I will have to at least normalize the name field(s).Also: No hurry. Anytime in the next half hour will be fine. :smile: [/QUOTE]
Insert quotes…
Post reply
Forums
Other Sciences
Computing and Technology
Spreadsheet help: compare two lists to find exceptions
Back
Top