I am using this formula to

to get the smallest value in the range. Like 1st to 5th Smallest value.=SMALL(IF(orders_ref=$C$1,orders_po,""),1)

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