Excel Formula to Increment Numbers: 1-6, 7-12, 13-18 for Raffle Ticket - Excel Magic Trick 1585

Learn how to use a formula to increment numbers to create labels like: 1-6, 7-12, 13-18 and so on for Raffle Ticket Categories. See the most important Excel Worksheet Function for incrementing numbers: ROWS. See variations on ROWS. Learn about how to copy formula down 250 rows without a mouse. Learn a great Go To Trick.

[excelisfun]

Be sure to check out the Bonus Trick at 03:00, which shows how to use Go To & Ctrl + D to copy a formula down 250 rows without a Mouse!!!!

[sasavienne]

I can not find the appropriate adjective to describe how good you and your videos are. Thanks for this fun....

[pabeader]

Mike, Thanks for explaining the difference between using ROW and ROWS. I remember a comment you made about a formula I showed you and you mentioned that ROW was not the correct thing to use. Now I know why!!

[enriquedominguez]

Elegant use of ROWS and great bonus trick. Thank you Mike.

[LeilaGharani]

Thank you for the increment fun and the bonus trick 👍

[nsanch]

Thank you for the number increment trick Mike. I love learning those techniques.

[FabioGambaro]

Great formula and awesome bonus trick!

[mazarata]

Another great tutorial Mike; and yo really explain in such a cristal clear way! Thanks very much. Maybe a minor add-on. At the end you press CTRL + D, reason being that you are not in Edit Mode. You can however press F2 and then CTRL+ENTER. Not that this would speed up things really, but just came up to my mind. Cheers, Giuseppe

[ogwalfrancis]

Number Increment made easy with Excelisfun, thanks Mike

[UpExcel]

Great tip to fill down to a set cell!! I hadn't thought of using ROWS for something like this either, saves using a helper column.

[GeorgeAJululian]

you are a genius thank you very helpful

[GeertDelmulle]

Those expandable range tricks are great!
Now, I have a feeling that this was the way to go in the era before dynamic arrays...
...oh, right: we’re still in that era!
Hope to leave it soon. ;-)

[wayneedmondson]

Hi Mike.. great trick.. love ROWS and COLUMNS to help expand the fun.. haha : )) Thumbs up!!

[katerina]

Absolutely fantastic Mike, thank you 🤗

[johnborg]

This was very interesting. I always used the Ctr+D when I have the active cell below. Never tried Ctrl+D when I have the active cell on top. I always did Ctrl period(.), to bring the active cell to the top, F2 and Ctrl+Enter. I learned something new today too. Thanks Mike. :) :)

[Luciano_mp]

Amazing trick....very good. Thank you Mike. 👍👍👍

[stopdrinkingleftskoolaid]

I needed a formula for this very same thing about four years ago. The goal was to get a ticket book sequence of
1-15, 16-30, 31-45, 46-60 etc

However I figured out the following

In cell A1, I started the number sequence as follows:

A1= 1
A2= 16
A3 =31. Etc.
I used auto fill once Excel recognized the pattern

I did the same for the second set of numbers
B1= 15
B2= 30
B3 =45. Etc

I scrolled down each column until I got to enough rows to match the amount of tickets. It’s not a big deal to scroll down a few hundred rows in 5 seconds.

I then used the concatenate symbols to join the two columns together

=A1&”-“&B1. Which gives me 1 - 15. Simply copy (drag) this down to the end.

With the entire column highlighted, right click on the edge of the column and drag it to the right to a different column.

When you let go of the mouse, choose “paste as values” to ditch the formulas

That’s it.

[MalinaC]

Nice formula and bonus trick :). I love GoTo feature!

[evgeniam]

Excel-lent and bonus trick amazing. I've been wondering for a while for that one and you gave the solution :) Thank you

[pmsocho]

Thanks for the video. It is worth to that ROW is more efficient than ROWS since ROWS uses expanding range :)