Hi Nitya,

Am Thu, 4 Jun 2015 02:53:27 -0700 (PDT) schrieb Nitya Satheesh:

A B
1 a
1 b
1 b
3 b
3 b
3 c
4 b
4 b
5 d
6 e
7 d

what should the output look like?
1 a
1 b
3 b
3 c
4 b
5 d
6 e
7 d

or:
1 a, b
3 b, c
4 b
5 d
6 e
7 d

Have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "UniqueValues"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional