I worked through your formula to see what it was doing and came up with an alternative test to check that the user has clicked a company from the list. =LET(ref,INDIRECT(CELL("address")),selected,IF(ISREF(ref distinctCompanies),ref,"doubleclick any cell then single click on a company"...
I worked through your formula to see what it was doing and came up with an alternative test to check that the user has clicked a company from the list. =LET(ref,INDIRECT(CELL("address")),selected,IF(ISREF(ref distinctCompanies),ref,"doubleclick any cell then single click on a company"...