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.

Hello jewelsharma

Thanks for the notification.

Sorry for the errors i did, Now i corrected the input cell location and removed the dates and dates before the input date. Please refer the updated file.

thanks again.

Try

AL5=IFERROR(INDEX(I$4:I$24,SMALL(IF(($AG$4:$AG$24>=$AJ$5)*($AG$4:$AG$24<>"--")*(FREQUENCY(IF($AG$4:$AG$24>=$AJ$5,MATCH(I$4:$I$24,$I$4:$I$24,0)),ROW($AG$4:$AG$23)-ROW($AG$4)+1)),ROW($AG$4:$AG$24)-ROW($AG$4)+1),ROWS($A$1:A1))),"") with Control+Shift+Enter

Am5=IFERROR(INDEX(AG4:AG24,MATCH(AL5,I4:I24,0)),"") and drag down..

Hello Ankur Sgukla

Thanks for your formula, it is working fine for the fixed datas but my dates will be keep on adding and everytime i need to change the Last Row from 24 to XXXXX. Is there any way to make the formula working from 24 rows to 1000 Rows.

thanks again for your formula.

tRY

=IFERROR(INDEX(I$4:I$1000,SMALL(IF(($AG$4:$AG$1000>=$AJ$5)*($AG$4:$AG$1000<>"--")*(FREQUENCY(IF($AG$4:$AG$1000>=$AJ$5,MATCH(I$4:$I$1000,$I$4:$I$1000,0)),ROW($AG$4:$AG$999)-ROW($AG$4)+1)),ROW($AG$4:$AG$1000)-ROW($AG$4)+1),ROWS($A$1:A1))),"")

Hello Ankur

Thank you.

Yes, exactly what i want.

Thanks again.

Glad to help you buddy