S
SRL
I'm trying to filter a list of values ranging from -500,000 to 500,00
to show just those rows with values between -5 and 5. Hence, I'v
asked "Custom Autofilter" to show "greater than or equal to" -4.97 (th
last value above -5 which is not actually in the list) and "less tha
or equal to" 4.31 (the last value below 5).
When I then ran the filter, I noticed some huge (positive) values ha
been returned. I then went back to the Custom Autofilter and the valu
4.31 next to the "less than or equal to" box had changed to 11414!
have absolutely no idea why this happened. I've reset the criteri
many times now and every time the same thing has happened and alway
the same number 11414. I've even tried another spreadsheet with th
same list of numbers - but again the exact same problem.
Does anyone have any idea what is happening here? This is driving m
nuts!
Many thanks in advance!
SR
to show just those rows with values between -5 and 5. Hence, I'v
asked "Custom Autofilter" to show "greater than or equal to" -4.97 (th
last value above -5 which is not actually in the list) and "less tha
or equal to" 4.31 (the last value below 5).
When I then ran the filter, I noticed some huge (positive) values ha
been returned. I then went back to the Custom Autofilter and the valu
4.31 next to the "less than or equal to" box had changed to 11414!
have absolutely no idea why this happened. I've reset the criteri
many times now and every time the same thing has happened and alway
the same number 11414. I've even tried another spreadsheet with th
same list of numbers - but again the exact same problem.
Does anyone have any idea what is happening here? This is driving m
nuts!
Many thanks in advance!
SR