Solved

filter options in excel 2013 or 2016

Posted on 2016-10-15
3
45 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
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

790 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