G Guest Jun 20, 2006 #1 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?
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?
D Dave Peterson Jun 20, 2006 #2 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
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
G Guest Jun 20, 2006 #3 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
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
M Mallycat Jun 20, 2006 #4 Martin said: is there a way to return a new range based on those values without duplicates? Click to expand... You can use an Advanced Filter. Data\Filter\Advanced Filter, Extract uniquie records to a new location. Matt
Martin said: is there a way to return a new range based on those values without duplicates? Click to expand... You can use an Advanced Filter. Data\Filter\Advanced Filter, Extract uniquie records to a new location. Matt
