Answer to the 5 little Tips (tests) – Part 2/5
Fill a series (of sequential numbers)
The task: Fill a big series of sequential number, say from 1 to 24567.
Answer: You may find the answer to the question in this post: Fill Series.
That post was indeed inspired by one of the winning MEME posts found in Bacon Bits.
Check this out for some Excel FUN: http://datapigtechnologies.com/blog/index.php/excel-meme-contest-winners/
Try yourself how to fill a series of weekdays only. It’s super easy when you know where to start.
This is a very well hidden feature about Fill… Justify. Check it out and you will be amazed, especially if you are using Excel more on text input than data analysis. 🙂
I hope you feel good with Fill now. 🙂