Extract unique items from a list
The core of this formula is a basic lookup with INDEX:
=INDEX(list,row)
In other words, give INDEX the list and a row number, and INDEX will retrieve a value to add to the unique list.
The hard work is figuring out the ROW number to...Read more