Return the Row number

K

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
 
K

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.
 
M

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
 
Top