I have a list of items that contain blanks in the column. I want to extract only those members that have text in the field.
I do have the following formula that I've used before but I'm not sure if it will work in this instance:
{=INDEX(list,MATCH(0,COUNTIF(uniques,list),0))}
Does this ignore...