Forum Discussion

Copper Contributor

Dec 08, 2023

Searching a complex set of data

I have an Excel File generated from a debase report. Each "Record" in the database fills 6 rows by 15 columns. I want to sort the "records" by cell Row3 Column N. Any idea how to do that?

BI & Data Analysis

Excel on Mac

PeterBartholomew1

Silver Contributor

Dec 08, 2023

Greg_Taylor

= LET(
    blockHeight,    6,
    blockWidth,    15,
    keyRow,         3,
    keyColumn,     14,
    singleRows,    WRAPROWS(TOCOL(data), blockHeight*blockWidth),
    sortedRecords, SORT(singleRows, (keyRow-1)*blockWidth+keyColumn),
    displayed,     WRAPROWS(TOCOL(sortedRecords), blockWidth),
    displayed
  )

Another strategy might be required if you have more than 10,000 records