={LARGE(Data,ROW(INDIRECT("1:"&ROWS(Data))))}The above:sorts Datacounts the largest N values of Datareverses the order of Datasums the largest N values of data
Question
Solution 1
The formula you provided seems to be written in Excel language. However, it appears to be incomplete or incorrect as it is.
The INDIRECT function in Excel returns the reference specified by a text string. In this case, "1:"&ROWS(Data) would return a reference to all the rows in the Data range.
Th Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solve study prob
Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solve study problem.
Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solve study problem.
Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solve study problem.
Knowee AI StudyGPT is a powerful AI-powered study tool designed to help you to solv
Similar Questions
={LARGE(Data,ROW(INDIRECT("1:"&ROWS(Data))))}The above:sorts Datacounts the largest N values of Datareverses the order of Datasums the largest N values of data
Which function displays row data in a column or column data in a row?Answer areaReverseNone of the aboveIndexTranspose
___________ is a database object that represents a result set and is used to manipulate data row by row
In which data layout is row data contiguous in memory?Column majorFortran data layoutArray of StructuresStructure of Arrays
The Oracle WHERE clause: A.Limits the column data that are returned.B.Limits the row data are returned