Formula to return list of single values from a range

  • Thread starter Thread starter G'day
  • Start date Start date
G

G'day

G'day,

I'm sure there must be one, but....

I have, in a column a list of many values, each occurring
many times - can any one tell me a formula that will
return a list of the single values(i.e. each valueshown
once)?

As always, great thanks to this excellent forum that many
times has saved my PC from being thrown against the wall!

Davis
 
It seems you don't want to invoke Advanced Filter with "Unique records only"
checked. If so, what is the range from which you want to create a
unique/distinct list of items? What kind of values does this range house --
numbers, dates, or text?
 
here's one..
IF(COUNTIF(A$1:A1,A1)>1,"",A1)

then copy it down as far as your list is, and it will only show the unique
entries in the list (but there can still be spaces in the list).
 
Thanks for the swift reply!
It is all text (products sold) and the reason I would like
no gaps is that it is dependent on a couple of other cells
(company name and date) also hopefully being used in the
formula. This list will then be used to update tables for
a particular company.

Thanks again,
Davis
 
Back
Top