Forum Discussion
Solved
Finding specific cell with respect to column.
Hello. I wanted to find the smallest number in a column and then find the specific cell in the row of that smallest number. I wanted to know the formula using which I can do mentioned above. In phot...
=INDEX(AN:AN, MATCH(MIN(AQ:AQ), AQ:AQ, 0))
=INDEX(AN:AN, MATCH(MIN(AQ:AQ), AQ:AQ, 0))
Thank you so much for your reply it works perfectly well just as I wanted. Thanks again.