Microsoft KB Archive/65764

{| = Macro to Activate the Maximum Value of a Column =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q65764

SUMMARY
The following macro will activate the cell with the maximum value in the column that contains the active cell on the active sheet:

A

1 Find_Max 2 =FORMULA.FIND(MAX(TEXTREF(GET.DOCUMENT(1)&&quot;!c&quot;)),2,1,2,1) 3 =RETURN MAX(TEXTREF(GET.DOCUMENT(1)&&quot;!c&quot;)) finds the maximum value in the column containing the active cell in the active document.

FORMULA.FIND(Max,2,1,2,1)
Max is the maximum value as found by MAX. ,2,1,2,1 tells FORMULA.FIND to look in values, at the whole value, in columns, and to find the next occurrence of Max.
 * }