Deifine range ignoring duplicates
You could use a column of formulas that would extract and gather together the unique values from
column A, and reference those values using a dynamic named range.
HTH,
Bernie
MS Excel MVP
"Gotroots" wrote in message
...
In Define Name in Excel 2007 I want to create a formula for A:A that excludes
duplicates in the range.
How do you create this formula.
|