Hi Logit


Thanks for the feedback. The formula you suggested didn't look quite like the formula I was using before. Plus it didn't give me the desired outcome. The formula I used was something like this:


=IF(AM3=AM2,B3=B2)


And it would group all the numbers as TRUE (if you manually entered TRUE in B1 or if you manually entered FALSE in B1 than all the numbers that were the same would say FALSE). Only when the new set of numbers appear does it switch to the opposite of whatever you used first. That way, when I wanted to shade the groupings I could use the TRUE and FALSE narrative to differentiate the groupings. I hope that didn't sound as bad as it did in my mind as I was typing.