Does anyone know how to combine vlookups and max/min functions?
Below is an example of my data.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Below is an example of my data.
Data Sample | ||
Type | Begin | End |
a | 0 | 10 |
a | 10 | 20 |
a | 20 | 30 |
b | 30 | 40 |
b | 40 | 50 |
b | 50 | 60 |
c | 60 | 70 |
c | 70 | 80 |
c | 80 | 100 |
d | 0 | 5 |
d | 5 | 12 |
d | 12 | 22 |
d | 22 | 35 |
Desired Result: | ||
Type List | Min Begin | Max End |
a | 0 | 30 |
b | 30 | 60 |
c | 60 | 100 |
d | 0 | 35 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>