Exellent piece!! I like your aproach to data entry errors. Most difficult one to handle in my opinion. One trick i usually use for Missing data is to pivot , replace blanks with nulls or zeros or blanks and then unpivot...The way i can unmask the missing data ... Thanks..JM