Hi guys, would appreciate any help with this please.
Trying to return min and max for values for blank (?) columns below.
So here's the logic: Table 1
IF Type column="Bulk", then Vlookup Transponder column and match to Table 2 Transponder column and return min date
Note: Transponder value can have multiple Registration Times against it
<tbody>
</tbody>
<tbody>
</tbody>
Trying to return min and max for values for blank (?) columns below.
So here's the logic: Table 1
IF Type column="Bulk", then Vlookup Transponder column and match to Table 2 Transponder column and return min date
Note: Transponder value can have multiple Registration Times against it
TABLE 1 | ||||
Transponder | Type | Min Registration Time | Max Registration Time | |
<tbody> </tbody> | Bulk | ? | ? | |
<tbody> </tbody> | Clearance | ? | ? | |
<tbody> </tbody> | Bulk | ? | ? |
<tbody>
</tbody>
TABLE 2 | |
Transponder | Registration Time |
11001026934 | 28/05/2018 18:52 |
11001026934 | 28/05/2018 19:02 |
11001026934 | 28/05/2018 15:02 |
11001026937 | 25/05/2018 11:32 |
11001026937 | 25/05/2018 9:32 |
11001026937 | 25/05/2018 11:55 |
<tbody>
</tbody>