Aug 07 2020 12:48 PM
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 photo mentioned below, I want to find smallest number from Column 'AQ' and find the number which is present in Column 'AN' with respect to that smallest number.
Aug 07 2020 01:05 PM
Solution=INDEX(AN:AN, MATCH(MIN(AQ:AQ), AQ:AQ, 0))
Aug 09 2020 07:13 AM
Thank you so much for your reply it works perfectly well just as I wanted. Thanks again.
Aug 07 2020 01:05 PM
Solution