Listing non-blank items in a cell

[bearcub]

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 all the majority of cells that do not contain anything in them (they're blank)?

Are there any other types of formulas that would work for a situation.

Thanks for you help

Michael

 

[Sumitpal SIngh Sandhu]

With this formula u will get list of unique.But however u need formula to return those cells which contains 'Text' for them you can use >> =IF(ISTEXT(A2)=TRUE,A2,"")

 

[bearcub]

This is a good formula but I don't think it is quite what I'm looking for. I was trying to find a mechanism to extract a unique list from a big list of items that don't contain blanks. I'm thinking that I will probably have one cell that will contain nothing since this will part of the source data, correct?