Jul 05 2022 01:39 AM
Hi,
I am using the following function MINIFS with the prefix _xlfn to find the minimum value metting 2 criteria (=+_xlfn.MINIFS(E:E;D:D;D2;C:C;C2)), but I keep #NAME? error (I have the updated version of 365). Any suggestions?
Jul 05 2022 01:47 AM
Solution@Jacqui2312 MINIFS is supported by Excel 2019 and later. The prefix shows up when you open the file in an older Excel version. But when you open the file in MS365 the _xlfn. prefix should not appear. If you are in MS365 and the prefix is visible anyway, it may have been typed into the formula. Just delete it, I would say.
Jul 05 2022 01:47 AM
Solution@Jacqui2312 MINIFS is supported by Excel 2019 and later. The prefix shows up when you open the file in an older Excel version. But when you open the file in MS365 the _xlfn. prefix should not appear. If you are in MS365 and the prefix is visible anyway, it may have been typed into the formula. Just delete it, I would say.