Unique Function

[datauser]

Hi All! I am using a unique function to get a list of unique names from one sheet and inserting them into another sheet, but when I use this function, the last row of my unique function is always 0. Is there a work around to avoid the zero? =UNIQUE(Query2!K:K). the number of rows in my source data will always by dynamic.

Thanks for your help!

 

[Fluff]

How about

=UNIQUE(tocol(Query2!K:K,1))

But it's best to avoid whole column references.

 

[datauser]

I did not test this. I was able to figure it out. I named my range, and referenced that named ranged in my formula: =UNIQUE(Query2[''Members''])

 

[Dave Patton]

A new function that may help.
=TRIMRANGE(UNIQUE(Query2!K:K))