Hi Kevin,

Based on your sample, put this in the 2nd sheet in B1 and copy down...

=IFERROR(INDEX(Sheet1!$B$1:$B$7,LARGE(IF(Sheet1!$A $1:$A$7=A1,ROW(Sheet1!$A$1:$A$7)-ROW(Sheet1!$A$1)+1),1)),"")

IMPORTANT

• This is an array formula
• Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
• If entered correctly, the formula will be enclosed in {brackets}
• Do not enter the {brackets} manually