Hi,
Say my column called "numbers" and contains numbers - 1,2,3,4 and so forth.
I know that I can go to the top of the column and to write there criterions. So if for example I write >2 only 3 and 4 would appear in the filtered range.
But if my data look like this: 1a, 2b, 3c, 4d and so force, what criterion should I write in order to remain only with data contains, say, the letter a. Or in other words to remain only with 1a.
Thank you
Add a column to your table with a formula which tests for 1, or 2, or both like =isnumber(search(1,<cell>)) then filter on that
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Thank you Charlie.
unfortunately I did not explain my self properly.
Please take a look at the attached file.
How can I sort the column by size, when M represents millions, and B billions?
Thank you
to filter on millions use
*M
as the filter
Josie
if at first you don't succeed try doing it the way your wife told you to
Hoping that i understand well your goal..in B4 put this formula.
=RIGHT(A4,1)
Then use Custom Sorting by column B.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks