Solved

filter options in excel 2013 or 2016

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

763 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