Sort Question

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
 
C

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top