is there a formula that remove duplicate values from a range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin R - 20 Jun 2006 12:05 GMT

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?

Reply to this Message

Dave Peterson - 20 Jun 2006 12:31 GMT

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

> 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?

Signature

Dave Peterson

Reply to this Message

CLR - 20 Jun 2006 12:52 GMT

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

> 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?

Reply to this Message

Mallycat - 20 Jun 2006 13:10 GMT

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

Signature

Mallycat

Reply to this Message