Do you want to freeze a row or column in Excel? Do you find yourself constantly having to scroll back...

Dropdown List Dependent On Another Cell For a more complicated dropdown list, we can create dropdown list where the list...

The VLOOKUP function searches for the lookup_value in the leftmost column in the table_array and stops when the first match...

In this article, we will have a look at the REPLACE function. We will look at how to use this...

There could be various reasons why we need to change and substitute certain text in a cell. We have touched...

There are many different ways to compare two columns. And it depends on how we want to do the comparison?...