Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do i filter a spreadsheet to return certain rows?

Posted on 2014-11-13
6
Medium Priority
?
116 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
6 Comments
 
LVL 22

Assisted Solution

by:Flyster
Flyster earned 400 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:Michael Fowler
Michael Fowler earned 400 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 27

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 400 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 81

Accepted Solution

by:
byundt earned 400 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 31

Assisted Solution

by:gowflow
gowflow earned 400 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

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!

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

972 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