UNIQUE function

Question

hi everybody

I have a list of customers in column B which contains repetitions. I need a unique list of their names. I have used the UNIQUE function which works however, because I have selected the whole of column B, it gives me the list but then a 0 at the end because there are empty cells in the range. What can I do to the formula so the 0 isn't returned?

I can't just select the exact range with their names in because if any new names are entered into column B, these need to be picked up too.

TIA, Louise

Answer 1

It returns the array as a single column. It already is a single column but it has an argument ignore that I used to ignore blanks (value 1):

Answer 2

=TOCOL(UNIQUE(B:B),1)

Answer 3

Ah, I get it! Thank you - never used that before.

Louise

Answer 4

Hi

Thanks very much for your reply. I've tried this and it returns the CALC error. Here's my formula - what have I done wrong? Are you able to give me a breakdown of the steps?

TIA, Louise

Answer 5

Hi, thank you for your response. I've never used this function before - what does TOCOL mean? Also, what is the number 1 doing at the end? Just so I understand how this works.

Thank you, Louise