FirstMaximum

From CleanPosts

Jump to: navigation, search

File:FirstMaximum.png

Returns the address of the first maximum in a range

{=ADDRESS(MIN(IF(B2:B21=MAX(B2:B21),ROW(B2:B21))),COLUMN(B2:B21),4)}
Personal tools
Strangers In Paradise