Thread
:
Identify where max values are found
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ken Johnson
Posts: n/a
Identify where max values are found
Hi Owen,
this worked for me...
=ADDRESS(ROW(B10)-1+MATCH(MAX(B10:B34),B10:B34,0),COLUMN(B10),4)
Ken Johnson
Reply With Quote
Identify where max values are found