Ombir
Active Member
- Joined
- Oct 1, 2015
- Messages
- 433
Hi Friends,
I need to find max and min from a given range based on criteria. Input and Output format is shown below.
Input:
<tbody>
</tbody>
<tbody>
</tbody>Output:
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>Please help with some formulae. Thanks.
I need to find max and min from a given range based on criteria. Input and Output format is shown below.
Input:
A | B | |
---|---|---|
1 | Code | Number |
2 | 01 | 1234 |
3 | 01 | 3445 |
4 | 01 | 566 |
5 | 01 | 66634 |
6 | 02 | 45678 |
7 | 02 | 33 |
8 | 02 | 456 |
9 | 03 | 3456 |
10 | 03 | 23 |
11 | 03 | 456 |
12 | 03 | 678 |
13 | 03 | 111 |
<tbody>
</tbody>
Sheet2
<tbody>
</tbody>
G | H | I | |
---|---|---|---|
1 | Code | Min | Max |
2 | 01 | 566 | 66634 |
3 | 02 | 33 | 45678 |
4 | 03 | 23 | 3456 |
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
<tbody>
</tbody>