Formula to return list of single values from a range

[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

 

[Aladin Akyurek]

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?

 

[Dave R.]

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).

 

[Guest]

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

 

[Aladin Akyurek]

In order to avoid a lengthy repetition, have a look at my contrib in:

http://makeashorterlink.com/?G5D112167

 

[Davis]

Thankyou, thankyou, thankyou!!!

-----Original Message-----
In order to avoid a lengthy repetition, have a look at my contrib in:

http://makeashorterlink.com/?G5D112167




.