Results 1 to 6 of 6

Return a Yes or No on growing list depending on specific parameters.

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    29

    Return a Yes or No on growing list depending on specific parameters.

    Hello!

    I have a growing list with dates and serial numbers. I need a column to automatically return a yes or a no if the same serial number has shown up on the list within the last 30 business days from the previous call.

    I know I'll probably need a Match and an IF statement, but I am unsure where to go from there as this list will continue to grow through the month.

    Example is attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-09-2016, 03:27 PM
  2. Return if an item is late based on start and end times and specific parameters
    By d2thep in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 04-10-2014, 10:25 AM
  3. Update specific sheet based on drop-down list parameters
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2013, 07:42 AM
  4. Return Data depending on dropdown list
    By GenericPat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2012, 04:21 PM
  5. [SOLVED] Return a specific column of data depending on the content of a cell
    By Herr Rommel in forum Excel General
    Replies: 2
    Last Post: 05-07-2012, 02:21 PM
  6. Return specific numbers from a chart depending on drop down box selection
    By JasonTV in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2011, 08:22 AM
  7. Return a value within specific parameters
    By ezdizzy in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-08-2009, 06:39 PM

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