Results 1 to 6 of 6

Extract non zero value data

Threaded View

paraxis Extract non zero value data 03-13-2013, 09:09 AM
Melvinrobb Re: Extract non zero value... 03-13-2013, 09:19 AM
benishiryo Re: Extract non zero value... 03-13-2013, 09:25 AM
Melvinrobb Re: Extract non zero value... 03-13-2013, 09:28 AM
paraxis Re: Extract non zero value... 03-13-2013, 09:41 AM
Melvinrobb Re: Extract non zero value... 03-13-2013, 09:42 AM
  1. 03-13-2013, 09:09 AM #1
    paraxis is offline
    Registered User
    Join Date
    09-11-2008
    Location
    malta
    Posts
    34

    Extract non zero value data

    Hi All,
    I have a worksheet which contains a very long list of part numbers with various columns for models which use the parts.

    I would like that when I enter a model name in a cell, excel will extract a list of product codes which are used in that particular model. Is there a way to solve this problem without any VBA. I have tried with sumif and sumproduct but I am still getting the zero value cells.

    To make it simple I have attached a sample copy Xl workbook.
    I use Excel 2003.

    Thanks guys
    paraxis
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1