What are /r/spreadsheets' favorite Products & Services?

From 3.5 billion Reddit comments

If you are copying and pasting, no - if you're dragging, yes.

It's really just a convince thing if you're auto filling formulas.

Here is a better explanation of how / what it's doing:

https://stackoverflow.com/questions/24402983/what-does-mean-in-excel-formula-e-g-b4

Using get data would require me to to use get data for every update, though right? I need to update several weather stations in excel so using get data really isn't much quicker than going to the site and copying and pasting. Or does GetData auto update every day? without requiring you to rerun it?

I also don't know where I can find a website that has high and low daily temps in tabular format. I think get data requires a table format. I don't think weather underground offers this: https://www.wunderground.com/history/monthly/us/il/chicago/KMDW

So, you want to want to get rid of all the rows with duplicate values in Column C?

And there are 58,434 rows, correct? If this is true it will delete about 60% of you rows.

I would do it in excel, because I know that will work well. Here is how you can do it in excel, http://superuser.com/a/728881, then just upload it back to a google sheet.

Do you know how to download it and upload it?

Hi u/AnimatorFuzzy1435

I personally use this Personal Budget sheet template from Stackby. It automatically gives me track of monthly budget, my income and expenses.. on a daily basis. It's free, check out: https://stackby.com/templates/personal-budget

I have not done a whole lot of work with Query's so hopefully someone else will be able to chime in - but I did find this:

https://stackoverflow.com/questions/34947445/query-or-filter-the-highest-value-with-conditions

which may be a helpful start for you - or someone else.

Alright I just gave it a go. I really don't know how to get it working lol... I thought it'd work with something like this, but it really doens't... I don't know how to make the "database". I could make a table and just vlookup stuff in it, but the problem would be the same : the vlookup would show the string that it's looking up to. If I use vlookup for like "Subway", I'd like it to show up as "food". It'd be for another spreadsheet like this and I'd want the values to show up as "food, gaz, amazon...". Let me know if you have any idea on how to do this!

Cool! Have you ever thought about making a website (based on the google script) that would display things "at a glance".

For example, here is my work's spreadsheet (Silly point game): http://i.imgur.com/PIG1Rz8.png and the website that goes along with it: https://script.google.com/macros/s/AKfycbw2zzdrtq834W0slIWmqGO8yDVUDHy4YwVXJF90CoE/dev

And this is all done with scripts!

Hello /u/Bodieh !

This sounds pretty interesting - definitely nothing I've tried in a google spreadsheet.

I'd recommend looking through templates for a storyboard layout.

If you were looking for something that was more hierarchical because of the "choose your own adventure" aspect I think the google treemaps would be really cool however, possibly hard to create and impractical for small stories.

https://developers.google.com/chart/interactive/docs/querylanguage#format

I feel like there has to be something THERE that would work but I don't understand it well enough to know for certain.

The data is from a form, so I can't just set the column as Text and forget about it. I have to update that every week.

I tried setting the form so it was 'validation must be text' but numbers get through as numbers still.

I could possibly do a "please put a 'A)' in front of your submission" on that question and have that be validated. But I'd rather not.

hmm. So the way to do this on your own would be to use Twitch's API.

If you're not comfortable learning / setting that up, I'd probably recommend a third part integration like Zapier or IFTTT.

Hey thanks a lot. I just realized what I really need. I need a way for a drawing button to open a url. I tried it with > function openWin() {

window.open('https://mail.google.com/mail/?view=cm&fs=1&tf=1', 'eMail', 'resizable=yes,scrollbars=yes,height=undefined,width=undefined',

but all it says is that "window is not defined". Got any ideas? Thanks in advance man!

>=IMPORTXML(url,‎ xpath_query)

I just did, but I'm sure I've done it wrong.
Here is what I put for a reference.

=IMPORTXML("https://www.amazon.com/MILWAUKEE-18-Volt-Cordless-Impact-Multi-Tool/dp/B08W7MD58P/",‎"<span id="price_inside_buybox" class="a-size-medium a-color-price">
</span>")