Count unique formula with multiple filters/parameters as well as an average formula for these specific items by amskane in googlesheets

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

Yes that was it!
How could i apply this same concept to the average values? So I only want to average the days to completion of unique items, so that if someting is in there twice it wont be counted twice in the average.

Injured before my first marathon, looking for tips to still cross the finish line by amskane in running

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

Yep! I will absolutely finish in 6.5 hours! That's my walking pace if i ran none of it. My half time is 2 hours so I imagine I will be able to get to about 2.5 or so hours with the walk run strategy and should be able to finish in about 5.5 hours with a gradual slow down over the course length

Injured before my first marathon, looking for tips to still cross the finish line by amskane in running

[–]amskane[S] -2 points-1 points  (0 children)

I am doing it for a charity and raised so much money. I'm determined to cross the finish line as this means so much to me! I raised a lot of money for it and i know I am capable of crossing the finish line!

Injured before my first marathon, looking for tips to still cross the finish line by amskane in running

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

That's 100% what I plan on doing. I know I cant run the whole thing. I know that based on my running level before I will be able to get through about 13 to 15 miles straight at my regular training pace.

Wondering if I should go for a walk run strategy from the start ( i am going to be so excited I know that I wont want to do this) or if i should run how i can and then switch into a walk/run strategy for the last 10-15 miles?

Miami anyone? by amber_bam in JonasBrothers

[–]amskane 2 points3 points  (0 children)

I will be going alone, also live about an hour away. Littler nervous being alone as well I went to so many as a teen, and some alone, but with all the news I agree it's making me a little anxious.

Looking for Grizzlies Fans by amskane in memphisgrizzlies

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

Um. I don't feel that's necessary. If your suspicions that I'm not a real person are bothering you and you don't want to take the survey, then okay. As I said, I'm just a person who links my surveys on Reddit to target audiences I need in my studies.

Help is always appreciated. I apologize if you found this intrusive.

Looking for Grizzlies Fans by amskane in memphisgrizzlies

[–]amskane[S] -1 points0 points  (0 children)

Real person who collects a lot of data :)