How to find address of cell with max or min value in Excel?
Sometimes you may want to find out and identify the cell address of the cell with the max value or min value in Excel. How do you deal with it? The following ways will guide to figure out the cell address with max or min value in Excel.
Find and extract address of the cell with max or min value with formulas
Supposing you have a lot of numbers in Column A, and now you need to find out the cell address of the max value or min value and insert the cell address into another cell as following screenshot shown:
The following formulas may help you to extract the cell address of the largest number or smallest number as you need. Please do as follows:
Type the below formula, into a blank cell where you want to get the result, and then press Enter key.
4. With above formulas, it will just return the first address of cell with largest or smallest value if there are duplicates.
Find and locate address of cell with max or min value with Kutools for Excel
Sometimes, you need to find and locate the smallest or largest value from the list, Kutools for Excel’s Select Cells with Max & Min Value feature can help you quickly select the max or min values from a range of cells or each row and column.
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.
How to select non-blank cells in a range in Excel? Let’s say there are many nonadjacent blank cells existing in a range, and now you need to select all cells with content at present. How to easily select all non-blank cells in Excel easily? There are several tricks to solve it.
How to select and highlight diagonal cells in Excel? In Excel, we usually need to select multiples cells, but have you ever tried to select and highlight the diagonal cells in a range? In this article, I will introduce a VBA coed to quickly select diagonal cells for you.
How to find maximum or minimum absolute value and keep sign in Excel? In Excel, if there are some values in a column that both include positive and negative values, generally, you can find the maximum and minimum values of their absolute values by using the formula that combines MAX and ABS functions. But sometimes, you may want to find the maximum or minimum values of their absolute values but keep their sign when returning the result as the below screenshot shows. How can you solve this job?
How to get max/min of visible cells only in Excel? We can apply the Max function and Min function to easily get the max/min in a range in Excel. But, any idea to get the max/min value with ignoring hidden cells? And what if applying conditional formatting to visible cells only for highlighting the max/min values? The following solutions will ease your work: