Hello,
I am looking for excel function to return less value in Duplicate names given below. Ex. if we take AAA has three duplicates with different values however, I need less value out of all the duplicates and should be return the less value as output, in this case value 100.00 should get as output in column 'C'
<tbody>
</tbody>
Output data:
Names Values Result
AAA 100.00 100
BBB 200.00 na
CCC 300.00 300
DDD 100.00 na
AAA 240.00 100
CCC 350.00 300
FFF 110.00 100
AAA 250.00 100
FFF 100.00 100
I am looking for excel function to return less value in Duplicate names given below. Ex. if we take AAA has three duplicates with different values however, I need less value out of all the duplicates and should be return the less value as output, in this case value 100.00 should get as output in column 'C'
Input data: Names | Values |
AAA | 100.00 |
BBB | 200.00 |
CCC | 300.00 |
DDD | 100.00 |
AAA | 240.00 |
CCC | 350.00 |
FFF | 110.00 |
AAA | 250.00 |
FFF | 100.00 |
<tbody>
</tbody>
Output data:
Names Values Result
AAA 100.00 100
BBB 200.00 na
CCC 300.00 300
DDD 100.00 na
AAA 240.00 100
CCC 350.00 300
FFF 110.00 100
AAA 250.00 100
FFF 100.00 100