Hello,
Looking for some help would would save lots of time and manual labor. It is a basic index match with 3 criteria; as well as obtaining the MAX value of the index.
So; the raw data looks like such.
<tbody>
SHEET 1
A
B
C
D
E
1
Group
Business
Control
Risk1
Risk2
2
ABC...