Thread: List without duplicates

Hi,

I have a source list(obtained from a query result) which needs to be copied to a destination list without duplicates dynamically.

Source Destination

2008 2008
2009 2009
2009

2009

2010 2010

2010


(file attached)

I cannot use macros, i need an excel formula for this.
Kindly Help.


Thanks In Advance,
Shruthi