Hi, this seems simple but I just can’t get it to work.
I’ve got two columns of data, and what I’m after is the third column.
I need a formula I can roll down that will set out the minimum of each group in the third column – I suspect an array would work?
<tbody>
</tbody>
I’ve got two columns of data, and what I’m after is the third column.
I need a formula I can roll down that will set out the minimum of each group in the third column – I suspect an array would work?
Group | Value | Min of Group |
A | -2 | -2 |
A | 4 | |
A | 0 | |
B | 3 | |
B | 6 | |
B | 0 | 0 |
C | -2 | |
C | -8 | -8 |
D | 3 | |
D | 9 | |
D | 4 | |
D | -4 | -4 |
<tbody>
</tbody>