When using RANK.AVG with a range that includes missing or blank values, it will ignore them and assign ranks to the remaining values based on their actual position in the range.