Problem:
Column D contains a list of numbers.
How could we find the minimum value in the range between row 12 (first value in the list) and each row number specified in column G?
Solution:
Using the MIN and INDIRECT functions, as follows:
=MIN(INDIRECT(\"\"$A$2:A\"\"&B2))
List1___Row Number
100_____17
70______16
400_____15
30______14
250_____13
2_______12
You can get the same result with this, therefore eliminating column B
=MIN(INDIRECT("$A$2:A"&ROW())) and for the MAX
=MAX(INDIRECT("$A$2:A"&ROW()))
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
easy way
=min($a$2:a2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks