Non-Formula Approach to get Serial Number Groups in Excel

preview_player
Показать описание
This video is inspired by the videos from excelisfun below:

In the videos, Mike shows you nice formulas to get a serial of increment numbers 1-6, 7-12, 13-18 etc...

I am inspired to make this short video to show you to achieve the same without formula.

As this is a non-formula approach, you know that it's for one-off and the result is not dynamic. It's a quick and "lazy" way to solve a problem. If you are looking for a dynamic solution, make sure you watch Mike's videos! :)

Want to see more examples of Flash Fill? Check this video:
Рекомендации по теме
Комментарии
Автор

Congratulations! What a clever practical solution!

paulozagatto