Hello,
I am trying to compare 2 lists of data, column a (current data) and column b (new data), and find the address of the cells that are in column b and not column a. The data in column a is constant and the data in column b is updated regularly.
Example: What formula would I use to find the address? My data has over 500 rows of entries and I need to know if new entries are added.
<tbody>
</tbody>
I am currently using a count(b:b)-count(a:a) to tell me how many new entries are present but am unsure how to find the address of the new data.
I am trying to compare 2 lists of data, column a (current data) and column b (new data), and find the address of the cells that are in column b and not column a. The data in column a is constant and the data in column b is updated regularly.
Example: What formula would I use to find the address? My data has over 500 rows of entries and I need to know if new entries are added.
Current | New |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 |
<tbody>
</tbody>
I am currently using a count(b:b)-count(a:a) to tell me how many new entries are present but am unsure how to find the address of the new data.