+ Reply to Thread
Results 1 to 2 of 2

Display value based on oldest date and other criteria.

  1. #1
    Registered User
    Join Date
    12-30-2008
    Location
    Riverside, CA
    MS-Off Ver
    Excel 2007
    Posts
    15

    Question Display value based on oldest date and other criteria.

    Check out the screenshot.

    I have no idea where to begin with this one. Let me explain what I need.

    I need cell E10 to display the SR number of the row based on the following criteria:
    1: The oldest date in the "To Repair" column (E)
    2: Days in repair (G) is NOT Blank (or >=0)
    3: Part Received (M) = "YES"

    I am still pretty noobish when it comes to VBA, but I think I have come pretty far with the help of you guys.

    Thanks.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    Re: Display value based on oldest date and other criteria.

    Hi
    try the macro in the attached file (I have not tested it)
    Ravi
    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)

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