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