Dynamic Dropdown List in Excel

Dropdown List Dependent On Another Cell For a more complicated dropdown list, we can create dropdown list where the list changes depending on the value in another cell. In this example, we will create two dropdown lists. The first one is a simple dropdown list with the names of the countries (United States, Australia, England … Continue Reading


How to Compare Two Columns

There are many different ways to compare two columns. And it depends on how we want to do the comparison? Do we want to simply see if item in one column is in the second column? Do we want to count how many rows have different items? Do we want to specify which rows have … Continue Reading