Thread
:
Sort Question
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch