Cell Address from result of Min

[scottylad2]

Is there a way to return the Cell Address form the resukt of a Min formula, example =MIN(V7,AF7,AP7,AZ7,BJ7,BT7) the result is .99 in AZ7, i would like to retun the cell address AZ7...

as always, any help greatly appreaciated

[tigeravatar]

scottylad2,

The way you have it setup would make it a bit difficult. I would recommend putting the making a table. In the first column of the table would be cells that are equal to V7,AF7,AP7,AZ7,BJ7,BT7. Then in the second column of the table would be those cells' addresses. Then you could use a vlookup to find the min value in that table and return the cells' associated address. I've attached a sample workbook so you can see what I mean.

Hope that helps,
~tigeravatar

[ChemistB]

Something like
=ADDRESS(MATCH(MIN($A$1:$A$8),$A$1:$A$8,0),1,4)

[tlafferty]

I've personally wondered how to do that for a while - thanks!

[NBVC]

If you were only wanting to look at those specific cells because other numbers could appear in between that you wanted to exclude, then try:

=ADDRESS(7,MIN(IF((MOD(COLUMN(V7:BT7)-COLUMN(V7),10)=0)*(V7:BT7),COLUMN(V7:BT7))),4)

confirmed with CTRL+SHIFT+ENTER not just ENTER

[scottylad2]

ChemistB that does the trick, thanks