Create unique list based on date

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!