Solved

How do i filter a spreadsheet to return certain rows?

Posted on 2014-11-13
6
111 Views
Last Modified: 2014-11-15
hi,
I have an XL 10 worksheet.  It has many columns.  how can I ask it to show only those rows which have values in a certain column.

lets say I have columns a,b,c,d....    how can I ask it to show rows only with values in column D ?
0
Comment
Question by:intelogent
[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
6 Comments
 
LVL 22

Assisted Solution

by:Flyster
Flyster earned 100 total points
ID: 40441640
Select the column with the data, go to the Home tab -Editing and select Filter. You can choose which values you want to appear.

Flyster
0
 
LVL 23

Assisted Solution

by:Michael74
Michael74 earned 100 total points
ID: 40441703
Have a look at this tutorial on advanced filtering for more details

http://www.excel-easy.com/examples/advanced-filter.html
0
 
LVL 26

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 100 total points
ID: 40442114
put a filter in column D and then remove blanks and then you will see all rows where the column D has value.
0
Industry Leaders: 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!

 
LVL 81

Accepted Solution

by:
byundt earned 100 total points
ID: 40444105
I suggest using the AutoFilter rather than Advanced Filter. Most people find AutoFilter easier to use.

To display only rows with values in column D:

1. Select the cells (including header labels) to be filtered
2. On the Data menu, click the Filter menu item
3. Click the arrow to the right of cell D1, and choose Text Filters
4. In the resulting dialog, choose "Contains..."
5. In the next dialog, Enter an asterisk * in the field to the right of  "Countains". This stands for any and all text values. Blank cells, plus numeric values (such as the date in cell D3), will be hidden.
5. Click OK

To display all items, click the Data...Filter menu item once again.
FilterColumnDforTextQ28561710.xlsx
0
 
LVL 30

Assisted Solution

by:gowflow
gowflow earned 100 total points
ID: 40444196
how can I ask it to show rows only with values in column D ?

Simply make sure that filtering is activated in the said worksheet by selecting the header row and clicking on Data Tab then click on Filter it will bring the Arrows on the header on all columns that have a header.

Then
In Col D click on the Arrow and it will display all data that exist in this column

If you need it to display all rows that have 'something' in this column ie anything except a blank cell then you untick the last option Blank and press ok it will filter and get you only the rows that have data in col D

Note as you used the word 'Value' which has a special meaning which I am not sure if this is what you meant then the answer of Byundt already proposed above is the appropriate one.

Your choice.
gowflow
0
 

Author Closing Comment

by:intelogent
ID: 40444341
Friends

i would like to thank you for your collective effort in educating  me
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

752 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