Create unique list based on date

Hi,

Welcome to the forum.

Please post a sample template of your workbook using "Go Advanced" option. You may choose to delete the confidential information in the file before upload, if any.

Thank you cbatrody!
Edited the post with sample attachment.

I need that list for more complex task but its the only thing I don`t know how to do

Hi,

Please use the following array formula in G2 and drag down. You need to confirm by pressing CTRL+SHIFT+ENTER (see the file attached).

=IFERROR(INDEX($A$2:$B$19,MATCH(0, COUNTIF($G$1:$G1,$B$2:$B$19)+($A$2:$A$19<$E$1), 0), COLUMN(B1)),"")

Originally Posted by cbatrody

Hi,

Please use the following array formula in G2 and drag down. You need to confirm by pressing CTRL+SHIFT+ENTER (see the file attached).

=IFERROR(INDEX($A$2:$B$19,MATCH(0, COUNTIF($G$1:$G1,$B$2:$B$19)+($A$2:$A$19<$E$1), 0), COLUMN(B1)),"")

Sir you are amazing!

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Just did.
Btw if I add another +($A$2:$A$19<$J$1) as second date i can filter results by period between 2 dates?

=IFERROR(INDEX($A$2:$B$19,MATCH(0, COUNTIF($G$1:$G1,$B$2:$B$19)+($A$2:$A$19<$E$1)+($A$2:$A$19>$J$1), 0), COLUMN(B1)),"")

J1 is the second date.

wow this is so powerful! It can be used with other criterias i guess. Amazing what can excel do in the right hands

Thank you!