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.
Bookmarks