Hello,
Not too sure if this is appropriate here .. but
I am trying to sort a spread sheet on a certain columb.
The columb in questing contains a very large number, 15 digits.
I do not want to sort the sheet on the actual value of this number but rather on the value of the last three digits of the number.
In other words I want to sort the sheet using the last three digits of the columb containing the very large number.
Cannot figure it out. Using a fairly old version of excell.
If I could AND the number with 0000000000000111 (12 zeroes and three ones) I would strip away the digits I do not want (create a new columb and
sort on the new columb but I am unable to do this AND.
Cheers,
Yob |