+ Reply to Thread
Results 1 to 8 of 8

Cells in 2 different columns but the same content

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010 - 365
    Posts
    9

    Cells in 2 different columns but the same content

    I know the title sounds confusing but my explanation will clear it up - I hope.
    Column A Contains Text Data
    Column B Contains Text Data
    Both columns contain the exact same data but the data is "jumbled" so to speak...
    Cell B30 Contains "Amok Time" and Cell C34 Contains "Amok Time"
    Cell B31 Contains "Who Mourns For Adonas?" and Cell C33 Contains "Who Mourns for Adonas?"
    All Rows and Cells are Jumbled between Column B and Column C but the do contain the same data just the row numbers are jumbled.

    Is there a way to set up a "link" or line link between the two Cells that contain the same data?
    Is there a formula, or a method in Excel to join the cells by a line or similar like a line between B30 and C34, and then B31 and C33 and so on?
    Last edited by Keith008; 03-26-2019 at 09:53 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: Cells in 2 different columns but the same content

    In column C, for example, you could use MATCH to determine the row in column B which matches the entry in column A. For example,
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: Cells in 2 different columns but the same content

    Please review your post as your column references are confusing.

  4. #4
    Registered User
    Join Date
    02-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010 - 365
    Posts
    9

    Re: Cells in 2 different columns but the same content

    I am not sure what you mean by confusing. The spreadsheet contains, 89 rows of data, the specific cell range that I want to match is B2 to C89 (Columns B and C rows 2 to 89). The examples I gave were B30 and C34 - they have the same data in both cells But are mismatched by rows, another pair of cells is B31 and C33, they have the same data, again the row is mismatched. Throughout the entire cell range I am sure column B has the same data as Column C BUT the rows are all jumbled I wanted to find a way to cross match the two columns Row by Row to see if there were any "odd" cells (cells with non matching data) The cell references I gave were as per my spreadsheet... Again, I do not see what is confusing about the references I gave.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: Cells in 2 different columns but the same content

    Your post started with ...
    Column A Contains Text Data
    Column B Contains Text Data
    Both columns contain the exact same data but the data is "jumbled" so to speak...
    You then continue with
    Cell B30 Contains "Amok Time" and Cell C34 Contains "Amok Time"
    Cell B31 Contains "Who Mourns For Adonas?" and Cell C33 Contains "Who Mourns for Adonas?"
    Whatever, it shouldn’t be that difficult to adjust the formula provided in post #2

  6. #6
    Registered User
    Join Date
    02-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010 - 365
    Posts
    9

    Re: Cells in 2 different columns but the same content

    Thank-you for the reply, it kind of gave me what I needed... I can see what data matches and where it is.

  7. #7
    Registered User
    Join Date
    02-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010 - 365
    Posts
    9

    Re: Cells in 2 different columns but the same content

    Ahh yes, my apologies it was about 2AM my time when I posted... a slight brain melt down at that time of day...

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: Cells in 2 different columns but the same content

    You're welcome.


    Formula: copy to clipboard
    Please Login or Register  to view this content.
    is more complete and reflects the columns you referred to.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Replies: 4
    Last Post: 05-29-2015, 07:47 PM
  2. Automatically copy cells content based on the content of another cell.
    By chrisbarlow1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 11:13 AM
  3. Replies: 0
    Last Post: 01-15-2014, 05:17 PM
  4. does columns cells content match that in other ws
    By TheUnit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2012, 04:56 PM
  5. [SOLVED] Highlight a cell if its content doesn't match another cells content
    By noxygen in forum Excel General
    Replies: 4
    Last Post: 04-12-2012, 04:36 AM
  6. Replies: 3
    Last Post: 04-05-2012, 04:58 PM
  7. Replies: 2
    Last Post: 01-29-2007, 12:14 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