NTHIGHEST, NTHLOWEST

 Top  Previous  Next

Keyword Description

nth highest or nth lowest value in a range

Class

Function

Where Legal

Resources

Entry Logic

Exit Logic

Initial Size

Resize

(Pre-Category)

Resize

(Category-Level)

l

l

l

 

 

 

Syntax

NTHIGHEST[COLn, d, v] 

Where n is a column number, d is days, v is rank of the value.

Example

Sample code

COL2 = NTHIGHEST[COL1, 45, 10] ' 10th highest value in last 45 days

COL3 = NTHLOWEST[COL1, 45, 10] ' 10th lowest value in last 45 days