MS Excel / VBA help thread

Posted on
of 52
First Prev
/ 52
  • I'd be tempted to look at an api like this or similar. You may need to look around for one that contains more than match odds.

    Otherwise, when I've done this in the past it's been a matter of searching round different websites to either find something with a static web address or one that is easily recreated (e.g. the date, team names that follow a constant format, etc)

  • yep - thought as much. will have a look at those links and see if anything good comes up! cheers @aggi and @Sam_w

  • Why did I put off learning powerpivot for so long, fml
    Last few years battling horrendous formulas and performance issues in excel 2013 which would of been solved in many cases by just learning to use the inbuilt functionality properly

  • I just installed R-Suite.

    That means I'm a data scientist now, right?

  • Is that like R Studio but 7 better?

  • Can you use R? If not, dataquest have their new R courses free this week

  • Trying to teach some lawyers how to do PivotTables. FML.

  • I've never used it.

    I'll do what I do with SAS, and learn enough to parse SQL, and leave it at that.

  • I honestly have no idea - it was / is the easiest to install with least authorisation required on the company dollar.

    It's installed as I need to figure out what someone's underlying SQL queries are doing

  • Still. Data science tho

  • In science and data stuff, I'm trying to work out spatial neighbours.

  • There's a SQL r package, I can't remember its name.

  • Use r! Is running atm too.

  • And finally, mango solutions

  • Post a reply
    • Bold
    • Italics
    • Link
    • Image
    • List
    • Quote
    • code
    • Preview

MS Excel / VBA help thread

Posted by Avatar for mattty @mattty