Tuesday, October 27, 2009

Create Unique List from Data Entry

How to create unique list from data entry in excel?

  1. In Excel, Go to Data > Filter > Advanced Filter
  2. Choose under Action : Copy to another location
  3. Select your data entry where you want to create unique in list range
  4. Choose Copy to in column B
  5. Check list Unique records only, then click OK
Have Fun! :)
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)