+ Reply to Thread
Results 1 to 2 of 2

Nearest Date for Multiple Criteria

  1. 06-26-2016, 12:33 AM #1
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Nearest Date for Multiple Criteria

    Dear All,
    I have two sales data in which I want to compare sales price in Data 1 with nearest date in Data 2 with same product.. There may be more than one sales voucher with same product in Data 2, so I want to compare all entries in Data 1 for that particular date with Date 2.
    Attached Files Attached Files
    Last edited by mangesh.mehendale; 06-26-2016 at 01:17 AM.
    Don`t care, take care...

    Regards,
    Mangesh
    Reply With QuoteRegister To Reply
  2. 06-26-2016, 01:06 AM #2
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Nearest Date for Multiple Criteria

    masters please revert if any doubts...

    Thanks...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. To compare & find out the nearest date in the range with a common date
    By rkulasekaran in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2015, 08:08 AM
  2. Vlookup function, date selection issue (nearest date before and after certain date)
    By Vend1301 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-16-2015, 08:57 AM
  3. Finding Nearest date in a range based on critera date
    By skate1991 in forum Excel General
    Replies: 5
    Last Post: 07-22-2015, 02:10 PM
  4. [SOLVED] Find the Exact date, Nearest old and new date for the given input Letter) and date
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2015, 05:13 AM
  5. Index Match with Multiple Criteria One to Nearest Date
    By burningeagle in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-16-2014, 11:59 AM
  6. Compare and find nearest date with criteria
    By Dwexdwex in forum Excel General
    Replies: 4
    Last Post: 08-18-2013, 09:51 AM
  7. Find nearest available date that meets criteria
    By scottylad2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2013, 03:17 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1