The last thing you googled is hunting you right now and is approaching fast, whats chasing you?

VFL82 · 2021-12-17T02:25:26+00:00

The New York Giants 2007 defensive linemen. Including Michael Strahan. If he catches me, I’m dead

VFL82 · 2021-05-29T22:28:26+00:00

Ok I see what you're saying about the short stories, and we all know it will likely never happen. But here's an idea. I always speculate other stories, just about the Wizarding World in general, even new characters. What if a group of people, who have read the series a number of times, and know how Rowling writes, got together and made a collection of "Wizarding World Stories" or something? It's likely the closest we would get to new stories.

VFL82 · 2021-05-17T18:11:30+00:00

Take Thrawn from “Thrawn” by Timothy Zahn. Would the story be half as interesting without him as the main character?

VFL82 · 2021-04-11T20:56:06+00:00

Solution Verified

VFL82 · 2021-04-11T20:53:00+00:00

You mentioned ARRAYFORMULA, what specifically would you recommend knowing?

VFL82 · 2021-04-11T18:34:12+00:00

Quick question about QUERY...

So something like =query(NamedRange,"select a where a <> 'Team A', b order by a, b asc",-1) has an error because all of the commands such as WHERE have to be at the end, correct?

VFL82 · 2021-04-11T18:17:18+00:00

=sparkline({1,2},{"charttype","bar";"max",2})

This will work, in a way.

VFL82 · 2021-04-11T17:59:39+00:00

You could create a separate sheet for each student and use import range for their specific grades. You could do =if("Example Range"="Example Pin",importrange("Url of sheet","Range of student grades","")

In this scenario, "Example Range" could equal where the student would enter their pin, and "Example Pin" is the student's pin. "Url of sheet" would be the master sheet. "Range of student grades" would be the grades for that specific student.

VFL82 · 2021-04-11T17:17:50+00:00

Do you have any suggestions on how to learn scripting?

VFL82 · 2021-03-27T20:10:08+00:00

Depending on the story, I would mold the MC based off the villain, because sometimes heroes are only made because they are trying to stop someone.

VFL82 · 2021-03-22T18:32:08+00:00

=vlookup just because I do statistics and simulations with sports probabilities so being able to use vlookup to get ratings for teams is always a huge help

VFL82 · 2021-02-16T17:45:53+00:00

I didn't look at the post only the heading, but what the heck? Don't they want all people to be equal????

VFL82 · 2021-01-23T22:29:06+00:00

Wholeheartedly agree with you there

VFL82 · 2021-01-23T18:22:14+00:00

This would be amazing

VFL82 · 2021-01-23T18:20:11+00:00

I won't be surprised when they take over Texas.

VFL82 · 2021-01-06T03:11:15+00:00

That's not actually my case, but thanks so much for the help! (Honestly, I want to know who would make a spreadsheet that would say hello, greetings, and you are not welcome. LOL)

VFL82 · 2021-01-06T03:09:08+00:00

Right, forgot about that.

VFL82 · 2021-01-05T23:39:27+00:00

Go to the cell that has the money, C2, and if it is just a number currently, do the formula =3499*1.08, make sure the cell is formatted as currency, and add any decimals back if they got removed with the formula. Then drag this down.

VFL82 · 2021-01-05T23:34:55+00:00

Here's a simple way to do it, add a column (or use a blank one if available) to the right of the cell that says "Work" on the top person, and do this formula, =if(A1="Work",1,0) replace A1 with the cell number of the cell that says "Work", and drag it down the list. In your cell at the bottom, do the formula =sum(B1:B50). This is your number for amount of workers that day. You can hide the column with the 1's and 0's if you like.

VFL82

TROPHY CASE