Hello there. I have a formula which is returning values from a data set into a list. I am then simplifying that list to ensure there are no repeats. Thus far, I have accomplished this task using the following formula:
However, I would also like the index to ignore all blank cells in the original data set. I can't for the life of me figure out how to accomplish this.
My current output:
Notes, all data in the data set (ItemSeam) is text (or blank).
Any help would be greatly appreciated!
Rich (BB code):
=INDEX(ItemSeam,MATCH(0,INDEX(COUNTIF($C$23:C23,ItemSeam),),0))
However, I would also like the index to ignore all blank cells in the original data set. I can't for the life of me figure out how to accomplish this.
My current output:
Notes, all data in the data set (ItemSeam) is text (or blank).
Any help would be greatly appreciated!