SEQUENCE Function

### How to Extract Text After Last Space in Excel (5 Ways)

While using Excel, we often need to strip our text Cells and need part of our data, like the need of having the last part of the word of the long ...

### Excel Find Last Occurrence of Character in String (6 Methods)

In this article, we’re going to find the last occurrence of a character in a string in Excel. Our sample dataset has three columns: Company Name, ...

### How to Create a Dynamic Top 10 List in Excel (8 Methods)

A top list is used to rank the companies or individuals based on values. This rank is set based on performance, quality, etc., or other criteria. In ...

### How to Autofill Days of Week Based on Date in Excel (5 Easy Ways)

Sometimes we need to have days of the week instead of only dates in our Excel datasheet. But, manually typing the days based on date is quite ...

### Random Number Generator in Excel with No Repeats (9 Methods)

For specific purposes (e.g. phone number, lottery, statistical sampling), we have to generate random numbers without repetition. However, you may get ...

### How to AutoFill from List in Excel (8 Quick Ways)

Often we need to use AutoFill for filling the cell or cell range downwards, upwards, and so on instead of entering the data repeatedly. How would you ...

### How to Remove Numeric Characters from Cells in Excel

Today in this article, we will demonstrate 5 suitable methods of how to remove numeric characters from cells in Excel. However, it is a very common ...

### How to Remove Numbers from a Cell in Excel (7 Effective Ways)

A very common problem while using MS Excel is how to remove numbers from text cells. For some reason, various systems mix up text and numbers ...

### How to Remove Non-numeric Characters from Cells in Excel

While working with Microsoft Excel, we may find data combined with text and numeric numbers. Sometimes, you need to know the numeric value of that ...

### How to Repeat Formula Pattern in Excel (8 Easy ways)

In Excel, it’s very handy to repeat a formula pattern to calculate a large set of data. If you want to fill formulas in every cell it will become ...

### How to Autofill Dates in Excel (3 Suitable Methods)

While working in Excel, many a time we are to work with dates. We are to insert dates in a single cell or a range of cells. Today I will be showing ...

### 12 Automatic Ways of Numbering in Excel

While dealing with a large dataset, you may need to assign automatic numbers to your cells. However, manually applying the number is a tedious task. ...

### Excel Auto Sort When Data Changes (9 Examples)

In Microsoft Excel, there are numerous procedures to auto-sort a table or an array if someone changes data. In this article, you'll learn how you can ...

### How to Autofill Numbers in Excel Without Dragging (5 Methods)

Microsoft Excel provides numerous ways to autofill numbers with or without dragging. Filling down the column is the most common method to complete a ...

### How to Use SEQUENCE Function in Excel (16 Examples)

In Microsoft Excel, the SEQUENCE function is used to generate a sequence of numeric values in different formats. In this article, you'll learn how ...

Advanced Excel Exercises with Solutions PDF