I have an excel spreadsheet that was brutally slow when filtered (contained no formulas and all un-necessary formatting/rows/columns were removed)
I converted the file to .csv and it worked marvelously quickly once again and saved it back as .xlsx (still not sure why that worked, but I read it online, tried it, and had success).
Now when I filter for items I don't get expected results.
In this case I'm attempting to filter for anything containing "18.1"
I get all results that contain 18.1 delimited with another number or multiple numbers (18.1;15.2;15.6;etc..)
It will not return any results that only contain 18.1 (many exist in the spreadsheet).
Thoughts?
Bookmarks