Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

filter options in excel 2013 or 2016

Posted on 2016-10-15
3
Medium Priority
?
50 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 1000 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 1000 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

730 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