Thread: Help Displaying Values and Linking
View Single Post
 
Old 01-03-2019, 01:19 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
A formula solution:

A: =ADDRESS(MATCH(MAX($F$320:$F$465),$F$320:$F$465,0) +CELL("row",$F$320:$F$465)-1,6)

B: =ADDRESS(MATCH(MAX($F$320:$F$465),$F$320:$F$465,0) +CELL("row",$F$320:$F$465)-1,1)
Reply With Quote