Affiliate Marketing
Forum Search

Go Back    Affiliate Marketing > Techies Corner > Widgets, Coding, AJAX, PHP - Technology & Affiliate Marketing
Comparing 2 columns for same/different data in excel Comparing 2 columns for same/different data in excel

Reply
 
LinkBack Thread Tools Display Modes

  #1 (permalink)  
Old 17-11-06
Registered User
  
Join Date: Apr 2004
Location: UK
Posts: 416
Thanks: 5
Thanked 1 Time in 1 Post
Matt Seigneur is an unknown quantity at this point
  Comparing 2 columns for same/different data in excel
hello my pedigree chums,

working on a huge excel sheet where there are 2 columns and i need to see if there are any that have different information, is there a formula i can use to find this out?

cheers
Matt
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 17-11-06
Super Moderator
  
Join Date: Aug 2003
Posts: 1,984
Thanks: 1
Thanked 1 Time in 1 Post
Fraser seems to know their stuff
  Re: Comparing 2 columns for same/different data in excel
You can use

=EXACT(A1,B1)

Where A1 and B1 contain the data you want to compare. This will return TRUE or FALSE
__________________
Fraser

Affiliate Blog & Podcast
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 17-11-06
Registered User
  
Join Date: Apr 2004
Location: UK
Posts: 416
Thanks: 5
Thanked 1 Time in 1 Post
Matt Seigneur is an unknown quantity at this point
  Re: Comparing 2 columns for same/different data in excel
cool, and so simple
cheers
matt
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
The Good Feed Guide (For Merchants) clint45 Widgets, Coding, AJAX, PHP - Technology & Affiliate Marketing 18 19 Hours Ago 11:54 PM
Excel Question: Merging data from 2 cells into 1 (now fixed) Matt Seigneur Widgets, Coding, AJAX, PHP - Technology & Affiliate Marketing 2 16-04-05 02:08 PM
Data Cleaner Software - Beta version Chris The Affiliate Marketing Lounge 2 07-01-05 08:44 AM
saving excel data into "|" delimited txt files? Matt Seigneur Widgets, Coding, AJAX, PHP - Technology & Affiliate Marketing 7 25-08-04 10:00 PM
Prezzybox Data Feeds... ben Affiliate Window 0 01-04-04 02:43 PM


Affiliate Marketing RSS Feeds - Contact Us - Affiliate Marketing - Archive - Privacy Statement - Top

Content Relevant URLs by vBSEO 3.2.0 RC7