If you need to remove duplicate values from your list then let me tell you that it is possible with UNIQUE Formula. Using the formula above we will get the following result. If there is enough space empty cells underneath the formula the formula will work as intended.
Use of this formula.
If youve opted for the regular formula press the Enter key as usual. This article explains how to use the INDEX and MATCH functions together in all versions of Excel including Excel 2019 and Microsoft 365. The UNIQUE function will return an array which will spill if its the final result of a formula. Enter the formula in the first cell of the unique list B2 in this example.