UNIQUE function returning 0

[thewiseguy]

Hi all. I am using the UNIQUE function on a column full of text and the last unique value being returned is a 0. I have this occurring in 2 different UNIQUE functions.

How can I check the reference cells to see where this is coming from?

Any help is greatly appreciated.

 

[Fluff]

It probably means that you have blank cells in the range.

 

[thewiseguy]

It probably means that you have blank cells in the range.

that would be correct. how can I alleviate this?

 

[Fluff]

You can use unique in conjunction with filter, to filter out blank cells.

 

[thewiseguy]

You can use unique in conjunction with filter, to filter out blank cells.

great, will look into that. assuming i can do this if i am already using UNIQUE and SORT?

 

[Fluff]

Depends on what exactly you current formula is & what your data is like.

 

[trunten]

great, will look into that. assuming i can do this if i am already using UNIQUE and SORT?

absolutely. for example:

=SORT(UNIQUE(FILTER(A2:A32,A2:A32<>"")))

 

[thewiseguy]

absolutely. for example:

=SORT(UNIQUE(FILTER(A2:A32,A2:A32<>"")))

that is perfect - thank you!

 

[thewiseguy]

that is perfect - thank you!

so I had to create another column of data and make this UNIQUE function reference this new column of data. This new column of data has some blank cells and it is still returning a '0' value.

Any ideas why?

 

[Fluff]

In that case I doubt the cells are actually blank.
Can you post some sample data using the XL2BB add-in.