Hello-
I've been searching forums all morning trying to find a way to find a way to get the minimum value using two criteria. Here's a sample of what my data looks like, and ideally what I'd like to see as a result.
<tbody>
</tbody>
Ideal output:
<tbody>
</tbody>
I am familiar with Arrays, and I have done a Max(if( nested statement to get the results I need, but I'm also building a macro that will loop through my output (could be 100k+ rows) and the Array Formula just doesn't seem efficient.
Is there a way to write some VBA code to loop through and find the min based on two criteria (Case # and Size)??
I've been searching forums all morning trying to find a way to find a way to get the minimum value using two criteria. Here's a sample of what my data looks like, and ideally what I'd like to see as a result.
Case # | Size | Date |
1 | Small | 201501 |
1 | Small | 201512 |
1 | Large | 201503 |
1 | Large | 201508 |
1 | Large | 201511 |
2 | Large | 201507 |
2 | Large | 201511 |
2 | Small | 201503 |
2 | Small | 201508 |
2 | Small | 201501 |
<tbody>
</tbody>
Ideal output:
Case # | Size | Min | Max |
1 | Small | 201501 | 201512 |
1 | Large | 201503 | 201511 |
2 | Small | 201501 | 201508 |
2 | Large | 201507 | 201511 |
<tbody>
</tbody>
I am familiar with Arrays, and I have done a Max(if( nested statement to get the results I need, but I'm also building a macro that will loop through my output (could be 100k+ rows) and the Array Formula just doesn't seem efficient.
Is there a way to write some VBA code to loop through and find the min based on two criteria (Case # and Size)??