Question Réponse
I have a question I will ask it as an example:
I have two columns A and B (as if I want to plot them in a graph). I want to extract the maximum value of the column A so I used the formula =MAX(A1:A5000) {for example}. Now I want to extract the respective value in column B and I do not know how. For example if the maximum value is located in A2000 I want in another cell to have the value of B2000.
Thank you in advance
Posté le 12 décembre 2019, 15:12Hello,
My english is not very good but i shall try...
You must use the functions EQUIV and INDEX to find your MAX value.
I joing an exemple
https://www.cjoint.com/c/ILmrylnMbfz
The formulas is
=INDEX(Tableau1[COL B];EQUIV(D3;Tableau1[COL A];0);1)
I have work with a "Tableau". The function EQUIV look in COL A to find the MAX value in cell D3. So we know the row and we can find in the COL B the value at the same row.
I hope that you have understand
BYBY
Posté le