Комментарии:
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 !!!