Solved

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

Posted on 2011-03-09
7
165 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
  • 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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…

765 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