So, hey people. Thank you for reading this and for putting some thought into it.
I have a long line in an excel file, let's call it X, that I need to compare it with another line from another excel file, we'll call it Y.
The thing is that the Y line has the same first 6 cells as the X one followed by two unique ones, then the next 6 one are the same then the next 2 are are unique... and so on.
I need to compare the two lines in order to see if their cells are the same but the problem is that i need to somehow skip the the two extra cells Y has after each consecutive 6 cells.
Sorry if I'm not explaining that well. But maybe you get the idea and someone might help me.
Thank you and have a great day/night!
I have a long line in an excel file, let's call it X, that I need to compare it with another line from another excel file, we'll call it Y.
The thing is that the Y line has the same first 6 cells as the X one followed by two unique ones, then the next 6 one are the same then the next 2 are are unique... and so on.
I need to compare the two lines in order to see if their cells are the same but the problem is that i need to somehow skip the the two extra cells Y has after each consecutive 6 cells.
Sorry if I'm not explaining that well. But maybe you get the idea and someone might help me.
Thank you and have a great day/night!
