Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-03-09
7
Medium Priority
?
170 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
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 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 2000 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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

604 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