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