How to generate batch numbers in excel with auto increment feature

Open Excel Sheet

Enter 1 into A1

Then enter this formula into A2:

=IF(MOD(ROWS($A$1:A1),5)=0,A1+1,A1)

Then just drag the formula from A2 down

As you can see in my formula batch number is change after 5 rows and batch value is increase by +1.

You can change logic of formula based on your requirement. Like if you want batch number to be change after 10 or 100 counts, change the current value of 5 to 10 or 100. Batch number will change after defined number of rows.

Also if you want batch number to be increment by 1 or more then 1, change the value here "+1" in formula.

comment for more clarifications.

Ref : Click here 

What are some good internet hacks?

Here are some Internet hacks:

• Instead of ' Ctrl+Alt +Delete', Press 'Ctrl+Shift+Escape' to get straight to the task-manager in Windows.
• FutureMe.org lets you send emails to yourself in the future.
• On Nreboot.com you can continuously stream 90's cartoons for free.
• On Blahtherapy.com you can vent your problems and secrets to a total stranger.
• On Televisor.com you can enter a show you like and it will recommend new shows to watch and where to find them online.
• Download music: Copy a YouTube URL with the song you want. Go to YouTube-mp3.org Enter the URL and press 'Convert'. Download!
• On Supercook.com you just enter what ingredients you have and it tells you what meals you can make and how you can make them.
• If you accidentally close a tab, press Ctrl+Shift+T to reopen it.
• 10minutemail.com gives you a fake email address so you don't have to use your personal email address when signing up for something.
• If a website is blocked on your work/school Internet, you can use Google Translate as a proxy. Just copy/paste URL into it
• Go to IAmAwesome.com and prepare to be amaze. ;)

• On En.Akinator.com You can think of any fictional character and it will guess it in less than 20 tries.
• If you have many different online accounts, On NameChk.com you can see every website Where your username has been used.
• Ever hear a song on TV but you don't know what it is WhatIsThatSong.net will tell you.
• If you type "do a barrel roll" into your Google search, the whole page will spin. Try it!
• On AccountKiller.com you can instantly remove all of your personal data from websites you don't want having it.
• If you type in any flight number into Google you can see exactly where the plane is.
• There is a free website called "EssayTyper" that lets you type a topic and it will write the paper for you in minutes. 
• DocumentaryHeaven.com is a website that lets you watch thousands of documentaries for free.
• When your kids are born, reserve them a good email address. Send them pictures, notes, etc. Give them the password on their birthday.
• Mathway.com Solves all kinds of math homework problems with step-by-step explanations.

Thanks for reading :)