✨Extracting Unique Non-Blank Items from a Range #excel #shorts

In this video you will learn how to use a combination of functions to extract only the unique items from a list while ignoring any blank cells.☀️

In many spreadsheets you might have a list that contains repeated values and sometimes even blank cells. To create a clean list of unique items, you can use the formula =UNIQUE(FILTER(A2:A11, A2:A11<>"")).

What happens here is that the FILTER function first looks at the range A2:A11 and picks only the cells that are not blank. Once this filtered list is created, the UNIQUE function goes through it and returns only one instance of each item, removing any duplicates. For example, if your list includes fruits like Apple, Banana, Orange, and some fruits appear more than once, this formula will ensure that each fruit is listed only once, giving you a neat summary of the items you have.🌲
# viral #trending