ranking

[nkob]

I have a list of numbers.
45
67
78
45
67
89
90
23

There median is 67(example)
is there a way that i can have a formula that will me which is above or
below the median.

 

[Dave Peterson]

A formula for each number?

I put your data in A1:A8 and put this formula in B1 and dragged down.

=IF(A1>MEDIAN(A1:A8),"Above",IF(A1<MEDIAN(A1:A8),"Below","Equal"))

 

[jee22]

Just sorting them will give 23,45,45,67,67,78,89,90
23,45,45 below median
78,89,90 above