+ Reply to Thread
Results 1 to 3 of 3

A code that will determine the grading of a product and filter accordingly

  1. #1
    Registered User
    Join Date
    07-15-2014
    Location
    South africa
    MS-Off Ver
    MS Office for Mac
    Posts
    7

    A code that will determine the grading of a product and filter accordingly

    Hi,I am trying to determine an approach to follow in order to grade the product.Here is a detailed example

    Sheet1: This is a reference sheet used to grade the condition of the product based on their ages
    Eg,If product 1's age is 8 days then it is in 'Excellent condition'
    Excellent condition(days) Good Condition(days) Bad Condition (days) Expired(days)
    Product 1 1-10 11-20 20-25 26 or more
    Product 2 1-4 5-7 8-9 10 or more
    Product 3 1-6 7-10 11-12 13 or more
    Product 4 1-40 40-80 80-100 101 or more
    Product 5 1-35 36-45 45-55 56 or more



    Sheet 2: This is the data table that gives more details about the products available at the shop.
    Product Code Shelf life (days) Date of Manufacture Current date Age (days) Volume(kg)
    P101 Product 1 25 6/29/14 7/14/14 15 34
    P102 Product 2 9 6/30/14 7/14/14 14 55
    P103 Product 3 12 6/26/14 7/14/14 18 78
    P104 Product 4 100 5/13/14 7/14/14 62 12
    P105 Product 5 55 6/13/14 7/14/14 31 34
    P106 Product 3 12 7/01/14 7/14/14 13 45
    P107 Product 4 100 3/3/14 7/14/14 133 56
    P108 Product 5 55 6/12/14 7/14/14 32 12
    P109 Product 1 25 5/24/14 7/14/14 51 32
    P110 Product 2 9 7/12/14 7/14/14 2 39



    What is required: the user want to be able to filter the table on sheet 2 by the condition of the products.
    For example,if the user want to view all products in the shop that have expired,the following table must appear as results:

    Condition to view: Expired

    The spread sheet wil display only products that ahave expired
    Product Code Shelf life (days) Date of Manufacture Current date Age(days) Volume(kg)
    P103 Product 3 12 6/26/14 7/14/14 18 78
    P106 Product 3 12 07/01/14 7/14/14 13 45
    P107 Product 4 100 03/03/14 7/14/14 133 56
    P109 Product 1 25 5/24/14 7/14/14 51 32





    Please advise me on how i get excel filter the data in that manner.

    Thank you

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,828

    Re: A code that will determine the grading of a product and filter accordingly

    hi ,
    provide sample workbook with the same data , it will be easy for providing a fast & Better solution.

    Punnam

  3. #3
    Registered User
    Join Date
    07-15-2014
    Location
    South africa
    MS-Off Ver
    MS Office for Mac
    Posts
    7

    Re: A code that will determine the grading of a product and filter accordingly

    Hi,
    Please see attacjed for the uploads

    Thanks
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Link product image to product code
    By rogan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2013, 02:51 AM
  2. [SOLVED] 4 digit code for similar product, new product unique code
    By unclejemima in forum Excel General
    Replies: 47
    Last Post: 06-06-2013, 01:02 PM
  3. [SOLVED] Need Function that will find ordered product, and display the product code in a 2nd workbk
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 08:52 AM
  4. Determine number of batch based on product type
    By sc11 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-16-2012, 11:11 PM
  5. determine number of batches based on product type and job size
    By sc11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2012, 07:04 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1