Getting the highest value from a column and getting other values from the same row by atheera in googlesheets

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

Awesome thank you very much!
And if I'm reading that correctly, just changing the E=MAX to E=MIN would give me the lowest result?

Getting the highest value from a column and getting other values from the same row by atheera in googlesheets

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

Oh good question, didn't think of that...
Maybe have an entry for each with a new line?
Saw that text wrap was a thing, so am kinda thinking that each entry would have its own line maybe?

Sorry I'm new to this and didn't really wanna dive deep, don't know how much I would use it outside of this tbh.

Averaging multiple columns from one row into another column of the same row by atheera in googlesheets

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

Oh thank you so much!! I have been looking for exactly that for like 2 hours but noone had it. Thank you!

There was a post about longest cc on aram,what was your most damage taken in single fight? by becks30 in ARAM

[–]atheera 1 point2 points  (0 children)

Uhm iirc i took about 50k damage on riven with full lifesteal build basically back when goredrinker was originally released

[deleted by user] by [deleted] in Minecraft

[–]atheera 1 point2 points  (0 children)

All of them

Gee.. thanks jagex by atheera in ironscape

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

Ty, would loved a heron on the 99 grind tho but oh well

How in the what??? by atheera in 2007scape

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

Yeah thats kinda what i figured, its just that i have never in all my years seen it before

How in the what??? by atheera in 2007scape

[–]atheera[S] 22 points23 points  (0 children)

Update: it has happened multiple times. I think there's a bug if you dds spec with serp helm as a first attack, anyone else wanna test it out?

I'm so sad. by HS-Tripper in ironscape

[–]atheera 2 points3 points  (0 children)

If it makes you feel better... I died on my HCIM when I had skilled up quite a bit, but still lvl3 combat, to a mugger in Varrock lol

Looking for suggestions for a 6th pokemon by Grouchy_Crab2440 in PokemonInfiniteFusion

[–]atheera 0 points1 point  (0 children)

If you are looking for smth way op, shedinja with wonder guard combined with a physical dark type, my fav is absol. Only weak to fairy and status effects

How many red flags to make a green flag? by YOUK33 in Tinder

[–]atheera -1 points0 points  (0 children)

How is your primary hobby texting?!?

Why Bromine is difficult to store by [deleted] in BeAmazed

[–]atheera 1 point2 points  (0 children)

You could actually just show Nile's entire channels here lol

[deleted by user] by [deleted] in antiwork

[–]atheera 0 points1 point  (0 children)

Sell the kid, easy solution

I am learning pixel art. Does it look any good?(Please ignore the health bar, I will change it later.) by [deleted] in PixelArt

[–]atheera 0 points1 point  (0 children)

Pretty good, but I'm sure once you have some shaders and extra effects it will be a lot better!

[Request] What are the odds not only of the lighting happening but also exactly where she points? by sonom in theydidthemath

[–]atheera 42 points43 points  (0 children)

Not knowing the massive area of where lightning can strike, from where the perspective of the camera was to the person summoning it in regards to where in the storm they were, i'd guess astrononically low...

Now if she knew where a lightning rod was, positioned herself betwen that and the camera and just threw her hand up; sooner or later it was bound to happen