ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Minimum value location (https://www.excelbanter.com/excel-programming/280059-minimum-value-location.html)

Mike Toller

Minimum value location
 

-----Original Message-----
I an writing a macro to do a bunch of calculation and
place the result in a column. I want to be able to ID
the row with the minimum value. what is the easist way
to do that?
.
=MATCH(MIN(array),array,0)



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com