stijnb1234
New Member
- Joined
- Dec 16, 2021
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
I want to calculate how many times two values match.
For example, I have the values 1 and 2. I want to multiply both until the value of both is 10.
So, in this situation there are 5 matching numbers. I want a function that returns 5.
The usecase is to calculate matching sample frequencies.
I have a sample frequency of 1 Hz and a sample frequency of 50 Hz. So, the first one is 1000x/second and the second one is 20x/second. That means in 50 situations both numbers match.
For example, I have the values 1 and 2. I want to multiply both until the value of both is 10.
Map1 | ||||
---|---|---|---|---|
A | B | |||
1 | 1 | |||
2 | 2 | 2 | ||
3 | 3 | |||
4 | 4 | 4 | ||
5 | 5 | |||
6 | 6 | 6 | ||
7 | 7 | |||
8 | 8 | 8 | ||
9 | 9 | |||
10 | 10 | 10 | ||
Blad1 |
So, in this situation there are 5 matching numbers. I want a function that returns 5.
The usecase is to calculate matching sample frequencies.
I have a sample frequency of 1 Hz and a sample frequency of 50 Hz. So, the first one is 1000x/second and the second one is 20x/second. That means in 50 situations both numbers match.