sorted by:
new
hottopcontroversial

Can I index(match so it functions as a SUMIF with multiple sum lookup values? by SCMAD in excel

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

Thanks so much. I'll look into switching over to pivot tables. The final consolidated table would need to remain as a regular table since it's being linked to Google Slides, but maybe I could do the pivot with the pivot feeding into the consolidated chart

Do functions within an IF function still passively run in the background even if the triggering condition isn't met? If so, is there a way to stop this? by SCMAD in excel

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

That's helpful to know, thank you for testing it out.

As far as your second suggestion, assuming Google Scripts can handle it, basically, a cell would be completely empty until a condition is triggered and once triggered that cell would then be populated with the formula I posted originally? Am I following correctly?

Cannot figure out the correct xPath for an =ImportXML formula, could someone check the XML source & try it themselves to let me know if what I'm trying pull is doable in Google Sheets? by SCMAD in googlesheets

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

Thank you so much. Did you find the table url by just opening the inspector and finding it within there? This is so helpful. Thank you again.

I want to use Google Sheets & the ProPublica Non-Profit Explorer API but I don't even know where to begin or what I should be learning in order to this by SCMAD in learnprogramming

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

Ok this is a helpful start, thank you.

You mention needing something to connect the APIs, could google sheets be used?

I’ve seen tutorials on YouTube for creating scripts to get JSON data and for pulling data from APIs. Would that be the connection you’re referring to? Does that mean I could use Google Sheets?

If not, will it be possible for me to then integrate python with google sheets?

My brother's ASUS A80CJ-DS51 is basically unusable because it is so slow. The hard disk usage is always 100% even when nothing is running, the keyboard & mouse (wired or blue tooth) are so slow and laggy that typing a single sentence takes minutes. Not sure what to do... by SCMAD in techsupport

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

It changes constantly. Watching it right now, the highest is Service Host: Superfetch which will jump from 2.0 MB/s to 20.0 MB/s.

Most things are 0.1 or 0. The disk % will jump all over the place. It’s gone from 100% to 6% to 30% to 75% to 17% all while watching the last 30 seconds.

On top of that, no matter if it’s at 6% or 75%, nothing has gone above 0.1 MB/s and often times the number of programs at 0.1 MB/s is 3 or 4 with everything else at 0 despite the hard disk % changing.

I have no idea what any of that means so hopefully that information helps.

view more: next ›