Hello,
I'm writing to you with (I hope) simple problem. My knowledge about Excel is really, really small, so please don't judge me.
This is my chart and some data (not in english, but this shouldn't matter):
problem.png
The 'x' coordinate is column C called Ranga (Rank)
The 'y' coordinate is column I or J (values from 0 to 1) called Wygrane/Rozgrywki (GamesWon/Games)
My problem is, how to find the highest common value for those two charts, which I marked with a green arrow? I'm interested in finding value of 'x' coordinate (Rank).
Thanks for help!
Bookmarks