Seems Excel doesn't like sorting multiple decimal place lists. I tried to write a customer filter, but wild cards don't seem to work. Writing a full filter for 1, 1.1, 1.1.1, 1.1.2, etc. would be an ...

I'm working with a VERY large excel spreadsheet and I'm trying to apply a bunch of formulas to some sorted data. The way the data is sorted normally, I can't easily apply a formula that will work for ...