MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

finding unique values

  Asked By: Cory    Date: Oct 06    Category: MS Office    Views: 1503

Has anyone written a VBA the will take a list and display the a list
of each value only once. The nested formula a developed works but it
takesup all of the cpu each time it recalculates. My list was about
40,000 value and the reduced list was about 11,000.



1 Answer Found

Answer #1    Answered By: Miriam Green     Answered On: Oct 06

Rather than VBA, I always use filtering to do this, just selecting
unique values  as output. It's pretty quick.

Didn't find what you were looking for? Find more on finding unique values Or get search suggestion and latest updates.