The RANK functionality need to continue to work great in older worksheets. For anyone who is updating an more mature worksheet, you could optionally switch RANK with RANK.EQ and acquire a similar habits and benefits. But If you're only making use of two slots (as a consequence of limited RAM https://96.126.114.149