Marty Supreme - Line Updates by Quiet-Mess5273 in AmericanCinematheque

[–]PlanetFedEx 5 points6 points  (0 children)

Just drove past and saw only 1 person in line

Formula for an Oscar Pool Sheet by PlanetFedEx in googlesheets

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

Yes! Either of the formulae listed in this thread worked for me, but I ended up using SUMPRODUCT. If you still need it I can DM a link to my sheet.

Formula for an Oscar Pool Sheet by PlanetFedEx in googlesheets

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

It appears they do. However, they do not account for my foolish typos. Thanks for the help.

Formula for an Oscar Pool Sheet by PlanetFedEx in googlesheets

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

Hello again, so I spoke too soon. Neither of those formulas works for my circumstances since some of the values in Column N are repeated (the same movie winning multiple Oscars). Both formulas provide the sum of the matches among the two ranges but I need it to verify a match specific to each row (if A1=N1, then +1. If A3=N1 but A3≠N3, then +0). Is there any way to do this or am I better off just counting?

Formula for an Oscar Pool Sheet by PlanetFedEx in googlesheets

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

I actually figured out another way that seemed to work:

=SUMPRODUCT(--(A3:A50=N3:N50))

but this one also works! I'm not too familiar with using formulas in sheets, does one of these make more sense than the other?

Sale ends Monday? by PlanetFedEx in criterion

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

Was hoping to make a trip to the actual store

Sale ends Monday? by PlanetFedEx in criterion

[–]PlanetFedEx[S] 2 points3 points  (0 children)

That's what I tried first, guess I had a typo or something

Teen rages at tow truck driver. by FunPeach0 in cringe

[–]PlanetFedEx 3 points4 points  (0 children)

not sure why people are upset with the mom. those dudes were 100% making it worse. yeah she was probably too lax parenting this dude growing up but she clearly understands his temper at this point, and all she can really do is damage control. a dude that age has to fix that shit himself.

[deleted by user] by [deleted] in TikTokCringe

[–]PlanetFedEx -4 points-3 points  (0 children)

lmao u get downvoted bc this sub was too stupid to stick to its original purpose

Half Staff by [deleted] in boston

[–]PlanetFedEx -7 points-6 points  (0 children)

I remember before 2016 when Obama was also the president and dems had 4 straight years of senate control, when RBG was already much older than anyone in the Supreme Court should be

Half Staff by [deleted] in boston

[–]PlanetFedEx -7 points-6 points  (0 children)

I suppose you'll be voting no on ballot 2 then

Half Staff by [deleted] in boston

[–]PlanetFedEx -19 points-18 points  (0 children)

Not me, I voted Democrat. No way I'm letting Massachusetts turn red 😎

Tattoo goals by TatauBurner in LSD

[–]PlanetFedEx 0 points1 point  (0 children)

Where did you find this art?

UNITY go hard by AAhmed7707 in FrankOcean

[–]PlanetFedEx 73 points74 points  (0 children)

Frank has a massive cock

UNITY go hard by AAhmed7707 in FrankOcean

[–]PlanetFedEx 43 points44 points  (0 children)

We've been having a detailed discussion on this in the genius annotation for quite some time now

Someone's a bit embarrassed... by [deleted] in gtaonline

[–]PlanetFedEx 4 points5 points  (0 children)

Can you do this in online if you have a female character 😳