Higher, median, & lower

[rhyse]

Hi

Need some help on this

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="class: grid, width: 0"]
<tbody>[TR]
[TD="align: center"]April 11, 2018[/TD]
[TD="align: center"]March 11, 2018[/TD]
[TD="align: center"]February 11, 2018[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E67C73]#E67C73[/URL] , align: center"]$238,912.53[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=57BB8A]#57BB8A[/URL] , align: center"]$345,568.02[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFD666]#FFD666[/URL] , align: center"]$266,331.18[/TD]
[/TR]
[TR]
[TD="align: center"]LOWER[/TD]
[TD="align: center"]HIGHER[/TD]
[TD="align: center"]MEDIAN[/TD]
[/TR]
</tbody>[/TABLE]


Is there anyway that i can get where it says "LOWER" "HIGHER" & "MEDIAN" to automatically populated based on whether the number is the highest, median, or lowest?

Thanks!

Tried so many formulas without any luck!

 

[jtakw]

Hi,

I'm not sure if I understand correctly, you can do this, I switch the numbers around a bit:

Excel 2010
	A	B	C
1	11-Apr-18	11-Mar-18	11-Feb-18
2	$238,912.53	$345,568.02	$548,456.58
3	LOWER	MEDIAN	HIGHER
Sheet2

Cell Formulas
Range	Formula
A3	=CHOOSE(RANK(A2,$A2:$C2,1),"LOWER","MEDIAN","HIGHER")

A3 formula copied across.

 

[rhyse]

That worked! Thank you so much!

 

[rhyse]

I have another one that i am struggling with, if you would not mind helping me on this one

https://www.mrexcel.com/forum/excel-questions/1051386-sum-based-date.html

 

[FlameRetired]

Hi

Need some help on this

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="class: grid, width: 0"]
<tbody>[TR]
[TD="align: center"]April 11, 2018[/TD]
[TD="align: center"]March 11, 2018[/TD]
[TD="align: center"]February 11, 2018[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E67C73]#E67C73[/URL] , align: center"]$238,912.53[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=57BB8A]#57BB8A[/URL] , align: center"]$345,568.02[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFD666]#FFD666[/URL] , align: center"]$266,331.18[/TD]
[/TR]
[TR]
[TD="align: center"]LOWER[/TD]
[TD="align: center"]HIGHER[/TD]
[TD="align: center"]MEDIAN[/TD]
[/TR]
</tbody>[/TABLE]


Is there anyway that i can get where it says "LOWER" "HIGHER" & "MEDIAN" to automatically populated based on whether the number is the highest, median, or lowest?

Thanks!

Tried so many formulas without any luck!

Another way. In A3 and filled across.

=INDEX({"LOWER","MEDIAN","HIGHER"},MATCH(A2,PERCENTILE($A$2:$C$2,{0,0.5,1}),0))

 

[jtakw]

That worked! Thank you so much!

I have another one that i am struggling with, if you would not mind helping me on this one

https://www.mrexcel.com/forum/excel-questions/1051386-sum-based-date.html

You're welcome.

Replied at your other thread also.

 

[Rick Rothstein]

Another way. In A3 and filled across.

=INDEX({"LOWER","MEDIAN","HIGHER"},MATCH(A2,PERCENTILE($A$2:$C$2,{0,0.5,1}),0))

And one more...

=IF(A2=MAX(A2:C2),"HIGHER",IF(A2=MIN(A2:C2),"LOWER","MEDIAN"))