User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Excel: Min/Max values between 2 named ranges Page [1]  
wdprice3
BinaryBuffonary
45451 Posts
user info
edit post

Is there a simple way to handle named ranges when calculating the min/max values within (not of) those named ranges?

A1:A10 is called Range1 and has various calculated values
B1:B10 is called Range2 and has various calculated values
C1:C10 is called Result and each row should determine the Max (or min) of that row from Range1 and Range2

e.g. :
C1: =Max(Range1,Range2) Result should be the maximum value in row 1 between Range 1 and Range 2
C2: =Max(Range1,Range2) Result should be the maximum value in row 2 between Range 1 and Range 2
...

As written above, the result is just 0;

7/17/2015 2:23:04 PM

darkone
(\/) (;,,,;) (\/)
11064 Posts
user info
edit post

I'm not quite following what you're trying to do. Do you want output like this?:


A B C
10 1 10
5 50 50
12 12 12
...

7/17/2015 2:35:33 PM

wdprice3
BinaryBuffonary
45451 Posts
user info
edit post

yep

An if statement works fine for 2 named ranges; but I've 5+ ranges to compare, and I don't like those kinds of if statements.

[Edited on July 17, 2015 at 2:41 PM. Reason : .]

7/17/2015 2:37:09 PM

wdprice3
BinaryBuffonary
45451 Posts
user info
edit post

Ok, got it this time, I think. testing, so BRB

So this may turn out to be simple as shit, and I don't know why it works, but...

C1: MAX(VALUE(RANGE1),VALUE(RANGE2)) works for a row-by-row max/min comparison within named ranges.
(e.g., copy that formula down in C2..C10 to get the maximum value in each row from Rows 1..10 in ranges Range1 and Range2)

[Edited on July 17, 2015 at 2:57 PM. Reason : .]

7/17/2015 2:47:53 PM

darkone
(\/) (;,,,;) (\/)
11064 Posts
user info
edit post

C1=MAX(A1:B1)

7/17/2015 3:03:50 PM

wdprice3
BinaryBuffonary
45451 Posts
user info
edit post

[using named ranges] that's the entire reason I asked. I know how to do a cell reference formula for this; it's the named range thing that got me.

[Edited on July 17, 2015 at 3:15 PM. Reason : .]

7/17/2015 3:14:11 PM

darkone
(\/) (;,,,;) (\/)
11064 Posts
user info
edit post

I'm confused as to why you need the named ranges as opposed to cell references.

7/17/2015 3:22:06 PM

 Message Boards » Tech Talk » Excel: Min/Max values between 2 named ranges Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2018 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.37 - our disclaimer.