Look up high and low values, then define them

[pacerfan07]

Hi,

I'm trying to take a list of values in Column A, then in Column B define which ones are "high ranked" and which are "low ranked" So if I have the table shown below, I 'd like to take the top two values in column A and in column B label those as "high" and the bottom two should show as "low". The middle two are "avg." Thanks!

	A	B
1	30
2	40
3	80
4	20
5	15
6	50

<tbody>
</tbody>

 

[Scott T]

Try

=IF(A1>=LARGE($A$1:$A$6,2),"High",IF(A1<=SMALL($A$1:$A$6,2),"low","avg"))

 

[pacerfan07]

worked perfect thanks!

 

[Scott T]

You're welcome