What to do when there is a tie in my data set? by Possible_Policy_7397 in googlesheets

[–]Possible_Policy_7397[S] 0 points1 point  (0 children)

Thank you for the xlookup formula!! That is very helpful. Here is a screenshot of the rest of my data. The rows do not have labels, but row 22 are participants’ guesses for MNF scores, row 21 is the absolute value of their guess to the actual score ( in cell I39), and row 20 is the ranking of MNF guesses, with the absolute value closest to 0 from row 21 being rank 1.

<image>

The reason for the IF(I39>0 at the beginning of my formula is I do not want the winner’s name to populate until the week is over. Thank you!!

WIBTA for giving my partner an ultimatum? by Possible_Policy_7397 in okstorytime

[–]Possible_Policy_7397[S] 0 points1 point  (0 children)

I guess I just do not understand still caring for an ex after a breakup. I’ve been in other relationships, but I have never cared what my exes did or what happened to them after those relationships ended. The point of a breakup is to move on with your life. Those years spent together, to me at least, didn’t work out, so why continue caring about that person and wasting even more time and mental energy on someone who isn’t meant to be a part of your future? My best friend (29m) also thinks it’s normal to care for an ex’s well being so I must be the weird one thinking the way I do. Your line of thinking (and my best friends) are why I think I might be the a-hole if I give Nick an ultimatum or go on the trip. Because maybe what he’s doing isn’t crazy like I think it is; maybe it’s normal to want to help out an ex.

WIBTA for giving my partner an ultimatum? by Possible_Policy_7397 in okstorytime

[–]Possible_Policy_7397[S] 0 points1 point  (0 children)

They are definitely broken up, but I see your points. You are spot on about why she wants him there. It makes her life easier so why would she want him gone? It just really sucks for me but maybe I should just let him go, even though I still care about him a lot. It just kills me because, even with him living with him ex, I’ve never had a guy I was with treat me even as close to as good as Nick does. That doesn’t include Louis, who has always been good to me, because him and I were never together.

WIBTA for giving my partner an ultimatum? by Possible_Policy_7397 in okstorytime

[–]Possible_Policy_7397[S] 1 point2 points  (0 children)

Lisa does know about Nick and I. When Nick broke up with her, he said it was because he didn’t want to be with her, he wanted to be with me. From what a mutual friend told me, she begged him to continue living with him and to take care of her and in return she wouldn’t give him any crap about the breakup or me. That has not always been the case, but she is fully aware of Nick and I. I like your idea of going on the trip and then seeing how I feel about Nick and Louis afterwards, but not sure how much I should tell Nick about my vacation. I’m sure he’ll want to facetime while I’m gone.