catalincirjan
New Member
- Joined
- Aug 28, 2020
- Messages
- 18
- Office Version
- 2016
- Platform
- Windows
Hello,
I have the task of counting the number of changes/updated in a range K3:K500.
I do a snapshot (aka Copy Paste) at the beging of the the week and create a new sheet "Reference"
The solution I thought about was
=SUM(IF(Tracks!K3:K500<>Reference!K3:K500,1,0)
The logic was that it would go and compare Tracks!K3 with Reference!K3 and if they were different it would return 1. And so on until K500 and do a SUM at the end.
This function always is showing me 0 as a result.
Note: cells contain information in text (Ex: Completed, pending approval, schedueled for the 29th etc -> nothing standardized)
Note2: I did manage to make a more rustic version of this in a seperate sheet: "Calculus" where in cell A3 i put =IF(Tracks!K3<>Reference!K3,1,0) -> then I pun the formula in all 500 rows. At the end I do a sum. But there MUST be a simpler solution.
Hope I explained the issue well enough
I have the task of counting the number of changes/updated in a range K3:K500.
I do a snapshot (aka Copy Paste) at the beging of the the week and create a new sheet "Reference"
The solution I thought about was
=SUM(IF(Tracks!K3:K500<>Reference!K3:K500,1,0)
The logic was that it would go and compare Tracks!K3 with Reference!K3 and if they were different it would return 1. And so on until K500 and do a SUM at the end.
This function always is showing me 0 as a result.
Note: cells contain information in text (Ex: Completed, pending approval, schedueled for the 29th etc -> nothing standardized)
Note2: I did manage to make a more rustic version of this in a seperate sheet: "Calculus" where in cell A3 i put =IF(Tracks!K3<>Reference!K3,1,0) -> then I pun the formula in all 500 rows. At the end I do a sum. But there MUST be a simpler solution.
Hope I explained the issue well enough