+ Reply to Thread
Results 1 to 3 of 3

Plotting the datas from given date in 4 sheets by eliminating duplicates

  1. #1
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    672

    Plotting the datas from given date in 4 sheets by eliminating duplicates

    Hello Friends

    Please find the attached 2010 file (Plotting the datas from given date in 4 sheets by eliminating duplicates.xlsx)

    In all the four sheets XXX, YYYYY, XXXX2, YYYYYYYY3 Column I is data and Column AG is date
    In all the four sheets if the input date 01-Jan-16 in `Result' sheet Cell B2 is given.

    Dates may be duplicate within the sheet or in any of the 4 sheets or all of the 4 sheets (Example : 03-Jun-16 available in all 4 sheets).
    Datas may be duplicate in the same sheet but it will not duplicate in other sheets except texts. (Example :

    Now I want to plot the Dates per the given date in ascending order (Old to Latest or small to big) and eliminating the duplicate datas. Datas need to plot in `Result' sheet light yellow cells.

    Refer the `procedure' sheet to get the idea,

    thanks in advance.
    Sekar

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,956

    Re: Plotting the datas from given date in 4 sheets by eliminating duplicates

    I think a better option is look at how you arrive at, and organise your data, rather than have complex formulae to try and extract/sort the data.

  3. #3
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    672

    Re: Plotting the datas from given date in 4 sheets by eliminating duplicates

    Please refer the attached 2010 version excel file (Plotting the datas from given date in 4 sheets by eliminating duplicates-solution.xlsx)
    Refer the sheet `Result 2' with the help huge helper cells (Red in color) i acheived solution in Y2:Z23 by suing input in N2.

+ 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. Eliminating Duplicates
    By jb2235 in forum Excel General
    Replies: 1
    Last Post: 06-17-2015, 12:35 AM
  2. [SOLVED] Eliminating Space and plotting with transpose
    By thilag in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2015, 08:27 AM
  3. [SOLVED] Eliminating duplicates
    By thilag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-27-2014, 02:59 AM
  4. Eliminating Duplicates from Count
    By Janie in forum Excel General
    Replies: 3
    Last Post: 06-04-2012, 12:22 PM
  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 duplicates
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2009, 06:07 AM
  7. aggregating and then eliminating duplicates from a database
    By EDUcoordGR in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2009, 12:33 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