# How to find differences in header row between 2 sheets

1. ## 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. ## 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. ## 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. ## 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..

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

#### 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