Answer the question
In order to leave comments, you need to log in
Is it possible to get a reference to a calculated cell?
The essence of the problem. There is a table with columns: Name and scores. I calculate the leader in points through the MAX in the range. Can I get the member name based on this found MAX? Conventionally, the leader is located in line 3. In D3 lies his score, which is the maximum, you need to get the NAME, which lies in C3. Thanks in advance!
Answer the question
In order to leave comments, you need to log in
in English, google for "excel find row number of maximum value"
https://exceljet.net/formula/position-of-max-value...
or in Russian, google for "excel find row number of maximum value" (yes , you can do better, but it will do)
https://office-guru.ru/excel/poisk-maksimalnogo-zn...
https://excel2.ru/articles/adres-yacheyki-v-ms-exc.. .Google
is your friend.
Finding the maximum and filtering the names by it:
=FILTER(C:C;D:D=макс(D:D))
If only the first one is needed, then use ARRAYCONSTRAIN()
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question