Dear Experts,
I have a some data as shown below
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
I want to look for part 123-456 and if any of the part among the many listed is active, I want to display the part 123-456 as 'active' in a cell with code smallest of all in another cell else Obsolete with code 6.
I have a some data as shown below
Part | Manufacturer | Status | Code |
123-456 | AA | Obsolete | 6 |
123-456 | BB | Active | 3 |
123-456 | CC | Active | 2 |
123-456 | DD | Active | 3 |
123-456 | AA | Active | 3 |
123-456 | BB | Active | 3 |
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
I want to look for part 123-456 and if any of the part among the many listed is active, I want to display the part 123-456 as 'active' in a cell with code smallest of all in another cell else Obsolete with code 6.