Hi, I receive a data set every month and want to verify if the rows in the new data (one row at a time, so by starting at the top say A2:X2), match with a row in the previous data. However, the tables wont be the same length each month, so I can't just select the respective row in the prior months data, I need to select the whole table (which would be on another tab, range: A:X).
This is easy to do with a basic: =COUNTIFS('old_data'!A:A,A2,'old_data'!B:B,B2,'old_data'!C:C,C2))
Or the several other options out there that involve naming each column and each individual cell.
However, my rows extend pretty far so I want to avoid this route. I'm not just lazy (I've already made this using the method explained above), but I don't like being stumped and not finding the answer to something that seems like it should be easy!
Does anyone have an answer to this? I figured maybe some sort of combination of an array lookup with the Exact formula or something like that...
Thanks in advance!
This is easy to do with a basic: =COUNTIFS('old_data'!A:A,A2,'old_data'!B:B,B2,'old_data'!C:C,C2))
Or the several other options out there that involve naming each column and each individual cell.
However, my rows extend pretty far so I want to avoid this route. I'm not just lazy (I've already made this using the method explained above), but I don't like being stumped and not finding the answer to something that seems like it should be easy!
Does anyone have an answer to this? I figured maybe some sort of combination of an array lookup with the Exact formula or something like that...
Thanks in advance!
