Oct 25 2009
List Unique Values from a Range
Excel has an easy built-in way to show the unique values from a list of numbers you provide. You can use it to filter a unique list of numbers, dates, strings or whatever you need to have listed.
Excel Tips and Tricks for All Levels
Categories
Excel Poll of the Week
Loading ...Category Cloud
#N/A Add Comments Auto_Open Basic Macro Cell Calculation Column Headers Concatenate Contest Count CountA CountBlank CountIf Custom Function Date Drop Down Menu Excel Formulas Excel Forum Excel Info Excel Macros Excel Version Extract Names Find Formatting HLookup Hyperlink ISBLANK ISERROR ISNA IsText Keyboard Shortcuts Large Left Length Loan Payment Calc Loops Macros or Formulas Macro Usage Match Mid Office 2010 Office Live Pivottable Protection Rank Record a Macro Right Select Whole Sheet Site Updates Small Status Bar Messages Substitute Sub vs Function Sum Across Sheets SumIf Text To Columns Today Trim Unique Values Userform Userform Attempt VLookup
Views
- Separate Full Name into First & Last Name - 20,756 views
- Using a For Loop in a Macro - 20,081 views
- Hyperlink Formula in Excel - 16,216 views
- Rank Formula in Excel - 14,079 views
- Count Rows with Data in a Macro - 12,315 views
- ISNA, ISERROR, and ISBLANK Formula in Excel - 8,288 views
- Excel Length Formula - 7,136 views
- Quick Way to Check for Duplicates in a Column - 7,066 views
- Thanks for Subscribing – Please Check Your Email - 6,337 views
- VLookup in Excel - 6,218 views