Sort Question

  • Thread starter Thread starter tigersfinish
  • Start date Start date
T

tigersfinish

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
 
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?
Click to expand...

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.
 
Back
Top