"in Friends" vs. "from Friends"

I’ve gone through [Adverbs: types] and (https://dictionary.cambridge.org/us/grammar/british-grammar/adverbs-types)
ref2 on Cambridge Dictionary and I guess I understand the rules there.

Consider the following three sentences.

1. In Friends, Rachel Green is played by Jennifer Aniston.
2. Rachel Green in Friends is played by Jennifer Aniston.
3. Rachel Green from Friends is played by Jennifer Aniston.

According to those rules, sentence 1 is less common than sentence 2, though sentence 1 is not rare. All three of them are clear and natural, is my understanding correct?

Similarly, which one should I use in this sentence, "in" or "from"?

Ross from Friends and Sheldon from The Big Bang Theory have some characteristics in common.