I am tasked to find a way to compare several sheets with similar datatypes. They all have the same number of rows in total (payslips), but here and there, there are new payment types each month, …
I figured an effective way of comparing these sheets, but I need one feature: Is it possible to write an if statment in the form of:
=IF(A1=A37; …)
be written as:
=IF(A1=A(1+36X); …)
where X is natural instead? More like an arithmetic sequence rather than comparing every row in column A. Thanks!
I tried what I described above.
New contributor
Oblivion is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.