Hi Jaime,

Am Wed, 25 Apr 2018 07:55:37 -0700 (PDT) schrieb
:

=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH (TODAY(),$A$1:$Z$1,0))="e",ROW($1:$4)),ROW(A1)))," ")
Enter this formula with CTRL+Shift+Enter and then copy down.

Hello Claus, Thank you for your help, does it matter what cell would I put in this formula for it to work?

the date you are looking for in B10. The letter you are looking for in
B11. Then try:
=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH ($B$10,$A$1:$Z$1,0))=$B$11,ROW($1:$4)),ROW(A1)))," ")



Regards
Claus B.
--
Windows10
Office 2016