This article shows you how to find the cell address of the largest value in a column.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Find the cell address with the largest value in Excel
1. First, we use the MAX function to find the maximum value in column A.
2. Next, we use the MATCH function to find the row number of the largest value.
3. Finally, we use the ADDRESS function to return the address of that cell.
Explanation: the function ADDRESS to =ADDRESS(7.1), $A$7. The first parameter specifies the number of rows. The second parameter specifies the number of columns.
In addition, you can also view many other excel articles here.