What are the 'Order' options for RANKEQ and RANKAVG?
I could likely come up with this if I sat down and experimented with the formulas for a while, but I really feel like they should be listed somewhere and better documented and I'm really hoping someone else has already done the legwork. I don't even know if 'order' serves the same purpose in both formulas.
- RANKAVG says "order—[optional] The arrangement to use to evaluate the range"
- RANKEQ says "order—[optional] The method to evaluate the range"
What are the possible values?
What are their impacts?
What is the default if no order is declared?
Help Article Resources
Check out the Formula Handbook template!