+ Reply to Thread
Results 1 to 4 of 4

Compare cells in adjacent columns

  1. #1
    Registered User
    Join Date
    07-03-2012
    Location
    md
    MS-Off Ver
    Excel 2010
    Posts
    37

    Compare cells in adjacent columns

    Hello,
    I have a spreasheet whi 26 columns and 100s of row of data. I want to compare data from cell B2 to C2, D2 to E2, F2 to G2, etc.
    I can Write a formula like C2-B2, E2-D2, G2-F2 and so forth (12 times to compare 24 sets of columns). Question that I have is there a way i can automate this instead of typing 12 times. I cannot drag the formula to the right as the column will compare b2-c2, then d2-c2 etc.
    Any help is highly appreciated.
    Thanks for looking.

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Compare cells in adjacent columns

    Sam can you post a sample book with expected results
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Registered User
    Join Date
    07-03-2012
    Location
    md
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Compare cells in adjacent columns

    Hemesh,
    Find the file attached as required. Desired result is shown in columns M to Q. Keep in mind that the actual spresheet has lots of columns thus typing a basic formula multiple times seems excessively time consuming task. I am pretty sure there should be a workaround.
    Thanks for the help.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Compare cells in adjacent columns

    Hello Sam, As per of your data your requirement is to take every second column(i.e.2,4,6,8,10) and deduct from every odd column i.e.1,3,5,7,9 etc. And you have forgotten to add field F1 and did the calculation of F1 into E1.

    find the attached. Copy and paste the formula, adjust the references i.e. $A$2:$L$5 then drag across and top to bottom.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Code - Compare Adjacent Cells In two columns and clear contents when a match is found
    By Langer101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-03-2013, 06:22 AM
  2. VBA Code - Compare Adjacent Cells In two columns...
    By mtt23 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2012, 05:47 AM
  3. compare contents of two adjacent columns
    By Adam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  4. compare contents of two adjacent columns
    By Adam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  5. [SOLVED] compare contents of two adjacent columns
    By Adam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM

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