is there a formula that remove duplicate values from a range

[Martin R]

Given a set of rows each cell containing a value is there a way to return a
new range based on those values without duplicates?

 

[Dave Peterson]

Not a single formula, but there are other ways that can do it:

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

Debra Dalgleish shows how to extract those unique values manually:
http://www.contextures.com/xladvfilter01.html#FilterUR

 

[CLR]

Also, one of the standard features of ASAP Utilities will do it for you.
It's available at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3

 

[Mallycat]

is there a way to return a
new range based on those values without duplicates?

You can use an Advanced Filter. Data\Filter\Advanced Filter, Extract
uniquie records to a new location.

Matt