LifeTricks.com 
USER CP
Site Navigation 
UPVOTE
UP
52
DOWN
DOWNVOTE
Excel Spreadsheet - Excel Spreadsheet Trick: Generate a Unique Value in a Column
UPVOTE
52
DOWNVOTE
  • life tricks short link

Excel Spreadsheet Trick: Generate a Unique Value in a Column

Excel Spreadsheet

Click to choose the column, go to Data->Advanced. A pop-up window will show up. Click Copy to another location, w/c should be in accord w/ the 2nd red rectangular area. Specify the target location by typing the value or clicking the area-choosing but

Trick Source:

Is this trick using work of your own without attribution? Click here to PM the user and let them know!

Author Comments

Avatar of Love
amourdange says:

You are aware of the key function of Filter, but few people use the Advanced Filter, which will be repeatedly applied when you need to filter a unique value from data in a column. Click to choose the column and go to Data->Advanced. A pop-up window will show up. As the screenshot shows, click Copy to another location, which should be in accord with the second red rectangular area. Then specify the target location by typing the value or clicking the area-choosing button. In this example, the unique age can be generated from Column C and show in Column E. Don’t forget to choose Unique records only, then click OK. The unique value showing in column E can be the contrast of the original data in C, that’s the reason why it is recommended to copy to another location.



User Comments