Solved

I NEED TO FILTER & LIST THE DATA WHERE THE ITEM DESCRIPTION IS BLANK

Posted on 2011-03-09
7
167 Views
Last Modified: 2012-06-27
I have an Excel Sheet1 where the columns consist of

Item Number      Item Description   Product line       Product Code    Quantity
AAA1                VALVE                ASSEMBLY             05                   2000
BBB2                                             ASSEMBLY             10                       20
CCC3                  BEARING            INDUSTRIAL             12                    200
DDD4                                             INDUSTRIAL              02                  645
EEE5                   WASHER            ASSEMBLY               08                     36

I need to get a list of the Items where the Item Description is blank and copy the Item Number and all the details to Sheet2

Item Number      Item Description   Product line       Product Code    Quantity
BBB2                                             ASSEMBLY             10                       20
DDD4                                             INDUSTRIAL              02                  645

thanks
0
Comment
Question by:chaverly
[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
  • 2
  • 2
7 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 35085400
Just use the Data-Filter feature and then select on the Item Description the blanks.

jppinto
0
 
LVL 33

Expert Comment

by:jppinto
ID: 35085433
Select the range where you have your data, then go to the Data tab, on the Sort&Filter group click on the Filter button. Then go to your Item Descrpition and click on the down arrow to open the filter menu. Just check the "blanks" and copy and paste your data.

I've attached a simple example.

jppinto
AutoFilter.xlsx
0
 

Author Comment

by:chaverly
ID: 35085554
I have 38, 946 items.  I have to be able to automate this or write a formula.  I am not an Excel expert.  Also, I'm using Office 2007 with ribbons.
0
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!

 
LVL 33

Expert Comment

by:jppinto
ID: 35085579
This is the simplest way you can use to do this without formulas or macros!
0
 
LVL 17

Accepted Solution

by:
gtgloner earned 500 total points
ID: 35085754
Try this file:
Book1.xls
0
 

Author Closing Comment

by:chaverly
ID: 35086276
Worked like a champ.  It takes awhile to run, but is more than worth it.  I can't imagine doing this manually.
0
 
LVL 17

Expert Comment

by:gtgloner
ID: 35086493
Thanks for the grade, hope to be helpful to you again in the future.

Glenn
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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

729 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