Results 1 to 5 of 5

if A2 = B2 then add 'Y' in C2 ... ?

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    LA
    MS-Off Ver
    Excel For Mac 2011
    Posts
    99

    Question if A2 = B2 then add 'Y' in C2 ... ?

    I'm trying to figure out a formula to rule-out errors/typos by comparing two columns that should have identical contents. This is my idea:
    if A2 = B2 then add 'Y' in C2 ... then I'll filter or sort on Column C. The rows without a 'Y' will be the ones with the typos.
    Any ideas on a formula would be very much appreciated.
    much thanks!
    Last edited by syncguy; 02-28-2012 at 04:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1