I am not using excel forum so there are no file attachments, if indeed your
values can go as far as
650000 rows then it is probably not a good idea to use an array formula. You
would feel like an animal trapped in a tar pit. I am sure advanced filter
would be faster


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"agarwaldvk" wrote
in message ...

Peo

Can you please help here?

I tried to use the above to extract unique values from a list. This
list at the moment is around 700 rows but can expand to 65000 rows. It
didn't seem to work for me.

I am attaching herewith the spreadsheet with some data there. Can you
please advise me as to where am I going wrong?


Best regards


Deepak Agarwal


+-------------------------------------------------------------------+
|Filename: For Forum.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4655 |
+-------------------------------------------------------------------+

--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile:
http://www.excelforum.com/member.php...o&userid=11345
View this thread: http://www.excelforum.com/showthread...hreadid=514051