#N/A! error – Takes place once the presented selection will not be current within the equipped reference. Also, the RANK operate isn't going to acknowledge text representations of quantities as numeric values, so we can even get the #N/A error When the values inside the provided ref array are textual https://mtpolisi.com