How to build a serial number

Here what you want to do is manually enter the first two serial numbers and then drag the fill handle to down or double click on the fill handle. This function can return the row number of a specified cell. As per the example refer to screenshot above our row numbering to be started from row number 3. It will return the row number 3 in the active cell. But we need our serial number to start from 1.

So I have used the formula below. Then you can either copy and paste the formula to down or drag the fill handle down. When you delete any row in between, in this case also, the serial number will automatically get adjusted.

Note: If you want to have the serial numbers to get change when the data group changes see this tutorial — Group Wise Serial Numbering in Google Sheets.

This is the best option to automatically fill the serial number in Google Sheets. As per the above example, you just want to apply the formula in Cell A3.

No need to copy and paste it down. It will automatically do the numbering to the cells down. We have customer name under column B. Now the array function. When you want your serial number to start from Column H2 and your rest of the data on the right side. Use this formula in cell H2. Here the serial numbering will start from cell J3. You can use the above formula to automatically fill serial numbers in any column. Just change the cell reference in the formula as per your data. The numbers stay the same, even though the order of your records has changed.

Because the generated numbers have no direct relationship with the data in adjoining columns. If it was not the case, I mean if the array formula has some connection, then there is a workaround — how to Stop Array Formula Messing up in Sorting in Google Sheets.

So, the workaround is to go for Query function to filter as well as sort the data in another tab. B1:C,"where C matches 'product 1 product 2 product 3' and C is not null order by C asc,1".

What if I want to repeat that Week 1-Week 13 several times, so that I have 52 rows, as in 52 weeks in a year? Thank you, Prashanth for taking the time to help me. What a monster formula. After half an hour, I finally understand it. I cannot seem to figure out a formula to make this work, would you please be able to help?

In cell A33, insert the below formula. Hi — I will try to explain it as best as I can. Do you know how I can do this in google sheets? If you really want to stay ahead of the curve, you can download it yourself and check out the newest changes. The process is straightforward, and it involves hopping into your settings app.

Once you open it, follow these steps:. You should now be able to check your Android version as well as the build number. Your phone may store its security update information and Android skin version information in the same location. See also: Android settings you should change to level up your smartphone game. There you go, everything you need to know about tracking down your Android version.

Here's how to find what Android version and build number you have Updates are great, but how do you remember which Android version you have? Here are the easy steps if you want to find out. By Ryan Haines. What is the most recent Android version? How do you find your version of Android? Once you open it, follow these steps: Scroll to the bottom of your settings app and locate About phone.