Sorry guys, I wasn't sure if I posted it in the correct thread. I'm kinda new at this. I did get the following formula to work though: =SMALL(D29:T29,COUNTIF($D$29:$T$29,0)+1). I tried the one you suggested but since I have merged cells, it won't allow an array formula. Now I have a different problem. I'm not quite sure how to explain it so I'll try to put together an illustration and put it in my next reply. Hope someone can help with it. I'm not sure if it can be accomplished. I appreciate your help so far though.