+ Reply to Thread
Results 1 to 4 of 4

How to find differences in header row between 2 sheets

  1. #1
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    896

    How to find differences in header row between 2 sheets

    So i have been asked to consolidate 3 sheets into 1, the file was setup with a sheet for each status, but that is becoming unmanageable. So it was discussed to make one of the sheets the master and just have a "status" column where they can flag each row appropriately.

    Because each tab has between 15 and 31 or so columns in each tab, is there a way to do some form of conditional formatting or some formula to identify which columns are not in the next..

    Sheet1 = 16 columns
    Sheet2 = 15 columns
    Sheet3 = 31 columns

    The master needs to contain ALL columns found within each of the 3 sheets. So based on the numbers above, the master should NOT have less than 31.

    I dont have a sheet right now to upload, but just need guidance / push in the right direction on how i can compare JUST the headers on each sheet to find what is missing from each sheet.

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: How to find differences in header row between 2 sheets

    Highlight sheet 1 columns
    Go to Conditional Formatting - click on New Rule
    Use a Formula to determine which cells to format

    =Sheet1!A1 <> Sheet2!A1
    Format then go to Fill and select a color to highlight
    Click on OK

    Repeat and select another color to compare Sheet 1 and 3
    Then Sheets 2 and 3

  3. #3
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    896

    Re: How to find differences in header row between 2 sheets

    that kinda works, but seems to be a literal compare. meaning that if column D on Sheet 1 is "Date" and Column D on Sheet 2 is "Status" it would mark it as different, but on sheet 2 Column E is "Date"
    I thought about it overnight and was thinking that maybe i can transpose the list of headers into a column for both then do a find duplicates to highlight the ones that are the same? MAYBE?? going to try that next..

  4. #4
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    896

    Re: How to find differences in header row between 2 sheets

    I just tried and that seems to give me what i need..
    I transposed the list of headers from each sheet into 1 sheet, did conditional formatting to identify duplicates and it did just that..

    Thanks for the initial suggestion..

+ 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. Find differences between sheets in two different workbooks
    By sumit dey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2019, 03:07 AM
  2. Find differences between sheets in different workbooks
    By sumit dey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2019, 04:35 PM
  3. How to find differences between two sheets?
    By maknu in forum Excel General
    Replies: 4
    Last Post: 05-13-2019, 08:52 AM
  4. Find differences between 2 excel sheets or tables
    By FBG098 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2015, 11:16 AM
  5. Find Differences between columns sheets
    By dalerdd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2013, 02:44 PM
  6. how to find differences between 2 excel sheets
    By remdog in forum Excel General
    Replies: 7
    Last Post: 09-11-2012, 07:16 AM
  7. Replies: 1
    Last Post: 07-12-2012, 05:43 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