ISFIRSTOCCURENCE() issue in model when more users are added.


Hi Everyone, I added 1 user into my system and as soon as I run one process, it is failing to say that "Too many cells for ISFIRSTOCCURENCE calculation: actual =50000094 maximum=50000000".

But as I remove 1 user from the users tab the process starts running fine again.

I am a little bit confused about why this kind of failure is happening in my process.

Below is the screenshot of the issue

If someone knows the root cause of this problem then please let me know.

Best Answer