Hi, I have a table like this in sheet1
In sheet 2, I want to lookup for a particular Part Number and get the min of the value.
Something like this
Could you please help.
Regards
Soumen
Part Number | Years |
AAA | 1 |
AAA | 1 |
AAA | 2 |
BBB | 4 |
CCC | 3 |
BBB | 4 |
AAA | 3 |
BBB | 3 |
CCC | 6 |
In sheet 2, I want to lookup for a particular Part Number and get the min of the value.
Something like this
Part Number | Years |
AAA | 1 |
BBB | 3 |
CCC | 3 |
Could you please help.
Regards
Soumen