“They're using that spill error now. So it will just cause a spill, which is quite frankly, the day Dynamic Arrays showed up was one of the best updates ever.”

Katelyn Stienen · FP&A Today · Would You Rather Be Lucky or Good? Building FP&A From Absolute Zero, with Katelyn Stienen

Play from 8:30
8:30

Audio streams from the publisher’s own feed. Verbatim does not host or copy it.

What was described

Leveraged Dynamic Arrays spill errors to prevent pivot table crashes

Said nearby on the same subject

“We could do discounts and generate cash from our inventory… we pivoted to leverage the assets we had, which were inventory to generate cash.”
HR
Heidi Robinson
Run the Numbers ·
Growth tactic Share this moment
“Spent a lot of time on catching errors in production, like finding out how we can create feedback loops of, hey, we messed up this table, how do we create a better tabular representation?”
♫
Said on The a16z Show
Automation Share this moment
“My default and go-to is XLOOKUP. It's way better than VLOOKUP. It spills, I can go XLOOKUP and have all 12 months show up exactly how I want them.”
KS
Katelyn Stienen
FP&A Today ·
“Early intervention, particularly in education and in eye care and preventative measures that can prevent some of these negative outcomes like synkinesis, is actually super important”
JW
Jenny Wills
Speak Up ·
Why it worked Share this moment

Moments like this, every Monday

The strongest new moments on your topics, in the speakers' own words. Free for three topics.

No card. No password. One-click unsubscribe.

Track a competitor?

Pro watches up to 25 names or phrases and emails you the morning after they are said.

See Pro, $29 a month

Verbatim quotes a short extract and links to the episode; the episode belongs to its publisher. Remove a show.