Can you attach a sample file for us to 'play' with..

I am thinking you could incorporate autofilter then change each value to a common denominator (GB).. you could change the actual value or use a helper column..