Thursday, March 31, 2016

address of cell with maximum or minimum value in a range

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.
Best Regards,

RK

Anwsers to the Problem address of cell with maximum or minimum value in a range

Download Error Fixer (Free)

Hi,
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
 
=IF(COUNT(A1:D20)=0,"",ADDRESS(MAX((A1:D20=MAX(A1:D20))*ROW(A1:D20)),MAX((A1:D20=MAX(A1:D20))*COLUMN(A1:D20))))
=ADDRESS(MAX((A1:D20=MIN(A1:D20))*ROW(A1:D20)),MAX((A1:D20=MIN(A1:D20))*COLUMN(A1:D20)))
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.
Mike H

To check for Windows updates

  1. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  2. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  3. 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.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,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

No comments:

Post a Comment