Latest Posts

How to Use Excel IF Function with Range of Values

IF is one of the most useful and widely used functions of Excel. Today I will be showing how to use this IF function with a wide range of values, ...

VLOOKUP to Return Multiple Values Horizontally in Excel

In Microsoft Excel, there are a few options to VLOOKUP and return multiple values horizontally. Although the VLOOKUP function itself is not able to ...

VLOOKUP Max of Multiple Values (With Alternative)

MS Excel’s VLOOKUP function is used when we need to find things in a table or in a range by row. It makes our task easy in terms of searching for ...

How to Sort Duplicates in Excel (Columns and Rows)

Sorting is one of the most common tasks in the daily use of Excel. You need to perform various sorts; sort multiple columns, sort dates, sort data ...

How to Sort Rows by Column in Excel (4 Methods)

When you are dealing with a big amount of datasets, searching, organizing, keeping them in a specific cell, and tracking the specific data becomes ...

Random Sort in Excel (Formulas + VBA)

MS Excel provides a few different sorting choices on top of the usual ascending and descending orders. We also have sorted by color or icon, as well ...

How to Create Custom Sort in Excel (Both Creating and Using)

Today I will be showing how you can create a custom sort list in Excel, and then use it. While working in Excel, sometimes we have to sort a data ...

Generate Random Number from List in Excel (4 Ways)

Although there is no suitable or single function to extract a random number from a list in Excel, there are numerous ways to manually construct the ...

How to Sort Rows in Excel (2 Simple Methods)

Sorting is one of the most common tasks in Excel, every now and then one may need to sort data. Most of our daily activities require column sorting, ...

How to Sort by Date in Excel (8 Suitable Ways)

Today I will be showing how to sort a data set in Excel by date. While working in Excel, we often have to work with dates. From insertion to ...

Sort Column by Value in Excel (5 Methods)

When you add more raw data to your worksheet, balancing, organizing, and searching the specific data becomes more difficult. To get rid of this ...

How to Sort by Color in Excel (4 Criteria)

In Microsoft Excel, there are numerous ways available to sort table data under different criteria. If the data table contains colors in cells, fonts, ...

Sorting Columns in Excel While Keeping Rows Together

Sorting is the best way to make the dataset more convenient and acceptable. This makes our work with datasets in various ways. MS Excel provides ...

How to Sort Alphabetically in Excel with Multiple Columns (4 Methods)

Sorting alphabetically in excel is very easy and at the same time very useful when you are working with a wide range of raw data. Sorting is one of ...

Shortcut to Copy Formula Down in Excel (7 Ways)

To get used to less usage of the mouse there is no alternative to practicing keyboard shortcuts. In terms of copying formulas in MS Excel, there are ...

ExcelDemy
Logo