Quote:
Originally Posted by Bernard Liengme
A1:A6 has some names
B1:B6 has some numbers
=INDEX(A1:A5,MATCH(MIN(B1:B5),B1:B5,0))
returns the name from A associated with the minimum number in B
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"bikemrh" wrote in message
...
No, this is in three colums. Column 1 has the text, column 2 has a single
digit and Column three has the values.
"Bernard Liengme" wrote:
Is all this data in a single column? If so it will be hard to fulfill
your
request
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"bikemrh" wrote in message
...
Hi,
Question: I need to take a number (minimum value) from one cell and
find
the cell it came from, then return the text of the correspondeing cell
to
the
right but return the text that is 3 cells above. The Net Score of -4
would
be
the value in say C30. I would want to show in C31 the text in Name1
(A1)
EX.
Name1
Hdcp 22 9
Score 5
Net Score -4
Name2
Hdcp 7 3
Score 2
Net Score -1
|
I don't mean to "Jump in the middle" here iwth a question of my own, but I'm really having a hard time with this. I need to find a way to find the minimum value of a cell that corelatetes to the other cells around it. For example:
In column A I have text that has to be correlated with the numbers in column B (You see Column A has the names of the Suppliers while Column B has their rates). And I need to mathc them up with what region they came from (Which is text in column C) and in Columns D & E I have the carriers and their rates.
So, in a nutshell, I need a formula that can return the minimum supplier rate from the same terminal it's quoted from with the minimum rate from the carrier. Any and all help will be appreciated.
Similar Threads
Threaded Mode
