Apr 14 2021 02:46 AM
Apr 14 2021 07:00 AM
Solution@Gianluca_mario On a Mac myself, but can't replicate your problem. The formula you mentioned in your text look a bit odd though with double semi-colons, but perhaps that happened during pasting/typing. If I correct the formula for that and use comma's in stead (that's how my system is set-up), it works fine on my end, although I can't check what the formula should return in your case. Can you upload a file that demonstrates the issue, without disclosing any confidential information?
Apr 14 2021 07:09 AM
@Riny_van_Eekelen Yes, attached you can find the link to Drive file
https://drive.google.com/file/d/1t2-sJlXjzHJyV8yjH6FwiRQJxKd8Sdw9/view?usp=sharing
Apr 14 2021 07:18 AM
Apr 14 2021 07:00 AM
Solution@Gianluca_mario On a Mac myself, but can't replicate your problem. The formula you mentioned in your text look a bit odd though with double semi-colons, but perhaps that happened during pasting/typing. If I correct the formula for that and use comma's in stead (that's how my system is set-up), it works fine on my end, although I can't check what the formula should return in your case. Can you upload a file that demonstrates the issue, without disclosing any confidential information?