Hi

I'm having a problem with the RANK.AVG function. For one list of data, it works as normal: any pieces of data that hold the same rank results in an average rank for both of them. However, when I try this on another set of data, it functions exactly the same as the standard RANK function in that no averaging takes place. This is extremely frustrating, I've been checking everything for around an hour and can see no reason why this would occur, any ideas?