Sort Question
 

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? Thanks

Sort Question
 

Hi,

Am Mon, 23 Dec 2013 02:41:10 -0800 (PST) schrieb :

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2