If to be limited only to applied aspect of finding of the maximum element of the massif, that is not to tie this operation to the rules imposed by some concrete programming language, then it is the simplest to use for the solution of a task the tabular editor of Excel from structure of the Microsoft Office software package. Its opportunities are quite enough for work with data arrays which volume does not demand for programming application processing.
Instruction
1. Start the tabular editor and load into him data array which maximum element is required to be found. If basic data are not stored in the file any of the "native" Microsoft Excel formats (xls, xlsx, etc.), then it is possible to keep, for example, them in a csv-file format - Excel has flexible settings for analysis of data in such files. And it is possible just to copy data of the massif in a text format and to insert into the empty page of the tabular editor. To place data in a column each element of the massif has to be in a separate line, and for placement them in cells of one line the sign of tabulation has to be a divider.
2. Click an empty cell in which you want to see the index of the maximum element of the massif, and then press the pictogram "To insert function", placed more to the left of a line of formulas over the table. In a drop-down list "Category" of the opened dialog box choose the line "References and Massifs" and in the list of functions choose "POISKPOZ", and then press the OK button.
3. Enter the function which is carrying out search of the maximum element in the field Iskomoye_znacheniye - MAKC (). Then install the cursor between brackets of this function and specify the column containing the values of the massif entered by you. For this purpose just click heading of this column. It is necessary to specify the same range of cells in the Prosmatrivayemyy_massiv field, that is click the same heading once again. In the field Tip_sopostavleniya surely deliver zero, and then press the OK button. Excel will find the maximum value in the specified range of cells and will display the line number which will be the index of the maximum element in the massif.
4. Change if it is necessary, data of the massif - the formula entered by you will make repeated calculations after each such change, showing the index of the maximum element after the made changes.