Hi,
Am Mon, 23 Dec 2013 02:41:10 -0800 (PST) schrieb (e-mail address removed):
Have a column of 3 digit numbers.
Is there a way I can sort them to
get all the numbers with a common 3rd
digit?
your numbers in column A with headers.
Make a helper column with formula:
=--RIGHT(A2,1)
Then sort in order of helper column and then column A
If you want to filter your numbers for a special last digit e.g. 3 then
select your values => Coditional Formatting => Use formula to.....=>
=--RIGHT(A2,1)=3 and choose a format. Then filter for this color.
Regards
Claus B.
