Closed Thread
Results 1 to 3 of 3

Find value in column with earliest date in another column and the date is after today

  1. #1
    Registered User
    Join Date
    02-28-2018
    Location
    Aalborg, Denmark
    MS-Off Ver
    2007
    Posts
    7

    Question Find value in column with earliest date in another column and the date is after today

    I have a Excel file (giftcard) i need to return "earliest valid Giftcard nr." in column M.
    Column A= "Giftcard no"
    Column B= "Customer no"
    Column D= "Giftcard valid to date"

    A customer can have more then one (ex. customer no 0000208) "Giftcard".
    The "Giftcard" is valid if "Valid to"(Column D) is today or later

    "Earliest valid giftcard no" need to be shown on all rows. If a "Giftcard" is before today or there is a earlier valid "Giftcard" it need to be shown in column M. So all giftcard with same "Customer no" has same "Ealiest valid giftcard no".
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,309

    Re: Find value in column with earliest date in another column and the date is after today

    Could you please manually add your expected results and post the workbook again?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,309

    Re: Find value in column with earliest date in another column and the date is after today

    Please read the forum rules. You are allowed only one thread per issue. Continue in the original thread, where you are already getting help: https://www.excelforum.com/excel-for...-criteria.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find earliest date before today based on criteria
    By DanNielsen in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2018, 10:47 AM
  2. [SOLVED] Find value in a column at today month date
    By maxnpeps in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 09-01-2017, 11:18 AM
  3. Find the earliest date&time for a value from different column
    By Neyme in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2015, 10:10 PM
  4. [SOLVED] Find the value in a column next to the last date before today
    By mike.abz in forum Excel General
    Replies: 10
    Last Post: 03-05-2015, 09:59 AM
  5. Find the earliest date in a column where blank cells and N/A can occur
    By rdillong in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-30-2012, 06:21 AM
  6. Find the earliest date in the column
    By pphg in forum Excel General
    Replies: 4
    Last Post: 08-13-2012, 09:24 AM
  7. Replies: 3
    Last Post: 12-01-2011, 05:27 PM

Tags for this Thread

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