All,
First off, thank you for reading this post. I hope that you would be able to help me out.
I have a file that has one header and anywhere from 0 to 999 subheaders. Both the header and the subheader have a value that I want to compare, and there is a value in the header that will tell me how many subheaders are in the file.
I have situations where I come across thousands of files where I have to compare the value within the header and the associated subheaders and I want to have Excel automate most (if not all) of the process for me.
My thought was to compare the file name and use that to determine if the values are the same; I have attached the spreadsheet to illustrate my issue. By using an If statement, I have attempted to have a visual comparison of the header and subheader name [=IF(A2=D2,"TRUE",IF(A1=D2,"MULTI","FALSE"))]. However, I do not think that Excel would be able to have a logic function for 999 different cells and there is an issue when it comes to file C.
I'm not sure how to anticipate the variable number of subheaders within each file in terms of an automatic check. If I knew the number of subheaders, is there a way to use that number and multiply the statement for the value verification?
Again, thank you for reading and I appreciate any help you could offer!
Respectfully,
Talamon
File Comparison.xlsx
Bookmarks