AntonioCrz
New Member
- Joined
- Mar 14, 2019
- Messages
- 5
Good afternoon All
In excel I used the following formula to compare to sets of numbers and count how many were common. How can I do this in Access?
FORMULA (CTRL+SHIFT+ENTER):
<tbody>
</tbody>
There are two sets (each set can have between 0 to 80 000 entries), one in each table. The result should be in a third table.
Rgds
António
In excel I used the following formula to compare to sets of numbers and count how many were common. How can I do this in Access?
FORMULA (CTRL+SHIFT+ENTER):
=SUM(IF(COUNTIF($J$2:$N$2;J6:N6);1)) |
<tbody>
</tbody>
There are two sets (each set can have between 0 to 80 000 entries), one in each table. The result should be in a third table.
Rgds
António