Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
2, the I12 in the G2 cell entry examinations and test scores scores above table level.
3, entry in the D3 cell formula "= INDEX (I $ 3: I $ 12, MATCH (1, (C3> = G $ 3: G $ 12) * (C3 <= H $ 3: H $ 12), 0)) "The formula for the array as a result of the formula above in the entry end, they are required to press" Ctrl + Shift + Enter "key, for the content of the above formula together with an array formula that is marked in brackets "{}"ĄŁ The role of the formula is, according to the cell C3 students results in cell D3 automatically converted into the corresponding performance level results.
4, the cursor moved to cell D3, drag the fill handle down to cell D12, the formula for rapid replication, so that conversion can be quickly completed the work of student achievement levels (results see figure 2).
 5, also according to their own preferences, will be the range G2 to I12 is set to "hide" in order to make a more beautiful form. |
