Simpler formula when using data in other column as row indexing


Version: 2026

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-32021


E.g. to calculate mean of column A’s data from rows range specified in column B and D, in Origin 2026, use mean(A[B:C]), while in previous versions, needs to specify mean(A[B[i]:C[i]])

image-20250908-193553.png