Let's say I have the following:
<tbody>
</tbody>
Is it possible to attribute the minimum value of the "B's" within my data range to the Min B cell and vice versa for the P value? Essentially find the minimum of each type (B or P) depending on what the cell adjacent to it is specifying? It would only be 2 types in the adjacent cells, B or P but mixed and matched within the data range as shown in the table and in no particular order. I want to report back in those 2 cells above the respective minimums for each.
Here's what I have, for finding the minimum of the values on the right, not too sure how to associate the adjacent values. FYI the reason it is set up is that I am not sure how many values I will have in a given file as it is user dependent.
=MIN(B5:OFFSET(B5|COUNT(B5:B1001)-1|0))
Min B | |
Min P | |
Column A | Column B |
Type | Value |
B | 170 |
P | 150 |
P | 151 |
B | 181 |
B | 100 |
P | 101 |
<tbody>
</tbody>
Is it possible to attribute the minimum value of the "B's" within my data range to the Min B cell and vice versa for the P value? Essentially find the minimum of each type (B or P) depending on what the cell adjacent to it is specifying? It would only be 2 types in the adjacent cells, B or P but mixed and matched within the data range as shown in the table and in no particular order. I want to report back in those 2 cells above the respective minimums for each.
Here's what I have, for finding the minimum of the values on the right, not too sure how to associate the adjacent values. FYI the reason it is set up is that I am not sure how many values I will have in a given file as it is user dependent.
=MIN(B5:OFFSET(B5|COUNT(B5:B1001)-1|0))