My main problem / lack of knowledge with Excel is getting formulas that look at multiple things to work. I really struggle with it... I've got 2 different formulas, but have no idea how to make it work as one...
data is as follows:
<tbody>
A
B
C
D
E (Chris)
F (Joe)
1
05/01/17
Joe
1%...