What are the 'Order' options for RANKEQ and RANKAVG?

Hey,

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?

Find more posts tagged with

Formulas

Accepted answers

Genevieve P.

Hi @P_Youderian

Great question! This is specified in the functions when you're typing them into the sheet, but you're right, the Help Articles don't have this detail written out. I've submitted feedback on these articles so we will update them in the future.

The values are either 0 or 1.
0 is descending order.
1 is ascending order.
0 is the default.

Screen Shot 2022-01-31 at 10.02.07 AM.png

Cheers,

Genevieve

All comments

Genevieve P.

Hi @P_Youderian

The values are either 0 or 1.
0 is descending order.
1 is ascending order.
0 is the default.

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.