Arrange two sheets of headings in the same way.

[srizki]

I need to compare the data on two sheets in the same workbook, so the third sheet will have the variances, and the third sheet will have the formula like sheet1!QA32-sheet2!QA32, therefore I need to arrange the two sheets in the same way. How do I align the headings to get the correct data on the two sheets?
A formula will work, I am using =INDEX(MATCH formula,
Any suggestions, please?

 

[SanjayGMusafir]

Is this what you are looking for - Check Cell E1

Book1
	A	B	C	D	E	F	G
1	Heading1	Heading2	Heading3		Heading1	Heading2	Heading3
2	Data	Data	Data		Data	Data	Data
3	Data	Data	Data		Data	Data	Data
4	Data	Data	Data		Data	Data	Data
5	Data	Data	Data		Data	Data	Data
Sheet1

Cell Formulas
Range	Formula
E1:G1	E1	=A1:C1
Dynamic array formulas.

 

[srizki]

Is this what you are looking for - Check Cell E1

Book1
	A	B	C	D	E	F	G
1	Heading1	Heading2	Heading3		Heading1	Heading2	Heading3
2	Data	Data	Data		Data	Data	Data
3	Data	Data	Data		Data	Data	Data
4	Data	Data	Data		Data	Data	Data
5	Data	Data	Data		Data	Data	Data
Sheet1

Cell Formulas
Range	Formula
E1:G1	E1	=A1:C1
Dynamic array formulas.

No, this will only tell me if the data in this cell is the same as on the other cell. true or false. I wanted to arrange one column headings the same as the other so I can use the formula to check if the value is the same as in another sheet.
I used =INDEX(MATCH formula, and sort the heading same as the other sheet.

 

[SanjayGMusafir]

That is what I'm telling - See Formula in cell E1, it has copied headings from previous range and shall keep them synced at all times

This way you can use INDEX-MATCH efficiently.

 

[srizki]

Thank you, Sanjay,
I should have explained it. I have two lists of almost the same headings, one list has 450 columns headings, and another has 435 columns headings, I need to compare the two headings, some of the headings are not the same, for example, one heading may have OIJ IT 2767, and the other heading may be
OIJ 2767, So I need to compare the two headings and move the unmatched to the right of the headings.

 

[SanjayGMusafir]

Now I understand what you actually want. Check this. It might give you some starting point to work with.

First finding the odd ones, the second challenge shall be to bring them in same sequential order.

All Records.xlsb
	A	B	C	D	E	F	G	H	I	J	K
1	Heading1	Heading2	Heading3	Heading4	Heading33	Heading5	Heading6	Heading7	Heading8	Heading9
2
3	Heading1	Heading22	Heading2	Heading3	Heading44	Heading4	Heading5	Heading6	Heading7	Heading8	Heading9
4
5
6
7	Check Headings
8	Heading1	Heading2	Heading3	Heading4	Heading33	Heading5	Heading6	Heading7	Heading8	Heading9
9	1	1	1	1	0	1	1	1	1	1
10
11
12	Heading1	Heading22	Heading2	Heading3	Heading44	Heading4	Heading5	Heading6	Heading7	Heading8	Heading9
13	1	0	1	1	0	1	1	1	1	1	1
Sheet1

Cell Formulas
Range	Formula
A8:J8	A8	=A1:J1
A9:J9	A9	=COUNTIFS($A$12#,A8)
A12:K12	A12	=A3:K3
A13:K13	A13	=COUNTIFS($A$8#,A12)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A12:K12	Expression	=A13=0	text	NO
A8:J8	Expression	=A9=0	text	NO

 

[srizki]

Sorry for the late reply. Yes, this worked, but I no longer working on the project, but I learned something new.