Adobe Photoshop CS3 tutorials and guides, DSLR photography guides and tips, MS Office help and tricks

Photoshop:

1. Tutorial: Black and White with some parts colored using Photoshop CS3
   
2. Tutorial: Adding copyright watermark to your images using Photoshop
   
3. Biow Tutorial: Animate series of images with Photoshop CS3
   
4. Tutorial: Reflection effect in PS
   
5. Reference: Photoshop Magnifying Glass Tutorial
   
6. Reference: Add Speech Balloons and Text Bubbles to Your Photos in Photoshop or Elements Tutorial
   

Photography:

1. Photography 101: Photograph Silhouettes with Nikon D40
   
2. Photography 101: Diffractive Starburst effects on sunlight taken with Nikon D40 without starburst filter
   

Excel:

1. Remove duplicate data or records, create list of unique data or records in Excel 2003
   

Remove duplicate data or records, create list of unique data or records in Excel 2003

Ever wonder how you can create a unique list of data from a column in Microsoft Excel? Since i'm a programmer I'm so tempted to do a "SELECT DISTINCT column_name FROM table_name" command. Now, I know I can do this equivalent SQL command easily with a few mouse click. Here is the step-by-step guide to help everyone to create a list of unique data or records from a column of data that has duplicate records in Microsoft Excel 2003. And also as a reference for me in future.

Step 1. List of your duplicate data
1. Select / highlight all the cell in your column where you want your duplicate data to be removed.
2. Go to Data > Filter > Advanced Filter...



Step 2. Specify the cell for your unique data
1. In the "Advanced Filter" pop-up window, select "Copy to another location" radio button.
2. Enter range of cell in the "Copy to" field. I just accept the default given value of $B:$B.
3. Checked / ticked the "Unique record only" checkbox.
4. Click OK.



Step 3. Unique data created
1. The duplicate data is removed. Your unique list of data or records will be created in column B.

See also:
1. Tutorial: Black and White with some parts colored using Photoshop CS3
2. Tutorial: Adding copyright watermark to your images using Photoshop
3. Biow Tutorial: Animate series of images with Photoshop CS3
4. Tutorial: Reflection effect in PS
5. Reference: Photoshop Magnifying Glass Tutorial
6. Reference: Add Speech Balloons and Text Bubbles to Your Photos in Photoshop or Elements Tutorial