I am attempting to find thousandths and ten-thousandth values by filtering large files. Let's say I want to find all cells within a column that contain a thousandth or ten thousandth spot. I have tried using techniques such as a custom filter with the line *.??1 or *.???1 to filter to cells that need special, arbitrary rounding. Unfortunately due to the nature of what I'm doing, I can't just use the round function because I will be pennies off, which prevents the file from uploading to the general ledger. Any ideas on how to make the filter function find only cells that contain thousandth and ten thousandth characters in the decimal spot? Any help would be appreciated!
Bookmarks