icon of Reporter ToolBox.
It is function to get the specific vertical cell text of horizontal maximum value address, between specific start and end cell location.
If you select the 'Insert | Function' after selecting the cell (one or several), Insert Function dialogue box comes up.
After inserting the '@MaxCellText(A, B0:B3)' at Insert Function dialogue box,
you can modify this function by using the Cell
Text Edit dialogue box. This dialogue box comes up by selecting the 'Form |
Cell | Cell Text' or
icon of Reporter ToolBox.
Also, you can insert this function by using the Cell Text Edit dialogue box, without Insert Function dialogue box.
Function for text of maximum value cell uses following format.
-Function definition : double MaxCellText(Horizontal cell number to get the text, cell 1 : cell 2)
-Function parameter : Horizontal cell number to get the text(A, B, C etc), Start cell(B0, C2 etc) specific number : End cell(B3, C12 etc) specific number.
-Result : It gets the horizontal cell specific number text of vertical cell which maximum value generated.
Example of written function) =@MaxCellText(D, A5:B20);
Function description : It displays the D cell value which is located in cell location of maximum value of A5 ~ B20 at current cell.
If the maximum value is in B12 cell of A5 ~ B20, it displays the D12 cell text at current cell.
Relate items)