Return the Row number

[Kenneth]

hi, I have got some questions.

I have a table, I want to get the minimum value of a particular row.
I try to do as this
=vlookup(My value, The table, *******)

******* should be the column that shows the minimum value of "My value"

How can i call that column out.?
Thanks.
Kenneth

 

[Max]

One guess, maybe you meant something like this:
=VLOOKUP(MIN(A:A),A,MATCH(MIN(A:A),A11,0),0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik

 

[Kenneth]

Maybe I give you my example ...

Node 0 1 2 3
0 0 4 5 6
1 2 0 4 6
2 3 5 0 6
3 2 1 4 0

I will start from Node 0 .
I wish to get the value of node 1 ,
then node 0 will be delete, and node 2 is then found.

 

[Max]

Guess I'm out of ideas here for you, sorry. If your intents involve
"deleting" stuff along the way, then a formulas solution is out. Formulas
cannot delete stuff, they can only return calculated values in the very
cells that they are placed in. Try posting afresh in excel.programming
newsgroup, and provide more elaboration in your example. Good luck.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik