Quote Originally Posted by MarvinP View Post
Hey Statz,

I'd bet you have a space or two (pun intended) in your "-2" data. If the "-2" is text and had a space before, after or in-between the letters it would show up multiple times in your Slicer tool.

Sort your data by that "Gap" column and look at the top and bottom to see which are different but look the same.
Wow. That worked! Although the confusing part now is how did it get like that?

One thing I did to make the file "smaller" is once I got the "GAP" data over from V LOOK UP I copied & pasted special to remove the formulas.

So I really am not sure why there would be two different types of "-2" especially when it didnt' show up twice in the filter.

Any ideas? Thank you so much for the quick response. I can manually fix it now but this is an on going project so I'd like to avoid it from happening again.