Sorting a List

One of the most common operations performed on a list is sorting it in increasing or decreasing order with respect to the value in one of its fields. Use the Sort... command in the Data menu to do this. 

To sort the list according to any of its fields, select the complete list (be sure to select all rows and columns, or the list may become irreversibly scrambled). 

For a large list such as this one, it s convenient to use one of the methods for selecting a block of cells described in Chapter 1 select the first row of cells and press CONTROL+SHIFT+(down arrow) or place the mouse pointer on the bottom edge of the selected row, hold down the SHIFT key and double-click to select all cells to the bottom of the block. Then choose Sort... from the Data menu to display the Sort dialog box. 

---

You can use the LARGE worksheet function in an array formula to sort a list of number values automatically by means of an array formula, rather than manually by using the Sort... command. 

As you can see from the Sort dialog box, it is possible to sort by up to three separate fields. For example, you can sort a list of chemistry students by descending order according to year of graduation (freshman, sophomore, junior, senior) and by ascending order alphabetically within each year. 

Excel assumes that your data fields are in columns and sorts your list by rearranging rows. If you want to sort a list horizontally (i.e., to rearrange the columns of the list rather than the rows) press the Sort Left to Right button in the Orientation box (Figure 6-4). 

Merging two sorted lists requires only one traversal of each list—the key idea in merg sort. To sort a list by merging, one begins with many short sorted lists. Often those runs of elements in a random list that are already in order form one of them. The process merges them two at a... 

The time to sort a list is therefore proportional to the number of entries (four entries per cell, given the four vertices per cell) and the width of the key in bits. If the vertices are numbered from 1 to NVERTS, where NVERTS is not much larger than the number of cells, the number of bits of the key is proportional to the logarithm of the number of cells. Thus the binary radix sort operates in this case on a permutation of the integers from 1 to NUMEL... 

Once the basic work has been done, the observed spectrum can be calculated in several different ways. If the problem is solved in tlie time domain, then the solution provides a list of transitions. Each transition is defined by four quantities the mtegrated intensity, the frequency at which it appears, the linewidth (or decay rate in the time domain) and the phase. From this list of parameters, either a spectrum or a time-domain FID can be calculated easily. The spectrum has the advantage that it can be directly compared to the experimental result. An FID can be subjected to some sort of apodization before Fourier transfomiation to the spectrum this allows additional line broadening to be added to the spectrum independent of the sumilation. 

A list of potential bidders can be generated from the Assessed Subcontractors List by searching for subcontractors that match given input criteria specific to the particular procurement. However, the evidence you gathered to place subcontractors on your Assessed Subcontractors List may now be obsolete. Their capability may have changed and therefore you need a sorting process for specific purchases. If candidates are selected that have not been assessed, an assessment should be carried out before proceeding any further. 

Here is a list of sweeteners sorted according to how sweet they taste ... 

The user can find suitable materials in a number of different ways. For instance any of the above measurands can be chosen and a search made within a specific matrix type. A list of the measurand values in all materials of the selected matrix classification sorted by decreasing concentration will be produced, including the uncertainties in percent, the certification status and the material identification code. Other search methods are possible, selection by material gives a table with values of all measurands in the chosen material in alphabetical order and additional information about the price, the unit size, the issuing date, the supphers and the exact material name. A further option is to list all materials from a producer. 

We have explicitly identified a separate new type for sorted lists of each item type (you can t put a Banana in a Sorted Integer List). The template imposes on the item types the properties of the relevant operators. Notice that we also substitute < which the Sorted List Template has imported from TotalOrdering. If you put a bunch of Bananas into a... 

When the input list is finished, the interpreter checks the equations against each other, to ascertain that a reaction has not inadvertently been entered more than once, even with permutations of the reactants or products. Finally, if all input has been error-free, the interpreter continues by lexically sorting the atomic elements and species names, assigning final identification numbers, and providing a list for the user. 

Table 11.4. A list of genes that define minimal cells, sorted by functional category...

Although Ashm. 1403 is not dated, that it preceded Ashm. 1436 is evident from the incorporation of marginal additions from Ashm. 1403 into the main text in Ashm. 1436. On fo. i Forman wrote, Of the pl ue generally and of his sortes. Of those things that moste commonly forshowe a pl ue. This is the beginning of a list of contents, not the title of the work. 

---