Function for Cell Address

[Des_cool]

Does anyone know how to use a cell address function to find the Minimum value in an array?

=CELL("address",MIN(W4:AE4)) I tried using this, but I am getting an error. If there's something I am missing please let me know. Thanks!

 

[Momentman]

Maybe

Book1
	W	X	Y	Z	AA	AB	AC	AD	AE
4	9	2	3	7	11	15	1	3	15
5
6
7		$AC$4
8		$AC$4
Sheet1

Cell Formulas
Range	Formula
X7	X7	=ADDRESS(4,MATCH(MIN($W$4:$AE$4),$W$4:$AE$4,0)+COLUMN(W4)-1)
X8	X8	=CELL("address",INDEX($W$4:$AE$4,MATCH(MIN($W$4:$AE$4),$W$4:$AE$4,0)))

 

[Des_cool]

Thanks this is helpful!