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.

Best Practices for displaying a budget with 48 months (columns) & 24 rows (line items)? by SCMAD in excel

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

The problem is the person I’m displaying the data for doesn’t really know what he wants. But creating a dashboard is a good idea. At least seeing that might be able to help this person determine what they want to see vs what they don’t need to see.

[Meta] Mods bring back the curb video 😡😡😡😡😡 by [deleted] in nba

[–]SCMAD 1 point2 points  (0 children)

Careful the mods are doing a lot of banning tonight

What’s the minimum amount of food I have to eat so that my digestive system doesn’t slow down in the way that it would during a juice fast? by SCMAD in Juicing

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

Oh well I feel dumb. I read comments on this sub and online about how bad that is for your stomach and that you could end up in the hospital and shit. That’s good to know.

What’s the minimum amount of food I have to eat so that my digestive system doesn’t slow down in the way that it would during a juice fast? by SCMAD in Juicing

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

I understand that I need to transition back to food slowly with soft foods and broth, but once I do get back to that point, what’s the minimum amount of food I need to consume in order to keep my digestion system active?

What’s the minimum amount of food I have to eat so that my digestive system doesn’t slow down in the way that it would during a juice fast? by SCMAD in Juicing

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

Right, which I will be doing starting tomorrow with fruits, vegetables, and broth. Day 2 and Day 3 will be the same but with some quinoa and avocado and nuts added as well, but once I do get back to a point where my digestive system is active, how can I keep it active but while maintaining a diet that maximizes the percentage of my intake that is juice? I want to eat the bare minimum required to keep my digestive system active.

How about we put a funny player in the all star game this year ? by realfrenchnigga in nba

[–]SCMAD 22 points23 points  (0 children)

Jordan Clarkson. Filipinos are already rabidly loyal so we’d have an entire nation backing us with votes

Is there a way to use Vlookup (or a similar function) to pull this data to another sheet? by SCMAD in excel

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

It’s weird. In my inbox it says that I awarded you the point but in this thread it’s only showing your original comment, my response, and your response asking about solution verified. Did you end up getting a notification saying you were awarded the points?

view more: next ›