filter a list of numbers
filter on =mod(a1,10)=0
"Ole" wrote:
I have a list of numbers (20000 to 27583)
I only want to see the info for the rows where the number ends with 0 (eg.
20000, 20010, 20020 etc. basically every 10th row)
When I custom filter for "ends with" 0, my whole list goes away.
|