▲ 2 r/excel

I've been trying to figure this out for a while. I've tried hundreds of different functions but not getting any results that work. Does anybody know if a function is even possible?

Let's say I have the following fields in A1-A5.

Red=1

Red=2

Orange=8

Blue=5

Red=2

I need a way to calculate it to return like

5

8

5

reddit.com
u/WormDemolisher — 2 months ago

So my (19m) friend (19m) is upset that whenever his boyfriend (19m) is around ill instantly decline to do anything while out in public. He seems to think im into him, and jealous that hes dating somebody else. This is 100% not the case, we have been friends since we were 10. We've never dated, nor have I shown any interest of being into him. Also im not gay.

The issue is his boyfriends appearance. His boyfriend who is 19 is a super nice guy, and i have nothing personal against him. The reason I dont like being around them in public is the way he looks. His boyfriend has something medically wrong with him. He looks like a elementary school student and no older than 10. He is under 5 foot tall, and literally looks no older than 10. The first few times I met his boyfriend I thought it was a relative he was baby sitting. Anytime we are out in public they get stared at, and the police have even been called a few times on them. Also personally I find it a little bit creepy as well. I'm really not sure how to explain to him without offending him, or his boyfriend. I feel bad for discriminating against somebody for something medical, but it's really just too much for me to handle.

reddit.com
u/WormDemolisher — 2 months ago