Which formula to use?

[forexcel]

	1	2	3	4	5	6	7	8	9	10
a
b
c
d
e
f
day	1		1		2		2		2		3		4		4		5		6		6		6
	a	12	a	15	b	25	a	13	e	25	f	18	f	22	e	32	a	5	c	52	a	13	b	9
	b	21	b	17	e	12	d	26	f	15	b	34	d	34	f	42	b	15	d	28			c	25
	c	24	d	23	d	46			b	34			e	23	a	3	c	37	a	17			d	16
			f	42					c	34

<tbody>
</tbody>

In the above sheet there is a table at lower part where top row is day and following rows have a letter in first column and a number in second row. There can be many entries of each day usually 1-3. What I want to do is it make a formula to the table at above the data table which will calculate the max of each letter per day
So result should be like

	1	2	3	4	5	6	7	8	9	10
a	15	13
b	21	34	34
c	24	34
d	23	46
e		25
f	42	15	18

<tbody>
</tbody>

Which formula to use?

 

[steve the fish]

This is not a good way to store your data at all. That said this works entered CTRL-SHIFT-ENTER

=MAX(IF($B$8:$X$8=B$1,IF($B$9:$X$12=$A2,$C$9:$Y$12)))