@triplex86
Was a dragger in the past but I never knew anything better. Now I'm a dynamic. Great video Leila - nice to learn little tips and tricks like this . Thank you.
@nullcycle
Used to drag, but seeing this I am all for dynamic. Great tips!!
@GpD79
I'm a dragger for short lists and a double clicker for longer lists. I like to double click on the bottom right corner to get that drag effect, w/o having to drag. It's very helpful when you have a long list that extends beyond what's visible on the screen. The only issue is that it will stop once it gets to an empty cell, which is normally not an issue, but it is when not all cells in a data range are populated. I can see this sequence function being useful in a table as well.
@junyc85
I do both, but in most circumstances, I prefer a static rather than a dynamic index. It helps in going back to prior states of ordering/sorting, as well as serve as a permanent index number for look ups. The dynamic option is helpful only for end-state presentation.
@Paul-om1zs
Thanks for mentioning Bob Umlas. He has interesting approaches
@adrianpalmer3077
I am a dragger and I will continue to drag in certain circumstances. The most important one is when I want to sort rows by different other columns, but I want to keep the order when I want to come back to the original table. But I will adopt the sequence function for other situations. Thank you, Leila! 🙂
@hankgrimes1806
Hi, Leila. I've never been a fan of dragging numbers down a column, so I wrote these formulas to address to inconvenience: First cell =IF([@Date]<>"","1","") / subsequent cells =IF(D6<>"",C5+1,""). Even these formulas don't work dynamically, but they were in improvement over dragging. Now that I've seen how you use the SEQUENCE function + custom formatting, I'm squarely in the dynamic column. As always, you've been a lifesaver. THANKS!
@sergeralay2873
I used to be a dragger during years but I moved to the dynamic team a few months ago ;-) Whenever I can, I try to make my formulas dynamic. I have wasted so much time in the past manually updating my lists. Now, I'm trying to take advantage of Excel functionalities. Thank you Leila !
@sunshynea5151
I am a dragger and I never had an issue with dragging but that's because I didn't know any other way...definitely becoming dynamic from today. Thanks Leila this tutorial was great!!!
@Rjtucker60
I was a dragger in the past…this is a game changer! Outstanding!! 👏👍👊
@darylweaver9342
I use the fill series button lots, also for calendar functions. However, the dynamic sequence concept is great!
@deltawing9
Amazing content, as always. Working on older versions of Excel I'm afraid this function was not available back then. I used to add +1 to the previous row's number and drag down this simple formula.
@AndreZA979
What a great tip. I usually use a formula for changing numbers, adding 1 in the first cell followed by a =A1+1 in cell A2
@Xubono
I was a “dragger” for 25 years. After this video I am going to become a “dynamic”. I use equations everywhere else and thanks to this video, I shall convert asap! Thank you. It looks like I am also subscribing to this channel!
@ldmlhome
DYNAMIC! You just saved me so many brain cells, you are my HERO!!!
@natejenkins786
Hi Leila, I love your videos, I've learned many helpful tips, just for the record you viewers should know that if they're dragging to get a sequence of numbers incrementing by one, they only need hold down ctrl while dragging. But I prefer your method with sequence or maybe the row function. Anyway thanks for introducing that sequence function.
@EmlynFlint
Dragger/autofiller. And for large matrices that don't have existing columns, I use the FIll --> Series option. The problem with the SEQUENCE function, or any dynamic formula-based numbering system, is that the COUNTA with entire row (B:B) as input is a lot of unnecessary computation overhead, especially when you have multiple output tables across sheets. It doesn't matter for small books or those without much calculation, but this is exactly the use-case where dragging (or Fill -> Series) is sufficient. Then, for those cases when you have large tables or a lot of dynamic formulas and UDFs linked to user interactions, streamlining unnecessary formulae becomes imperative.
@richtiff
Use both depending on circumstances. With a large existing list where I want to use these as an index to the original order of the list (ie sortable), typing 1 then 2 and then double clicking on the small black square instead of dragging automatically fills in all the numbers for each active row of data. Simple but effective. For a more dynamic or increasing list, the dynamic option is great 😀
@rajeevgosavi4514
After going thru your fantastic Tutorial, I will continue to be Dynamic. Thanks Leila.
@LeilaGharani