={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
={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
Solution
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.
The ROW function returns the row number of a reference.
The LARGE function returns the k-th largest value in a data set, where k is the value you specify.
However, the formula as it is written does not make sense because the LARGE function is not present, and the ROW and INDIRECT functions are not properly used.
Therefore, none of the options you provided are correct based on the formula. It neither sorts Data, counts the largest N values of Data, reverses the order of Data, nor sums the largest N values of data.
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
The LARGE or SMALL functions can be used with arrays to get the k largest or smallest values in a dataset. This process can use variable number for k in the formula by using the & and connecting it to a cell that can change. True False
={INDEX(Data,MATCH(ROW(INDIRECT("1:"&ROWS(Data)))-1,COUNTIF(Data,"<" &Data),0))}Sorts the data from last to firstSorts the data alphabeticallyHighlights a number if it is less than DataGives the position of the least element in Data minus one
Which function displays row data in a column or column data in a row?Answer areaReverseNone of the aboveIndexTranspose
If the range and the smallest value of a set of data are 36.8 and 13.4 respectively, thenfind the largest value.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.