Excel Sequencing Sensation: SEQUENCE & RANDARRAY - Episode 2237

Like sequence can we do same for date
Example enter date automatically when referenced cell is fed a record
And that without requiring to use flash fill?

Sequence function is useful if you want an ammortization table of a varing number of periods, tho. When you could just drag, filling a series of 600 gets tedious... [edit] lul, I paused to answer your rhetorical question.. [editedit] my company uses an ancient version of excel. might have to pitch an update to the top-hats

Can this formula available in office 2019

Hi, From which version of Excel is this function available?

maybe January 2019??? Hope so :)

I have downloaded the E book. Thank you.

WOW! Just that: WOW!

All great reasons to be on Office 365. Thanks MrExcel

Amortization with variable Rate. can we use Sequence function ?

This is really awesome. Thanks for posting the videos.

Amazing new Array Functions!!!!! I wish I had the correct version so I could play too : )

CONVERGENCE !!!

I can see MS Excel going on convergence lane with M- language in Power Query ( Get & Transform )
and probably with DAX in the very near future !!!

Go ! Go!! Go !!!

Go Excel Team !!!

UNPIVOT(); PIVOT(); NESTEDJOIN(); APPEND(); MERGE(); CALCULATE(); etc !!!