Larges | search
Click here to view Larges news from 60+ newspapers.
Bookmark or Share- LARGE function - Microsoft SupportDescription. Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score. Syntax. LARGE (array, k) The LARGE function syntax has the following arguments: Array Required.
- Sort data in a range or table - Microsoft SupportTo find the top or bottom values in a range of cells or table, such as the top 10 grades or the bottom 5 sales amounts, use AutoFilter or conditional formatting. Check out the video to see how it's done. Windows Web. Sort text. Sort numbers. Sort dates or times. Sort by more than one column or row. Sort by cell color, font color, or icon.
- Quick start: Sort data in an Excel worksheet - Microsoft SupportThe range can include the first row of headings that identify each column. Sort quickly and easily. Select a single cell in the column you want to sort. On the Data tab, in the Sort & Filter group, click to perform an ascending sort (from A to Z, or smallest number to largest).
- Change the plotting order of categories, values, or data seriesReverse the plotting order of categories or values in a chart. On a chart, do one of the following: To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis.
- Outline (group) data in a worksheet - Microsoft SupportIf you have a list of data you want to group and summarize, you can create an outline of up to eight levels. Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols.
More
