Removing Both Duplicates from a list
"List" is a defined name range (no quotes)
=IF(ISERR(SMALL(IF(COUNTIF(List,List)=1,ROW(INDIRE CT("1:"&ROWS(List)))),ROWS($1:1))),"",INDEX(List,S MALL(IF(COUNTIF(List,List)=1,ROW(INDIRECT("1:"&ROW S(List)))),ROWS($1:1))))
ctrl+shift+enter, not just enter
copy down as far as needed
"tim" wrote:
I have a list that i need to remove all Duplicates, if I find any,
example
List
1
1
2
3
3
4
5
5
Goal
2
4
Not sure how to do this, I'm on office 2007 and I dont see a way to do this
with Remove Duplicates as it still leaves me with one of each number.
|