Friggin_Lazy
asked on
Explain this formula please
could someone please explain what this formula is doing..?
{=MODE(IF(COUNTIF(A$43:A43 ,DATA!J2:J 65535)=0,D ATA!J2:J65 535+{0,0}) )}
{=MODE(IF(COUNTIF(A$43:A43
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thank you. Sorry, I notice that the $ signs weren't included in that last formula, so the suggested formula to copy down and exclude blanks should be
=MODE(IF(data!J$2:J$65535< >"",IF(COU NTIF(A$43: A43,data!J $2:J$65535 )=0,data!J $2:J$65535 +{0,0})))
regards, barry
=MODE(IF(data!J$2:J$65535<
regards, barry
ASKER