#N/A! error – Happens in the event the provided selection just isn't present inside the equipped reference. Also, the RANK function won't identify textual content representations of quantities as numeric values, so we will likely get the #N/A mistake if the values within the supplied ref array are textual content https://mtpolisi.com