Dividing Rankings into Quarters

[nirvehex]

Hi,

I have a list of letters that are ranked in unique alphabetical order.

I-H-H	27
I-H-H	27
A-A-A	1
J-I-J	47
J-H-H	41
J-I-I	46

<tbody>
</tbody>

What I'm trying to put in the third column is what quarter they fall into. Note this list is longer and goes 1-52. So each quarter would be 13 numbers. Q1 = 0-13, Q2 = 14-26, Q3=27-39, Q4 = 40-52.

How do I write a formula that puts their quarter in column 3?

Thanks all!

 

[Marcelo Branco]

Maybe....

	A​	B​	C​
1​	Letters​	Rank​	Quarter​
2​	I-H-H​	27​	Q3​
3​	I-H-H​	27​	Q3​
4​	A-A-A​	1​	Q1​
5​	J-I-J​	47​	Q4​
6​	J-H-H​	41​	Q4​
7​	J-I-I​	46​	Q4​

Formula in C2 copied down
=LOOKUP(B2,{0;14;27;40},{"Q1";"Q2";"Q3";"Q4"})

Hope this helps

M.