I figured out what I was doing wrong. I needed to adjust range. I orginally had a range that had data with "0" in it. Once I change the range to the cells with info in it, the correct ranking appeared. Thanks for your time and help! You guys still Rock!