Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » Create a unique items table from a duplicating table
Create a unique items table from a duplicating table
1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.
Added by Orok on 23rd November 2006
More Excel hints and tips, like:
- Hiding a worksheet in Excel
- Moving or Copying Sheets Between Workbooks in Excel 2010
- Closing Multiple Open Worksheets At Once
 |
Some Gaffes To Avoid For A Professional PowerPoint Presentation With PowerPoint you can produce slick and professional looking presentations. They can also appear amateurish if you do not pay attention to detail. Here are some things to avoid. » Article: Powerpoint courses london |
» Forum post: How do I create 2 buttons using vba to add and delete records on |
» Tip: Sending a message |
I have developed an access form in access 2007 with records of different customers. I would like to create 2 buttons using vba to delete a customer's record if they decide to leave the company, and a button to add a new customer to the existing customers..
Once you have typed your message press ALT + S
