Comparing columns with different text values in Excel 2007

Hello!

I'm struggling with a bit of a problem as to how to compare some columns in excel 2007.
I have 3 columns of data, column A contains first names, column B contains last names and column C contains full names.
Not every name and last name in columns A and B is contained in column C, but column C contains all of A and B and about 1000 extra names that are not in the first to columns.

i.e.


A
B
C

Angelina

Jolie
Pitt, Brad

Brad
Pitt
Lawrence, Jennifer

Emma
Watson
Jolie, Angelina

Ellen
Page
Smith, John


Watson, Emma


Page, Ellen


Watson, Doctor


Is there a way to compare or match the columns? Like getting rid of every name in column C that doesn't appears in columns A and B?

Thanks in advance!!

Keys to the Problem Comparing columns with different text values in Excel 2007

Download SmartPCFixer to Fix It (Free)

Hello Mike,
 I didn't mention that column C includes a lot of names containing first, middle, last name AND second last name.
Yet columns A and B contain only the First Name and the First Last Name...

So this will add I assume some complexity to the formula,

Hi,
Your assumption is correct, that fundamental change to the requirement makes things very difficult indeed, so much so I wouldn't even begin to attempt it with a formula.

Even with VB code I think the challenges here are very formidable.
For example say we have only 2 rows as below, which one of the 2 exists in column B?
To proceed with this you will need to provide very clear rules regarding which names from column C we use when there are 2,3 4 names in a cell (could there be more?) and also whether a VBA code solution is acceptable.


Mike
Rogers
Watson, Doctor

Anthony
Harris
Rogers Harris, Mike Anthony

Manually editing the Windows registry

Caution: Unless you an advanced PC user, please do not edit the Windows registry manually.

Because of this risk, we highly recommend using a trusted registry cleaner such as SmartPCFixer Using a registry cleaner automates the process of finding invalid registry entries, missing file references (like the one causing your MACHINE_CHECK_EXCEPTION error), and broken links within the registry. A backup is automatically created before each scan, with the ability to undo any changes in a single click, protecting you against the possibility of PC damage. The best part is that repairing registry errors can also dramatically improve system speed and performance.

  • Click the Start button.
  • Type "command" in the search box... DO NOT hit ENTER yet!
  • While holding CTRL-Shift on your keyboard, hit ENTER.
  • You will be prompted with a permission dialog box.
  • Click Yes.
  • A black box will open with a blinking cursor.
  • Type "regedit" and hit ENTER.
  • In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
  • From the File menu, choose Export.
  • In the Save In list, select the folder where you want to save the Windows Operating System backup key.
  • In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
  • In the Export Range box, be sure that "Selected branch" is selected.
  • Click Save.
  • The file is then saved with a .reg file extension.
  • You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

The next steps in manually editing your registry will not be discussed in this article due to the high risk of damaging your system. If you would like to learn more about manual registry editing, please see the links below.

Another Safe way to Repair the Problem: Comparing columns with different text values in Excel 2007:

How to Fix Comparing columns with different text values in Excel 2007 with SmartPCFixer?

1. Download Error Fixer. Install it on your system.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Cannot Connect To Network Automatically Upon Reboot,Cannot Find And/or Connect To Some Game Servers Such As PurePlay Poker, And Several, But Not All, Facebook Games.,Cannot Connect To SQL Database From Homegroup Machine,Cannot Attach File To An Outlook Email - IE Bombs,Can't Update (or Uninstall) Itunes 10.2,Canon PowerShot SD880 IS 10MP Digital Camera,Cannot Zoom On Certain Webpages,Cannot Reply To E-mails Or Compose New Ones,Cannot Open Links On IE8,Cannot Print From Ie9 - Error Code 0, Url Res://ieframe.dll/preview.js,Charting Multiple Sheets, Multiple Columns,Clean UP Tool OneCare,Chat History,Cant Sign Up ESO In Age Of Mythology Gold Edition,Charting Over 32 000 Points Macro
Read More: cant log into accounts - right after you see the blue screen it says logging of and it logs off,Troubleshoot:Centering Images by Default Error,Fast Solution to Error: CD-ROM & DVD-ROM Recognition,Fast Solution to Problem: change the email address associated with the user account,How to Resolve - cold start of task scheduler?,Can't connect to wireless network after reinstalling Vista!,Can I use Vlookup?,Cannot connect to secure websites,Cannot Change language on microsoft office,excel, etc on windows vista,Card reader only recognised if boot with card in it?
[PR]
# by firefox403error | 2016-09-19 17:27

Cannot run exe files or install programs

Whenever I tried to run an exe file, the following message appears:
Windows cannot find 'C:\Windows\regedit.exe'.
Make sure you typed the name correctly, and then try again.
Even though I have checked that regedit.exe exists and is in the folder C:\Windows\
Such message appears when I double-click a exe file or run the program through the search box at the bottom of the start menu.
 
Note:
When I enter the safe mode, I can run some exe files such as  the regedit.exe or msconfig.exe, but not so in normal modeSome programs that I have previous installed can be executed normally, such as Word, Powerpoint, Skype, etc.
Any suggestions of how I could fix this problem?

Keys to the Problem Cannot run exe files or install programs

Download SmartPCFixer for Free Now

Hello Howard Fu,
It sounds as if you may have a Virus or malware infection.
Have your run a Antivirus? If not, you can download Microsoft Security Essentials.
Clickhere for a link.

Once you have checked for virus, if you are still having a problem, click on the following article number. 
KB Article ID: 950505 - When you run an .exe file on a Windows Vista-based or Windows 7-based computer, the file may start a different program
I would also suggest you run SFC /scannow to see if you have any corrupt system files.
Click Start
Type: CMD, from the results, right click CMD
Click 'Run as Administrator'
At the Command Prompt, type: sfc /scannow

This will check for any integrity violations and fix any corrupted operating system files.

Restart your system.
See: KB Article ID: 929833 -How to use the System File Checker tool to troubleshoot missing or corrupted system files on Windows Vista or on Windows 7
http://support.microsoft.com/kb/929833
Hope this helps.
 
Sincerely,

Marilyn
Microsoft Answers Support Engineer
Visit our
Microsoft Answers Feedback Forum and let us know what you think

  • Download the Microsoft Windows ISO (installation device) from the following website:
  • http://www.microsoft.com/en-us/software-download/windows10
  • Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.
  • Extract the ISO file to a separate USB device or burn the program to a compact disc.
  • Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.

Recommended Method to Repair the Problem: Cannot run exe files or install programs:

How to Fix Cannot run exe files or install programs with SmartPCFixer?

1. Download Error Fixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed


Related: Basing One Combo Box On Another,Batch File Execution Time Calculation,BitLocker: The System Could Not Find The File Specified,Best Way To Create Letterhead Electronically From Mailmerge,Battery Plugged In But Not Charging,Break Spreadsheet Into Weeks And Months,C:\Program Files X86 Browser Updater\TBUdater.dll.,Built New Computer With Windows 7 - Experiencing Same Data Transfer Issues,BSOD After Hibernation.,Built New Computer In Dec 2012 And Did Windows 8 Update, Restarted And Result Was Corrupted OS 'insert Proper Boot Device'?? Twice! Which Update Is Corrupting My Computer???,Can I Use The Same Recovery Discs To Restore Windows On Multiple Same Model Laptops?,Can You Use Spell Check On A Protected Sheet Using All Capitals?,Can Someone Download Apps Without A Microsoft Account?,Can Not Load Excel File By Clicking Workbook Icon,Can't Access Control Panel,Can't Save Hyperlinked Files, It's Forcing A Save As Instead,Can't Save Files On Desktop/,Can't Select Multiple Text Boxes,Can't See Other Computers On Network,Can't Open Certain E-mails Error Message C00d1199
Read More: cannot sign into widows messenger__,How to Fix - Canon S300 printer drivers for Windows 7?,How Can You Fix - Cannot Use the "Send Link by Email" Feature?,Troubleshoot:Canon PIXMA MX860 All-In-One Printer Error,Troubleshooting:Cannot Sign Out of Windows Live - please help__ Error,can't get an hp color laserjet cp1515 to print on windows 8,Can I reset my laptop to factory setting if I have had my hard disc drive replaced?,Cannot backup Windows 7 64bit - error code 0x80070020,Can't uninstall IE8,Cannot access Vista Print website - Error message "Website could not be found"
[PR]
# by firefox403error | 2016-09-14 11:42

can't install windows 8 updates on my hp

I just bough an HP g7 but I can't get it to load my windows 8 updates.  It downloads fine, but gets stuck installing at 12%.  After all the help desks failed, I I exchanged the computer.
And yes, the same problem.  So it must be the software.  I couldn't
install Microsoft Office either.  Similar problems?  Any help would be appreciated!

Anwsers to the Problem can't install windows 8 updates on my hp

Download Error Fixer (Free)

Manually editing the Windows registry to fix Error can't install windows 8 updates on my hp

Caution: Unless you an advanced computer user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

  • Click the Start button.
  • Type "command" in the search box... DO NOT hit ENTER yet!
  • While holding CTRL-Shift on your keyboard, hit ENTER.
  • You will be prompted with a permission dialog box.
  • Click Yes.
  • A black box will open with a blinking cursor.
  • Type "regedit" and hit ENTER.
  • In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
  • From the File menu, choose Export.
  • In the Save In list, select the folder where you want to save the Windows Operating System backup key.
  • In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
  • In the Export Range box, be sure that "Selected branch" is selected.
  • Click Save.
  • The file is then saved with a .reg file extension.
  • You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

Another Safe way to Repair the Problem: can't install windows 8 updates on my hp:

How to Fix can't install windows 8 updates on my hp with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Run it, and it will scan your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.


Related: Bar Chart Primary Axis Position,Bcdedit Cannot Import File, Element Cannot Be Found,,Between Two Date Selections,Black Screen Only Explorer Loads Showing The Disk Drives,Batch Transpose Macro,Can I Set Up Windows Backup So That It Simply Updates The "changes" Since My Last Backup?,Can Not Print From Computer,Can You Split A Cell In Excel 2010 The Way A Cell Is Split In Word 2010,Can't Fix BSoD Problem Because Windows Won't Let Me Install The Solution.,Can You Remove Default Buttons From IE9?
Read More: How to Fix Problem - Can not access Control Panel or Sub Panels?,Solution to Error: Can you please tell me where 2 find the incoming mail and outgoing mail server names? (pop3 or IMAP) (SMTP)__I am trying to send a e-mail.,Troubleshooting:Can't get Movie Maker to install,Fast Solution to Error: Can't find Netflix app on Windows store,Troubleshoot:Can't create restore points or do backups.,Can't add STDEV error bars to pivot chart (or any excel chart) in PC Excel 2007,Can Word 2010 be retrofitted with Word 2013's collapsible paragraph styles?,can virtual server run on windows 7 professional,Can I restore windows with a system image stored in a folder?,Can I show stages of change with track changes?
[PR]
# by firefox403error | 2016-09-08 12:49

blue screen error appears with code 000000007f

I have A core i7 pc on which windows seven is installed,
on it the blue screen appears with the following code
bcc code 1000007e
bcp1 code c0000005
bcp2 code 9070cf5a
bcp3 code 8de2fb9c
bcp 4 code 8de2f780

Keys to the Problem blue screen error appears with code 000000007f

Download SmartPCFixer to Fix It (Free)

Note: It is recommended that you back up your files and folders before attempting this step:

  • Move the mouse cursor over to the upper right side of the screen.
  • A menu will pop up on the left. Click on the "Settings" feature on the menu.
  • On the Settings window, click on the "Change PC settings."
  • Now, left click on the "Update and recovery" feature.
  • For the next step, left click on the "Recovery" feature.
  • There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
  • Now, follow the instructions on the screen to finish the Refresh process.
  • After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
  • Check again to see if the error blue screen error appears with code 000000007f has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Another Safe way to Repair the Problem: blue screen error appears with code 000000007f:

How to Fix blue screen error appears with code 000000007f with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: Backup Values On Single Sheet File,Bank Reconciliations On Excel 2007,Black Screen Unresponsive Windows 7 At Startup,Basic-Keeping One Cell Current With Each New Save?,Belkin N52te 15 Button USB Gaming Controller
Read More: Fast Solution to Error: belkin router keeps blinking green and the icon on the computer is amber,[Anwsered] Batch file execution time calculation,Troubleshoot:Bad_Pool_Caller Blue Screen on Windows 7 with SSD,How Can I Fix - Batch transpose macro?,Fast Solution to Error: Blue Icicle error code 10 on windows 8.1,batch Find and Replace for docx files,Black screen of death with cursor - unable to load in any mode,BeGraphic Add-In for Excel - UI Error,base score improvement,Best Way to set up a Spreadsheet for multiple lists
[PR]
# by firefox403error | 2016-08-10 17:39

"Find" function does NOT find things...

(wLM &IE8)  Yes, the "Find" button isn't working!  I had to read words one by one and found them, but not this button.

Solutions to the Problem "Find" function does NOT find things...


"Find Btn?" where are you seeing this?


Click here to download the registry repair application


Another Safe way to Fix the problem: "Find" function does NOT find things...:

Click here to download the registry repair application .

How to Fix "Find" function does NOT find things... with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will scan your system. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.


Related: Countifs drag down/across help needed [Solved],How to change or delete the search engine homepage [Anwsered],I can not get my comcast toolbar to work with Internet Explorer 8. [Anwsered],Scanner Compatability with Window 7 [Anwsered],How to Resolve - System Image to 1 disk, Multiple computers, Same Computer Names?,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22),Troubleshooting:pfstudiox Error,[Solved] Svchost Helper,[Solution] Sm1bg exe,How to Fix Problem - Io Device?,Fast Solution to Problem: I Can Error Code 0x6d9
Read More: Troubleshoot:"No print data" Error when copying and pasting,"Failed Redundancy" RAID mirror in Windows 7 32 bit [Solved],How to Fix - "Runtime Error 429/ActiveX Component" PROBLEM on opening MS Word?,How to Resolve not a valid win32 application with non corrupt xls doc xlsx and docx files,"Links" function no longer works for IE7 [Solved],Number format will not convert to Date,"$1450" rounding down to 1400 b/c it's actually $1449.999250 (but doesn't show the whole number),"Control + right arrow" inserts a tab in Word 2010,"'oldIframe' is null or not an object" when playing internet games,Notification Icons & Clock - both monitors?
[PR]
# by firefox403error | 2016-07-13 12:35