In the example, column C is used to track the fast food consumed. The goal is to set up cell H2 to find the 1st fast food consumed between the dates in cell F1 and F2. H3 will be used to find the 2nd fast food consumed between the dates. The closest formula I found for H2 is:
{=IFERROR(INDEX($A$2:$A$17,SMALL(IF($C$2:$C$17=$C$1,ROW($C$2:$C$17)-1,””),COLUMNS($H$1:H1))),””)}
However, that one brings up the 1st fast food appearance of the entire spreadsheet (Pizza) and does not provide a way to restrict the dates.
Is there a way to get the name of the 1st or nth fast food consumed between specified dates?
