Hello friends,
I am using this formula to
to get the smallest value in the range. Like 1st to 5th Smallest value.
Here is a sample data
<tbody>
</tbody>
I am getting the result for Ref # 123 or 127... But the formula is not giving the result for
Ref # 130..... May be coz the Numbers in Column A against Ref # 130 contains some
alphabets with them...
Pls if anyone can let me know how to solve this issue???
Regards,
Humayun
I am using this formula to
=SMALL(IF(orders_ref=$C$1,orders_po,""),1)
to get the smallest value in the range. Like 1st to 5th Smallest value.
Here is a sample data
95822 | 123 |
95825 | 123 |
95828 | 123 |
95830 | 123 |
95831 | 123 |
40041541 | 127 |
40043227 | 127 |
40042045 | 129 |
12943122 A | 130 |
12943122 B | 130 |
<tbody>
</tbody>
I am getting the result for Ref # 123 or 127... But the formula is not giving the result for
Ref # 130..... May be coz the Numbers in Column A against Ref # 130 contains some
alphabets with them...
Pls if anyone can let me know how to solve this issue???
Regards,
Humayun