+ Reply to Thread
Results 1 to 5 of 5

Get Date based on Matching criteria

  1. #1
    Forum Contributor
    Join Date
    01-08-2012
    Location
    Saudi Arabia, Dammam
    MS-Off Ver
    MS Office LTSC Professional Plus 2021
    Posts
    113

    Get Date based on Matching criteria

    Hi,
    I have a excel file in which i'm trying to get the date based on matching criteria, actually i have more than 24000 rows of data for which i have to get the date from another sheet.

    I couldn't figure out a VBA solution so decided to work on formulas.

    The formula solution worked well when the number of matching rows from the data sheet and report sheet are same but however when the lines are fewer in data sheet my idea didn't worked.

    Sorry i couldn't explain well, believe the attached image and the sample excel might brief you more.

    I too agree that formula based solution is not faster for this huge amount of data but still no other options i could think.

    your support is much appreciated, thanks.

    Image.jpg
    Attached Files Attached Files
    Last edited by muralidaran; 09-16-2020 at 01:21 AM.
    Thanks & Regards
    Muralidaran.

  2. #2
    Forum Contributor
    Join Date
    01-08-2012
    Location
    Saudi Arabia, Dammam
    MS-Off Ver
    MS Office LTSC Professional Plus 2021
    Posts
    113

    Re: Get Date based on Matching criteria

    Surprising!!! not even a single response, I believe i didn't explained it properly to get a solution on this.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Get Date based on Matching criteria

    Not suprrising to me at least! You forgot to mention that date must repeat with every single qty.
    For instant: Qty = 4, expect 4 rows for each 1 qty.
    I am working with this and get back soon.
    Quang PT

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Get Date based on Matching criteria

    I suggess non helper solution. See attachment.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    01-08-2012
    Location
    Saudi Arabia, Dammam
    MS-Off Ver
    MS Office LTSC Professional Plus 2021
    Posts
    113

    Re: Get Date based on Matching criteria

    Thanks, it worked well.

+ 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. VBA Macro Dividing Values Based upon Matching Criteria and Description Criteria
    By pvsvprasad in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-18-2016, 12:39 PM
  2. Return latest date based on matching criteria
    By senthilvenkatesh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2014, 02:49 AM
  3. Add date criteria matching order date and sales date
    By Luther.King in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-25-2014, 10:09 AM
  4. Sumif Based on matching date criteria
    By krunk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-18-2013, 11:19 AM
  5. [SOLVED] SUMIF only if matching a date criteria
    By Adsup01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2012, 11:14 PM
  6. [SOLVED] Find first date matching criteria
    By NapB9 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-07-2012, 09:04 PM
  7. Matching data using date criteria...
    By JoeZ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2005, 09:50 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