| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return the Row number
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return the Row number
One guess, maybe you meant something like this:
=VLOOKUP(MIN(A:A),A:D,MATCH(MIN(A:A),A1:D1,0),0) -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "Kenneth" wrote: 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.? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return the Row number
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" wrote: One guess, maybe you meant something like this: =VLOOKUP(MIN(A:A),A:D,MATCH(MIN(A:A),A1:D1,0),0) -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "Kenneth" wrote: 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.? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return the Row number
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 --- "Kenneth" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return first 3 digits of a number? | Excel Worksheet Functions | |||
| Function that can return the row number | Excel Worksheet Functions | |||
| Return a High Number | Excel Worksheet Functions | |||
| How to format number and not return ###### | Excel Worksheet Functions | |||
| Want to return a value based on a whether a number is within a ra. | Excel Worksheet Functions | |||
Linear Mode
