Highest Letler

[yanks08701]

In the attached would someone be able to provide me with a formula that gives me the highest letter in column D given that column B is either in 2016 or 2017? Thank You

[FDibbins]

See if this will give you a start, it ranks all letters, just ignore all the 1's, they are not being used. You can quickly tell which is highest...

	J	K
5	1	a
6	1	b
7	1	c
8	3	d
9	39	e
10	57	f
11	64	g
12	66	h
13	66	i
14	66	j

J5=SUMPRODUCT(--(K5>D$5:D$71))+1
copied down

K5 down were manually entered