Flex.io

Get =FLEX(). On-demand data from any API in Excel and Google Sheets. 🚀

[Product Hunt Hi @ProductHuntHi]

@flexiodata FYI, https://t.co/WjC3Dttbnd was posted on @ProductHunt https://t.co/b9YpbA80pq — Invite your teammates to join as Makers 🙌

[Flex.io @flexiodata]

Thanks for featuring us @ProductHunt! Join the conversation here: https://t.co/6pWQpQ57ia

[Joe McDaid @jjmcdaid]

I'm excited to announce that Dynamic Arrays is now generally available in the #Excel monthly channel.🚀 #SORT #UNIQUE #FILTER

[Flex.io @flexiodata]

Seven advanced features in @msexcel - including #xlookup & #dynamicarrays - nice write-up by @puneetism https://t.co/aca6CmPuOW

[Flex.io @flexiodata]

If you could get any data into @msexcel with a click, what would it be? Hot-off-the-press vid below showing how we're using #dynamicarrays to pull in data from web services like @Intercom and @FullContact - #NoCode required (but feel free).

https://t.co/HoZMoc3sho

[Flex.io @flexiodata]

@msexcel 'twas wonderful to see the dynamic array roll-out to Execl on the Web this week!! Any sense of timing when it'll roll out to 365 Monthly?

[Tim Heng @timaheng]

Dynamic Arrays becoming Generally Available this week, starting with Excel on the Web! https://t.co/nu8bO2fgYc #Excel #arrays #MicrosoftIgnite2019

[Tim @timreinke]

I've been interested in low-code and no-code so I did a little bit of writing about what I've learned: https://t.co/RIoaKXJQpc #nocode #lowcode

[Flex.io @flexiodata]

"[One hedge fund shows each new developer a particular @msexcel spreadsheet that makes $100M+ per year as part of orientation... to remove hubris]" A fun, informative read comparing enterprise financial #dataviz with #datajournalism @tophtucker https://t.co/fCRlGUNObG

[Flex.io @flexiodata]

A great primer on statistical fallacies including real-world examples -- Common Data Mistakes to Avoid @geckoboard https://t.co/CgdMckvklQ

[Flex.io @flexiodata]

Nice look at the history and utility of different types of databases: Comparing Database Types -- How Database Types Evolved to Meet Different Needs @jmellingwood https://t.co/UnFzpfJ7b7

[Flex.io @flexiodata]

Fun read - #AI learns to play hide-and-seek; develops lots of clever strategies and counter-strategies. How about a nice game of chess? https://t.co/oUvoeqJO5Q #MachineLearning @KelseyTuoc

[Flex.io @flexiodata]

Microsoft #Excel is doing some really slick things with their calculation engine. Check out this tutorial on the brand new #XLOOKUP Function (available in 365 Insiders channel) @msexcel @howtogeek https://t.co/gqhUhPw0ev

[Flex.io @flexiodata]

@BonnieOtter @Office365 Unfortunately, XLOOKUP is only available to the Insider's channel right now. 😢 If you're on monthly or monthly targeted, you'll have to wait (In Excel 365 go to File > Account > About Excel on the left, usually it'll say 'monthly channel' by default)

[Flex.io @flexiodata]

Build super quick @msexcel and @googlesheets lookups from remote files and share auto-documented functions with your team; no coding needed (unless, of course, you want to). #dynamicarrays

[Bill Jelen @MrExcel]

HOLY XLOOKUP: Because the new XLOOKUP returns a range, not a value like VLOOKUP, you can say "Sum all lookups from Cherry to Kiwi". =SUM(XLOOKUP(D4,A2:A19,B2:B19):XLOOKUP(D6,A2:A19,B2:B19)) #BadAss #Excel https://t.co/mADR3Bhvao

[Joe McDaid @jjmcdaid]

I’m excited to announce XLOOKUP -- the successor to VLOOKUP, the most iconic spreadsheet function of all time. https://t.co/xk6MoXyi8K

[Flex.io @flexiodata]

@jjmcdaid Hello! Amazing work on dynamic arrays. I eagerly downloaded v1907 just now and thought I'd see it available to us plebeians on the regular monthly updates :) However -- DA functions still don't appear available in Excel 365. Any sense on when it will be available? Thnx!

[Flex.io @flexiodata]

Dynamic Arrays for #Excel @Office365 is a game-changer that *should* be available to the public soon (but, apparently, not in today's release ☹️). Great primer here nonetheless via @DTomoffCPA https://t.co/nQZTS4Hdss

[Flex.io @flexiodata]

How hard can it be? Why it took 4 years to build that tiny link preview on @Wikipedia https://t.co/zRaRnDQ3T6