Great Solution and simple! I found your solution after browsing a number of macros to do something similar and joined the forum. This is by far the simpler solution, easy to adjust for however many groups of rows you are working with and results immediately showed where my data needed cleanup also. Thanks Out of the Hat!