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?

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

Martin R wrote:

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

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



"Martin R" wrote:

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?

Martin R Wrote:
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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553561