Does this help:
=COUNTA($B$2:$B$20)-MAX(IF($B$2:$B$20=E2,ROW($B$1:$B$19)))
(confirm CTRL+SHIFT+ENTER)