checking the headings

[Christopher Naveen]

Hi,

I have a cols from A - FZ. I use to extract some report from the website and
daily i need to check the col headings whether it is matching or not. If the
extracted report does not matches my report heading then my formulas will not
work properly. I request you to help me on some function to check the col
headings

My report headings
A B C ---- FZ
Sl. No. Name Address Date

Extracted report headings
A B C ---- FZ
Sl. No. Name Address Date

If both the headings are not matching then it shud alert me. For exapmle in
the extracted report heading, Col C was changed to "XYZ" but my report
heading says "Address" so here the formual shud alert me saying that the cold
heading is not matching.

Can any one help me on this.

Thanks in advance!!

-Chris

 

[Teethless mama]

=SUMPRODUCT(COUNTIF('Extract Report'!A1:FZ1,'My Report'!A1:FZ1))=182

 

[AdamV]

laborious but it would work:
=if(A1&B1&c1&...FZ1<>[same thing for other worksheet],"Some error message","")

you could also use a macro to check each corresponding cell in turn