Results 1 to 8 of 8

Extract datas and date after given date by eliminating duplicates

Threaded View

  1. 07-05-2016, 02:13 AM #1
    Sekars
    Sekars is offline
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    671

    Extract datas and date after given date by eliminating duplicates

    Hello Friends

    Please find the attached file (Extract datas and date after given date by eliminating duplicates.xlsx).

    I need to lookup in the Column AG Cells for the input Date AJ5.

    If the dates are after input date then lookup and plot the values in Column I except TBC.

    Dates and datas may be duplicated but for the same datas two different dates will not come. If Dates and datas duplicated then plot as once.

    thanks in advance.
    Attached Files Attached Files
    Last edited by Sekars; 07-07-2016 at 01:43 AM.
    Sekar
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Plotting the datas from given date in 4 sheets by eliminating duplicates
    By Sekars in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2016, 07:50 AM
  2. How to extract only the Start Date (earliest) and finish date (latest) of a unique product
    By egrospe17 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2016, 07:26 PM
  3. how to extract latest date to a paticular date from diffrent date list
    By rudraalok in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2014, 05:18 AM
  4. [SOLVED] Extract date from cell and replace value with date then delete empty rows
    By jjislas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2013, 11:52 AM
  5. Eliminating duplicates within certain date ranges
    By SymphonyTomorrow in forum Excel General
    Replies: 1
    Last Post: 11-19-2011, 06:31 AM
  6. Eliminating date values
    By VinceValdez12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-10-2007, 05:18 PM
  7. [SOLVED] Eliminating Negative Values from Date Subtractions
    By Mhz in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1