address of cell with maximum or minimum value in a range
i have a range 20x20.
I want to know cell address (row and column number) of the cell with highest value and cell with lowest value in this 20x20 range.
any help is much appreciated.
Anwsers to the Problem address of cell with maximum or minimum value in a range
Try these ARRAY formula.
The purpose of =IF(COUNT(A1:D20)=0,"",....
is that if the range is empty it will return D20, if the range won't be empty then this can be omitted as shown in the second formula for the min value
This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter.
If you do it correctly then Excel will put curly brackets
around the formula .
You can't type these yourself.
If you edit the formula
you must enter it again with CTRL+Shift+Enter.
If this post answers your question, please mark it as the Answer.
To check for Windows updates
- Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
- In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
- If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
Another Safe way to Fix the Problem: address of cell with maximum or minimum value in a range:
How to Fix address of cell with maximum or minimum value in a range with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your system. Run it, and it will scan your computer. The errors will be shown in the list.
2. After the scan is done, you can see the errors and problems which need to be repaired.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded