how to find the location of minimum value in an array

[Nas2391]

---

i have one row and 5columns.(row-a, columns-a,b,c,d,e)
nd each of the cells have a value.(eg: 256,5255 etc). i have written a code to extract the last digit of al the values and stored them in an array.
now my question is how to find the min of al the values stored in the array and its respective position in the excel sheet.

can some1 help me out in this.


thanks in advance

 

[Ishan]

Hi Nas2391,

This might help.

=IF(MIN($C$1:$C$5)=C1,ROW(C1),0)

So according to this formula, The Number represents the required Row having the minimum Value.

Regards,

Ishan M Mehta

 

[Nas2391]

hey ishan can u jus xplain me wat xactly u did here?

and there's is only one row. so no need to find out the row number..

i need to find the column number in which the minimum value is found.

 

[raj2206]

Hi,
Thanks for writing!

You can use the formula:

="Value "&MIN(--RIGHT(A1:E1,1))&" Position "&MAX(((MIN(--RIGHT(A1:E1,1)))=(--RIGHT(A1:E1,1)))*(COLUMN(A1:E1)))


Split the formula if you need the values in different cells.

Also make sure you use Control+Shift+Enter while entering the formula since its an array operation.

Thanks/Raj

 

[Nas2391]

hey thanks raj.
but i dint find any usage of the array in the above formula..
i want the formula for findin out the min value in array and its position.(because i stored al the last digits of values in the array and i want the min of them)

 

[Ishan]

H Nas2391,

Could you pls share some part of your data so we can work it out clearly.


Regards,

Ishan

 

[Nas2391]

for eg:


row1

 

[Nas2391]

for eg:

c1 c2 c3 c4 c5 c6

r1 5275 5276 5273 5274 258 273

so now i collected al the last digits of the values in to an array.
so i need to find the smallest of al the last digits that are stored in the array and i need to find the location of it( i mean from which column is it comin)

now there are two 3's and it is the smallest.. i need to knw from wat al columns is 3 cming.