Solved

filter options in excel 2013 or 2016

Posted on 2016-10-15
3
48 Views
Last Modified: 2016-11-03
i have both versions of excel so either is fine.

I don't have the option to filter a column with "contains text"   i used to have this option....
now its just filter by color or numeric comparisons...

I need to filter all cells in a column having a "."   example    100.00        a decimal point.
how can i do this....
thanks a ton
0
Comment
Question by:jamesmetcalf74
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 250 total points
ID: 41845117
If the column indeed contains text values, then you should see an option visible titled "Text Filters" when you click the drop arrow.  

If your column only contains numbers, you will not see that option, only "Number Filters"

Now, if you type a "." in the search box (above displayed filter values and below the options section), that will filter to all results that have a decimal point in their values.

This example is in Excel 2010, but is applicable to 2013 and 2016
EE-FilterDecimal.png
-Glenn
0
 
LVL 27

Assisted Solution

by:skullnobrains
skullnobrains earned 250 total points
ID: 41845170
if your column is numeric, you probably can't

you can use a separate column to do it directly
- add a column next to yours (let's say it's column R for the sake of simplicity)
- write =R1-ROUND(R1,1) in S1 cell ( the first of your new column )
- extend S1 downwards so the formula is reproduced
- filter non-zero values

tons of similar ways around. you can even produce a recap on a different page using SEARCHV
0
 

Author Comment

by:jamesmetcalf74
ID: 41850162
sorry for the late communication.
you got me fixed man.
Thank you
0

Featured Post

Increase your protection from Zero Day threats!

Running two Antivirus' is never a good idea.
Taking advantage of Multiple Security layers on the other hand can often save your hide.
See which top notch security software brands have been proven to happily coexist together.
Reduce your chances of becoming a statistic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question