Hello,
I have a table which holds some important information, the columns I need to work with are:
Parent
Size
Units
<tbody>
</tbody>
I need a macro that will search in Parent and Size and pull the lowest value found in units. Notice Size has multiple "sizes" concatenated by a comma, I need to be able to individually search each size until a match is found there as well.
The data by which I will do a search goes like this:
ParentC,
SizeC (one size only)
UnitsC (the lowest value in Units)
<tbody>
</tbody>
There are some UDF that gives the MINIF and Excel array formula can do the same, but I cant find a way to individually search each size in the first column and find a match.
I am extremely confused in this, if anyone has any idea as to how to deal with this please feel free to share.
I have a table which holds some important information, the columns I need to work with are:
Parent
Size
Units
Parent | Size | Units |
HOLLOWCO | AB, AS2, AR3, AT3 | 8717 |
HOLLOWCO | AS2, AR3 | 875 |
HOLLOWCO | AT3 | 8784 |
NUDIS | AT3 | 45 |
<tbody>
</tbody>
I need a macro that will search in Parent and Size and pull the lowest value found in units. Notice Size has multiple "sizes" concatenated by a comma, I need to be able to individually search each size until a match is found there as well.
The data by which I will do a search goes like this:
ParentC,
SizeC (one size only)
UnitsC (the lowest value in Units)
ParentC | SizeC | UnitsC |
HOLLOWCO | AT3 | 8717 |
HOLLOWCO | AS2 | 875 |
HOLLOWCO | AR3 | 875 |
NUDIS | AT3 | 45 |
<tbody>
</tbody>
There are some UDF that gives the MINIF and Excel array formula can do the same, but I cant find a way to individually search each size in the first column and find a match.
I am extremely confused in this, if anyone has any idea as to how to deal with this please feel free to share.