These are a list of popular women in TV and movies who were friend zoned. Some of these are debatable
Tara: True Blood, and to make matters worse she died. She got to hear all about Jason stackhouse's sexcapades and he always picked the wrong women.
Eowyn: Lord of the Rings. Her husband Faramir looks better than Aragorn though
Hermoine Granger: Harry Potter, it sure took a lot of books for Ron to kiss her
Tinker Bell: Peter Pan
Scarlett O' Hara
Carrie: Carrie by Stephen King