Data Manipulation
 

Would like if the below result can be achievable and what method..
Sample data:

2003 sanny sony
2002 sanny sony
2002 sinsing pansonic
2002 dee tee
2003 dee tee
2004 dee tee
2005 ada hoa
1995 kii kiwi

Desired Result

2003 sanny sony
2003-2002
2002 sanny sony
2002 sinsing pansonic 2002
2002 dee tee
2004-2002
2003 dee tee
2004 dee tee
2005 ada hoa
2005
1995 kii kiwi
1995

Thanks,
Jimm

--
sanjimm
-----------------------------------------------------------------------
sanjimmy's Profile: http://www.excelforum.com/member.php...fo&userid=2496
View this thread: http://www.excelforum.com/showthread.php?threadid=38487

Data Manipulation
 

do you need it once or to be a premade macro ?

Data Manipulation
 

Thanks all..I get the solution from other source..

Jimmy.


--
sanjimmy
------------------------------------------------------------------------
sanjimmy's Profile: http://www.excelforum.com/member.php...o&userid=24960
View this thread: http://www.excelforum.com/showthread...hreadid=384876