Why don't you post a sample worksheet with your expected result, rather then let everyone second guess what you require!