The problem will be in the data, something isn't what it looks like.

Attach your sample workbook so we can look for ourselves at your two sheets.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic