Excel Quick Tips - How to create an auto sequence counter in Excel #excel

yo my OCD could not handle this tip check this out so I saw someone showing off this effect where you take a sequence an account a function and you have your auto counter here but the problem is you're never going to get to the bottom of the list it's always going to hang down one number below where your data is so how do we fix that how do we change that easy all you do is add a minus one to this guy and now you can continue adding to your list but at least it doesn't hang down below where there's no data and you can't ever catch up this is now satisfying my OCD hope that helps thanks for watching

Channel: Matt Brattin

Views: 1,696

Keywords:

Id: jhVDfBu6Y24

Length: 0min 39sec (39 seconds)

Published: Fri Feb 17 2023