Archives
May 2013
Detailed Monthly Archive
- 16: Count students
- 14: Use a map in an excel chart
- 06: SEARCH and FIND functions
- 03: Yet another excel calendar
April 2013
Detailed Monthly Archive
- 26: MMULT function – Matrix multiplication
- 23: SMALL function and LARGE function
- 19: Copy/Rename a file (excel vba)
- 17: Assign each person with randomly unique objects as a daily activity
- 15: ROW function explained
- 09: Highlight duplicates in a filtered excel defined table
- 07: COUNTIFS function
- 02: IF function explained
March 2013
Detailed Monthly Archive
- 27: COUNTIF function
- 25: Days contained in a range that overlap another range
- 20: Match function
- 15: Index function explained
- 13: Custom data labels in a chart
- 08: Change picture (vba)
- 05: Heat map calendar
- 01: Lookup using multiple conditions
February 2013
Detailed Monthly Archive
- 27: Substitute multiple text strings (vba)
- 25: Sort cell values in corresponding columns
- 18: Count multiple text strings in a cell range
- 15: Move a shape (vba)
- 11: Sort a table with an array formula
- 06: 2012 website statistics
- 04: No more array formulas?
- 01: Dynamic data labels in a chart
January 2013
Detailed Monthly Archive
- 29: Highlight a column in a stacked column chart
- 25: Highlight events in a calendar
- 24: Highlight a bar in a chart
- 18: Repeat values
- 15: Merge two related tables
- 11: Highlight events overlapping federal holidays
- 07: Lookup multiple values in one cell (vba)
- 03: Sum security holdings monthly and yearly in a pivot table
December 2012
Detailed Monthly Archive
- 28: Run a macro from a drop down list (vba)
- 10: Use a drop down list to change conditional formatting
- 05: Prevent users from entering overlapping date and time ranges
November 2012
Detailed Monthly Archive
- 30: Group a number of rows together by the first column
- 29: Lookup and return multiple values from a range excluding blanks
- 22: Find date range
- 20: Find max unique value from a range that have duplicate numbers and blanks
- 13: Monthly time sheet by project
- 09: Analyze trends using pivot tables
- 07: Hide specific columns (vba)
- 05: Compare your stock portfolio with S&P500 in excel
October 2012
Detailed Monthly Archive
- 31: Use multiple conditions in Vlookup
- 26: Locate lookup values in a table [HYPERLINK]
- 23: Applying conditional formatting to related tables
- 19: Working with three related tables
- 17: Extract unique distinct values from a related table
- 15: How to use a table name in data validation lists and conditional formatting formulas
- 12: Change bar color in charts (vba)
- 10: Lookups in a related table (array formula)
- 05: Inventory consumption
- 02: Copy each sheet in active workbook to new workbooks
September 2012
Detailed Monthly Archive
- 27: Filter values that exists in all three lists
- 26: Copy excel table filter criteria (vba)
- 21: Quickly search a table using many criteria
- 17: Create name initials
- 12: Search a table and use the returning value to search another table
- 10: Use a calendar to filter a table
- 05: Excel calendar (vba)
- 03: Fetch data from another table
August 2012
Detailed Monthly Archive
- 27: Use filtered table values in a drop down list (vba)
- 22: Dynamic chart – Display values from a table row or column
- 20: How slow is ReDim Preserve?
- 17: Shift Schedule
- 15: Extract cell references from all cell ranges populated with values in a sheet
- 07: Use a mouse hovering technique to create an interactive chart
- 06: Sort values in a cell using a custom delimiter (vba)
July 2012
Detailed Monthly Archive
- 31: Count and visualize specific weekdays in a custom date range
- 27: Visualize date ranges in a calendar part 2
- 25: Quickly create links to sheets, tables, pivot tables and named ranges in a workbook
- 23: Count unique distinct values in a filtered table
- 18: Create links to all sheets in a workbook
- 14: Quickly create new sheets (vba)
- 13: Adjust stock chart axis automatically
- 05: Insert hyperlinks to all files in current folder
- 02: Match a criterion and extract multiple corresponding table headers
June 2012
Detailed Monthly Archive
- 29: Plot buy and sell points in an excel chart using two moving averages
- 27: Add buy and sell points to a stock chart
- 18: Interactive chart in excel (vba)
- 12: Highlight values within specific ranges
- 06: Sort values in a table (vba)
- 04: Normalize data, part 2
May 2012
Detailed Monthly Archive
- 28: Search two related tables simultaneously (vba)
- 23: Create comments in cells whose value is larger than the column width
- 22: Lookup multiple values in different columns and return a single value
- 21: Learn how to return values depending on udf deployment (vba)
- 19: Select a cell in a table and the chart updates automatically (vba)
- 16: Excel template: Getting Things Done (vba)
- 11: Disable autofit column widths for all pivot tables in a sheet
- 07: Vba macro: Normalize data
- 02: Date ranges: Weeks within a month
April 2012
Detailed Monthly Archive
- 30: Add values to different sheets (vba)
- 26: Add values to a table (vba)
- 23: Unique distinct records sorted by frequency
- 21: Count the number of groupings of each value
- 21: Use a drop down list to extract and concatenate unique distinct values
- 18: Add or remove a value in a drop down list
- 16: Count specific weekdays in a date range
- 10: Open excel files in a folder (vba)
- 02: Copy table design settings
March 2012
Detailed Monthly Archive
- 30: Auto populate a sheet
- 28: Search for a text string and return multiple adjacent values
- 26: Toggle a macro on/off using a button
- 23: Calculate dates in each step in a project based on a finish date
- 19: Use a drop down list to select company info in header (vba)
- 14: Automate data entry (vba)
- 12: Apply data validation lists dynamically (vba)
- 09: Workbook log (vba)
- 05: Working with formulas in conditional formatting
February 2012
Detailed Monthly Archive
- 28: How to create random numbers, text strings, dates and time values
- 26: Categorize data entry values (vba)
- 22: Dependent data validation lists in multiple rows
- 20: Holiday planner
- 13: Advanced Gantt Chart Template
- 10: Auto resize columns as you type
- 07: Search with conditional formatting
January 2012
Detailed Monthly Archive
- 31: Tracking calls in excel
- 27: Free School Schedule Template
- 24: Copy a cell range whose size is likely to change from time to time (vba)
- 20: Easily identify groups of duplicate rows
- 17: List all open workbooks and corresponding sheets (vba)
- 14: Basic data entry (vba)
- 09: List all tables and corresponding headers in a workbook (vba)
- 02: Basic invoice template in excel
December 2011
Detailed Monthly Archive
- 23: Filter weeks from a date range
- 21: Working with combo boxes (Form Control) using vba
- 09: Excel charts: Multiple series and named ranges
- 07: Use a drop down list to search and return multiple values
- 02: Change chart data range using a drop down list (vba)
November 2011
Detailed Monthly Archive
- 29: Change pivot table data source using a drop down list
- 24: How many of a specific weekday falls between a start date and an end date except holidays
- 17: Separate numbers from a text string
- 11: Select numbers in each permutation
- 08: Dynamic Gantt charts in excel 2007
- 04: Excel vba: Filter a table using the selection change event
- 02: Extract unique distinct values from a filtered table (udf and array formula)
October 2011
Detailed Monthly Archive
- 28: Zen archery problem
- 24: Excel vba: Populate a combobox with values from a pivot table
- 19: Excel array formula: Enter a value in a cell and instantly populate adjacent cells
- 17: Excel: Look for values containing a lookup value and return multiple values horizontally
- 12: Copy selected rows (checkboxes) (2/2)
- 10: Excel vba: Add checkboxes to a sheet (1/2)
- 06: Excel: List intervals between two values
- 05: Add values to a data validation list (vba)
September 2011
Detailed Monthly Archive
- 29: Follow hyperlinks in a pivot table
- 20: List five smallest numbers, excluding zeros
- 16: Quickly filter a column in an excel table
- 14: Excel udf: Reorganize data
- 12: Populate a list box with visible unique values from an excel table (vba)
- 07: Excel vba: Populate a combo box (form control)
August 2011
Detailed Monthly Archive
- 31: Excel table: Filter unique distinct rows and use additional filters at the same time
- 26: Excel table: Filter unique distinct values (array formula)
- 25: Count unique distinct values in a large dataset with a date criterion
- 23: Excel udf: Looking up data in multiple cross reference tables
- 19: Count entries between date and time criteria in excel
- 18: Vlookup visible data in a table and return multiple values in excel
- 15: Compare two tables in excel: Remove common rows
- 13: Excel 2007 vba: Create a custom-made item on the shortcut menu
- 09: Excel udf: Sumif across multiple sheets
- 05: Insert rows for missing values in excel
- 03: Excel vba: Select cell A1 on all sheets before you close a workbook
- 01: Filter unique distinct and duplicate values from a large data set in excel 2007
July 2011
Detailed Monthly Archive
- 28: Excel 2007/2010 array formula: Filter unique distinct values, sorted and blanks removed
- 27: Excel udf: Import historical stock prices from yahoo – added features
- 22: How to sort a table in a custom order in excel
- 17: Vlookup across multiple sheets in excel
- 12: Count unique distinct values that meet multiple criteria in excel
- 08: Excel udf: Import historical stock prices from yahoo
- 04: Sum the cells in a range that meet multiple criteria in excel
June 2011
Detailed Monthly Archive
- 30: Identify duplicate files in excel
- 29: Excel recursive udf: List files in a folder and subfolders
- 22: Vlookup a range in excel
- 20: Count unique distinct values in a pivot table in excel
- 17: Merge matching rows in excel (text values)
- 16: Excel toolbox: Save your custom functions and macros in an Add-In
- 13: Auto refresh a pivot table in excel
- 09: Date ranges for 7 days in excel
- 07: Lookup with multiple criteria and display multiple unique search results (array formula)
- 02: Compare pricelists in excel 2007
- 01: Quickly compare two tables in excel 2007
May 2011
Detailed Monthly Archive
- 25: Excel 2007 pivot table: Count unique distinct records (rows)
- 24: Sum unique distinct invoices in excel 2007
- 23: Count unique distinct records with a date and column criteria in excel 2007
- 20: Google spreadsheets: Pivot tables
- 19: Filter unique distinct records with a condition in excel 2007
- 17: Excel charts: Use dynamic ranges to add new values to both chart and drop down list
- 13: Vlookup – Return multiple unique distinct values in excel
- 10: Chandoo’s excel VBA classes are now open!
- 09: Calculate average of last 10 data (possible blanks) in excel
- 06: Excel udf: Filter unique distinct records (case sensitive)
- 03: Excel udf: Filter unique distinct values (case sensitive)
- 01: Excel vba: Create dynamic conditional formatting
April 2011
Detailed Monthly Archive
- 28: Create a dynamic named range in excel
- 26: How to create a dynamic pivot table and refresh automatically in excel
- 21: Excel udf: Combine cell ranges into a single range while eliminating blanks
- 19: Bill reminder in excel
- 17: Dependent drop down lists – Enable/Disable selection filter
- 12: Running totals within date range in excel
- 06: How to quickly compare pricelists in excel
- 05: Excel udf: Word frequency
- 04: Excel udf: Fuzzy lookups
March 2011
Detailed Monthly Archive
- 28: Filter records within two dates and search for a text string in excel
- 24: Fuzzy vlookup (excel array formula)
- 23: Text to columns: Split words in a cell (excel array formula)
- 21: Quickly highlight records containing text strings in excel (AND Logic)
- 16: Excel udf: Filter emails from an excel range
- 12: Quickly highlight records in a list in excel (AND logic)
- 09: Quickly highlight records in a list using multiple criteria in excel
- 07: Cash drawer bill extractor template in excel
- 03: Find duplicate records in excel 2007
- 02: Highlight closest value in excel
February 2011
Detailed Monthly Archive
- 27: Merge matching rows in excel
- 25: Excel udf: Find positive and negative amounts that net to zero
- 22: Excel udf: Find numbers in sum
- 16: Filter overlapping date ranges in excel 2007
- 15: Count digits and ignore duplicates in any line in excel
- 09: Concatenate a cell range without vba in excel
- 08: Tracking a stock portfolio #2 in excel
- 03: Excel udf: List permutations without repetition
January 2011
Detailed Monthly Archive
- 31: Tracking a stock portfolio in excel (auto update)
- 29: Create a drop down calendar in excel
- 26: Weekly appointment calendar in excel
- 24: Monthly calendar template #2 in excel
- 19: Monthly calendar template in excel
- 17: Count unique distinct records in excel 2007
- 13: Compare two lists of data: Filter records existing in only one list in excel
- 12: Compare two lists of data: Highlight records existing in only one list in excel
- 11: Compare two lists of data: Highlight common records in excel
- 08: Compare two lists of data: Filter common row records in excel
- 04: Filter and highlight duplicate column records in excel 2007
- 03: Filter duplicate rows in excel 2007
December 2010
Detailed Monthly Archive
- 30: Highlight duplicate rows in excel 2007
- 30: Excel udf: List permutations with repetition
- 22: Count matching cells in date range in excel
- 20: Excel udf: Lookup and return multiple values concatenated into one cell
- 15: Automate excel: Update list with new values
- 13: Excel vba: Use text qualifiers to make text to columns conversion easier
- 10: Excel vba: Create a Print button
- 09: Excel vba:Select and view invoice
- 06: Excel vba: Populate listbox with unique invoice numbers
- 03: Excel vba: Edit invoice data
- 01: Excel vba: Save invoice data
November 2010
Detailed Monthly Archive
- 28: Invoice template with dependent drop down lists in excel
- 26: Create random dates, Mon to Fri, within a year in excel
- 22: Return multiple matches with wildcard vlookup in excel
- 16: Create dependent drop down lists containing unique distinct values in multiple rows
- 15: Excel udf: Filter values existing only in one out of two ranges
- 12: Excel udf: Filter common values between two cell ranges in excel
- 11: Excel vba: Select value based on time and date
- 09: Excel udf:Filter duplicates in a large dataset in excel
- 08: Compare and filter values between two lists in excel
- 03: Select 6 unique and random numbers from 1 to 49 (Lottery) in excel
- 02: Generate list of random dates with criterion in excel
- 01: Remove duplicate text strings based on the 4 last characters in a cell in excel
October 2010
Detailed Monthly Archive
- 28: Apply dependent combo box selections to a filter in excel 2007
- 26: Create a drop down list containing alphabetically sorted values in excel
- 22: Excel udf: Count unique distinct values in a large dataset
- 20: List people with the highest scores based on criteria in a pivot table (Excel 2007)
- 18: List people with the highest scores based on criteria in excel
- 17: Remove duplicates and sort dates by each row in excel
- 16: Excel udf: Remove duplicates from a large dataset
- 12: Sort a list in random order in excel
- 10: Create a random playlist in excel – True round-robin tournament
- 09: Highlight duplicate values and overlapping dates in excel
- 07: Dynamic team generator in excel
- 05: Create a random playlist in excel
September 2010
Detailed Monthly Archive
- 30: Team Generator in excel
- 28: Count records between two dates with multiple parameters in excel
- 26: Sort values in parallel in excel, part 2
- 24: Random row from a boolean matrix in excel
- 22: Search case sensitive and return multiple values in excel
- 21: Filter unique words from a range in excel (udf)
- 19: Vlookup with multiple matches returns a different value in excel
- 15: Filter unique distinct words from a cell range in excel (udf)
- 12: Filter duplicate words from a cell range in excel (udf)
- 10: User defined function to split words in a cell range into a cell each in excel
- 06: Consolidate sheets in excel, part 2
- 03: Extract a unique distinct list by matching items that meet a criterion in excel 2007 using pivot table
- 01: Extract a unique distinct list by matching items that meet a criterion in excel
August 2010
Detailed Monthly Archive
- 31: Extract dates from a cell block schedule in excel, part 3
- 30: Extract dates from a cell block schedule in excel, part 2
- 29: Extract dates from a cell block schedule in excel
- 23: Concatenate cell values in excel
- 20: Filter emails spread over several columns in excel
- 16: Search for a cell in a table and then display the column title in excel
- 15: Schedule recurring events in a weekly schedule in excel
- 08: Setting up your work hours in a weekly schedule in excel
- 05: Populate cells dynamically in a weekly schedule in excel
- 01: How to filter numbers inside (and outside) number ranges in excel
July 2010
Detailed Monthly Archive
- 29: Find empty hours in a weekly schedule in excel
- 26: Count cell blocks in excel
- 21: Schedule recurring expenses in a calendar in excel (Personal Finance)
- 17: Create dependent drop down lists containing unique distinct values in excel
- 13: Count overlapping dates in excel
- 11: Create a unique distinct sorted list containing both numbers text removing blanks in excel
- 08: Filter overlapping dates from date ranges in excel
- 04: Highlight specific time ranges in a weekly schedule in excel
- 01: Weekly schedule template in excel
June 2010
Detailed Monthly Archive
- 28: Convert date ranges into dates in excel
- 22: Convert dates into date ranges in excel
- 20: List dates outside specified date ranges in excel
- 14: Visualize date ranges in a calendar in excel
- 10: Absolute and relative references in excel
- 03: Highlight overlapping date ranges using conditional formatting in excel
May 2010
Detailed Monthly Archive
- 30: Find overlapping date ranges in excel
- 25: Use a number range when trying to find the frequency of a number in excel
- 22: How to return the total for orders with more than one item in excel
- 18: Merge two columns with possible blank cells in excel (formula)
- 16: Count unique and duplicates text values in a closed workbook in excel (formula)
- 12: Extracting unique distinct text values from a closed workbook in excel (formula)
- 11: Count unique and duplicate numbers from a closed workbook in excel (formula)
- 10: Extract unique distinct numbers from closed workbook in excel (formula)
- 05: List all the unique events for a month in excel (array formula)
- 02: Sort numeric values by closest to farthest to a specific number in excel (array formula)
April 2010
Detailed Monthly Archive
- 28: How to quickly select a large non contiguous range with keyboard in excel
- 24: Highlight duplicates on same date, week or month using conditional formatting in excel
- 19: Filter duplicates within same date, week or month in excel
- 17: Count unique distinct values within same week, month or year in excel
- 15: How to count unique distinct occurrences for each date in excel
- 13: Remove duplicates within same month or year in excel
- 13: Remove duplicates in same week in excel
- 12: Remove duplicates on same date in excel
- 07: Lookup values in a range using two or more criteria and return multiple matches in excel, part 2
- 05: Explaining a formula: Lookup values in a range using two or more criteria and return multiple matches in excel
March 2010
Detailed Monthly Archive
- 31: Calculate your stock portfolio performance with Net Asset Value based on units in excel
- 29: Consolidate sheets in excel (vba)
- 24: Lookup using two criteria in excel
- 22: Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel
- 18: Calculate your stock portfolio performance in excel
- 15: Pass multiple conditions dynamically in excel
- 11: Categorize values into multiple columns (excel formulas)
- 10: Categorize values into multiple columns using vba in excel
- 07: Count unique distinct numbers across multiple sheets (3D range) in excel
- 04: Return unique and duplicate numerical data entries from multiple sheets (3D range) in excel
- 03: Split data across multiple sheets in excel (vba)
February 2010
Detailed Monthly Archive
- 28: Combine data from multiple sheets in excel
- 26: Calendar with scheduling in excel 2007 (vba)
- 21: Dynamic stock chart in excel – Add date ranges
- 18: Create unique distinct year and months from a long date listing in excel
- 16: Create a dynamic stock chart using a web query and a drop down list in excel
- 11: Match two criteria and return multiple rows in excel
- 10: Create a unique distinct list of a long list without sacrificing performance using vba in excel
- 07: Scan stock markets in excel
- 02: Extract negative values and adjacent cells in excel
January 2010
Detailed Monthly Archive
- 30: Stock alerts in excel
- 27: Quickly select a range of values in excel
- 24: Create number sequences in excel 2007
- 20: Excel formula to count cells between two values
- 19: Return multiple values if above frequency criterion in excel
- 16: Filter unique distinct values using “contain” condition of a column in excel
- 14: Return multiple values if in range in excel
- 13: Return value if in range in excel
- 12: Sort values in parallel (array formula)
- 10: Vlookup of three columns to pull a single record
- 08: Using Excel Solver to schedule employees
- 07: Find positive and negative amounts that net to zero in excel
- 05: Identify numbers in sum using solver in excel
- 04: Sequencing and numbering of batches in excel
- 03: Sum adjacent values from a range using multiple lookup values in excel
- 03: Lookup values in a range using two or more criteria and return multiple matches in excel
December 2009
Detailed Monthly Archive
- 31: Sum adjacent values using multiple lookup text values in a column in excel
- 29: Vlookup with 2 or more lookup criteria and return multiple matches in excel
- 27: Filter duplicate values in a range using “contain” condition in excel
- 23: Filter unique text values in a range using “contain” condition in excel
- 21: Filter unique distinct text values in a range using “contain” condition in excel
- 17: Filter duplicate text values in a range using “begins with” criterion in excel
- 17: Filter unique text values using “begins with” criterion in a range in excel
- 14: Filter unique distinct text values using “begins with” criterion in a range using array formula in excel
- 13: Formula for matching a date within a date range in excel
- 10: Count unique values in two lists combined in excel
- 10: Count matching values in one or more columns in excel
- 07: Find records using two numerical criteria in excel
- 05: Lookup a value and find max date in excel
- 04: Filter unique distinct values where adjacent cells contain search string in excel
- 02: Validate duplicates in excel
November 2009
Detailed Monthly Archive
- 30: Validate unique distinct list in excel
- 30: Validate unique list in excel
- 26: Sum values in a range where adjacent cell value equals a criterion in excel
- 25: Search for multiple text strings in multiple cells and use in data validation in excel
- 23: Highlight odd/even months using conditional formatting in excel 2007
- 22: Lookup a value in a list and return multiple matches in excel
- 21: How to calculate missing months in a given date range in excel
- 18: Count date records between two dates in a range in excel
- 16: Sum values between two dates with criteria in excel
- 15: Most common value between two dates in a range in excel
- 14: Most common value between two dates in excel
- 14: Count unique distinct values using date criteria in a range in excel
- 12: Largest value in a range using date criteria in excel
- 11: Lookup min max values within a date range in excel
- 09: Lookup two index columns using min max values and a date range as criteria
- 08: Lookup two index columns returning multiple matches in excel
- 07: Text to be on top of column in excel
- 07: Lookup two index columns in excel
- 04: Count matching cell values in two columns in excel
- 04: Create a custom date range in excel
- 02: Create a quartely date range in excel
- 01: Create a monthly date range in excel
- 01: Extract unique values from a range using array formula in excel
October 2009
Detailed Monthly Archive
- 29: Count unique text values in a range containing both numerical and text values
- 26: Extract and sort text cells from a range containing both numerical and text values
- 25: How to return multiple values using vlookup in excel
- 23: Extract cell values in a range using a criterion in excel
- 20: Filter common text values in range 1 and in range 2 using array formula in excel
- 19: Filter text values existing in range 1 but not in range 2 using array formula in excel
- 17: Filter unique distinct list sorted based on sum of adjacent values using array formula in excel
- 15: Filter unique values from a range using array formula in excel
- 13: Filter a column and create a new unique list sorted from A to Z using array formula in excel
- 12: Filter unique text values from a range containing both numerical and text values in excel
- 10: Extract duplicate text values from a range containing both numerical and text values in excel
- 09: Extract dates and adjacent value in a range using a date critera in excel
- 07: Create a list with most recent data available in excel
- 05: Count unique distinct text values in a range in excel
- 04: Create a unique distinct text list from a range containing both numerical and text values in excel
- 02: Website optimization
- 01: Lookup with multiple criteria and display multiple search results using excel formula, part 4
September 2009
Detailed Monthly Archive
- 29: Extract numbers and text from a range using array formula in excel
- 28: Extract all rows from a range that meet criteria in one column in excel
- 28: Identify largest text value in a column using array formula in excel
- 27: Sort text values by length using array formula in excel
- 26: Create unique distinct list sorted based on text length using array formula in excel
- 24: Unique distinct list sorted based on occurrance in a column in excel
- 22: Unique distinct list from a column sorted A to Z using array formula in excel
- 20: Identify missing numbers in a range in excel
- 18: Create a list of all numbers or text in a column in excel
- 16: Extract a unique distinct list sorted alphabetically removing blanks from a range in excel
- 15: Count unique distinct records in a date range and a numeric range in excel
- 14: Create a list of dates with blanks between quarters in excel
- 13: Count unique records between two dates in excel
- 09: Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel part 2
- 08: How to highlight max and min value in every month in excel
- 06: Count unique distinct months in excel
- 04: Identify missing three character alpha code numbers in excel
- 02: Filter duplicates from two columns combined and sort from A to Z using array formula in excel
August 2009
Detailed Monthly Archive
- 31: Min and max unique and duplicate values using array formula in excel
- 30: Count duplicate distinct values in a column in excel
- 29: Reverse a list ignoring blanks in excel
- 26: List names whos date has past in excel
- 26: Calculate occurences the past 90 days in excel
- 24: Search and display all cells that contain all search strings in excel
- 23: Sum text cells using criteria in excel
- 21: Highlight more than once taken online course in any given day in excel
- 19: Sort a range by occurence using array formula in excel
- 17: Comparing two columns and sum unique values using array formula in excel
- 16: Search and display a range of values in excel
- 13: Lookup with multiple criteria and display multiple search results using excel formula, part 3
- 12: Filter common values between two ranges using array formula in excel
- 12: Filter values existing in range 1 but not in range 2 using array formula in excel
- 10: Filter common values from three columns in excel
- 09: Filter unique distinct values from two ranges combined in excel 2007
- 06: Filter duplicate rows and sort by date using array formula in excel
- 05: Filter unique rows and sort by date using array formula in excel
- 04: Advanced custom date filter in Excel 2007
- 02: How to filter values between 0.5 and 1.5 from two columns in excel 2007
- 01: Sort a range from A to Z using array formula in excel
July 2009
Detailed Monthly Archive
- 30: Highlight unique distinct values in two ranges combined using conditional formatting in excel
- 28: Extract a unique distinct list sorted from A-Z from range in excel
- 26: Highlight duplicate values in two ranges combined using conditional formatting in excel
- 25: Exact word in string without using vba in excel
- 23: Highlight smallest duplicate value in a column using conditional formatting in excel
- 21: Extract a list of alphabetically sorted duplicates from a column in excel
- 20: Highlight duplicate values in a range using conditional formatting in excel
- 19: Highlight unique values and unique distinct values in a range using conditional formatting in excel
- 17: Extract largest values from two columns using array formula in excel
- 15: Search for multiple text strings in multiple cells in excel, part 2
- 14: Count unique values and unique distinct values in three ranges combined in excel
- 13: Extract duplicates from a range using excel array formula
- 11: Count unique values and unique distinct values in two ranges combined
- 11: Count occurences of a specific text string in a column in excel
- 09: Search for a text string in an excel table
- 09: Search for a cell value in an excel table
- 07: Count unique and unique distinct values in a multicolumn range in excel
- 06: Count text that occurs multiple times in excel cell
- 05: Count unique distinct values in two columns with date criteria in excel
- 03: How to create a list of random unique numbers in excel
- 03: Web statistics and most popular articles in June
- 01: Sort text cells alphabetically from two columns using excel array formula
June 2009
Detailed Monthly Archive
- 29: Merge two columns into one list in excel
- 28: Merge three columns into one list in excel
- 27: How to create a unique distinct list where other columns meet two criteria
- 25: Sum only if unique value in another column in excel
- 24: Looking up data in a cross reference table in excel
- 23: Extract a list of duplicates from three columns combined using array formula in excel
- 22: Extract a list of duplicates from a column using array formula
- 22: Extract a list of duplicates from two columns combined using array formula in excel
- 21: Lookup with multiple criteria and display multiple search results using excel formula, part 2
- 20: Extract a unique distinct list from three columns in excel
- 16: Extract a unique distinct list from two columns using excel 2007 array formula
- 16: Create a date range using excel formula
- 15: Identify missing values in two columns using excel formula
- 13: Identify missing values in a column using excel formula
- 11: Count unique distinct values in three columns combined in excel
- 10: Count unique distinct values in two columns in excel
- 09: Count unique distinct values in a column in excel
- 08: Most popular excel articles in May
- 06: Sorting numbers and text cells descending also removing blanks using array formula in excel
- 06: Sorting numbers and text cells also removing blanks using array formula in excel
- 04: Highlight the second or more duplicates in two lists using conditional formatting in excel
- 03: Highlight common values in two lists using conditional formatting in excel
- 02: Sort dates within a date range using excel array formula
May 2009
Detailed Monthly Archive
- 31: Extract dates using a drop down list in excel
- 31: Extract distinct unique sorted year and month list from a date series in excel
- 27: Create a dynamic border to your list using excel conditional formatting
- 26: Split values equally into groups using excel array formula
- 25: Create a drop down list containing only unique distinct alphabetically sorted text values using excel array formula
- 22: Find the largest number in a dynamic column using excel formula
- 21: Lookup between two lists of data to highlight missing data using conditional formatting in excel
- 20: Highlight duplicates using conditional formatting in excel
- 19: How to filter out every second row using excel formula
- 18: Finding the nearest date in a range of dates using excel formula
- 17: Color every second row using conditional formatting in excel
- 17: Prevent duplicates using dynamic conditional formatting in excel
- 14: Lookup with multiple criteria and display multiple search results using excel formula
- 13: Highlight duplicates where an adjacent column is in a date interval using conditional formatting in excel
- 12: Create a unique distinct list from a date range in excel
- 10: Highlight dates within a date range using conditional formatting
- 09: Create a repeating list of numbers from 1 to Nth value
- 08: Identify duplicate invoice records using conditional formatting in excel
- 07: Identify duplicate invoice records in excel
- 06: How to color every cell in excel
- 05: Invert a list using named ranges
- 04: Invert a list using cell references in excel
- 03: Unique list to be created from a column where an adjacent column has text cell values
- 03: Create a list of distinct values from a list where an adjacent cell value meets a criteria in excel
- 01: Create a list of duplicates where adjacent cell value meets a condition in excel
April 2009
Detailed Monthly Archive
- 30: Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel
- 28: Group similar cell values on same row in excel
- 26: How to rank uniquely with criteria in excel
- 25: How to rank text uniquely in excel
- 24: Create a unique distinct list and sort by occurrances from large to small
- 23: How to create an array of uniquely ranked duplicate values in excel
- 21: Search for multiple text strings in multiple cells in excel
- 20: Sum unique values in excel
- 19: How to create a unique list using conditional formatting in excel 2007
- 17: Create and sort distinct list by adjacent cell value size
- 16: Create unique distinct list from column where an adjacent column meets criteria
- 15: Insert a new row at the top every time a value has been entered
- 14: Create a unique distinct alphabetically sorted list, extracted from a column in excel
- 13: Max or min out of two columns
- 11: How to automatically fill all blanks with missing data or formula
- 10: Create unique list from two columns
- 08: Merge two lists
- 07: Sorting date ranges in excel
- 06: Conditional formatting highlights more than 10 if there are duplicates
- 05: Determine the sum between a range of dates for a specific currency
- 04: Sort cell values into categories, part 2
- 03: Sort cell values into categories
- 02: Count records between two dates in excel
- 01: Split first and last names in excel and then sort them alphabetically
March 2009
Detailed Monthly Archive
- 31: How to extract a list of duplicates from a column in excel
- 30: How to extract a unique distinct list from a column in excel
- 29: Return row reference of largest to smallest
- 28: Next upcoming date from list
- 27: Sorting text cells using array formula in excel
- 26: How to sort text cells filtered by two dates, part 2
- 25: Extract all rows that contain a value between this and that
- 24: How to sort cells filtered by two dates
- 23: How to find out if a number is between two dates
- 20: Delete blanks and errors in a list
- 19: Search three columns on three sheets, part 2
- 18: Search three columns on three sheets
- 17: Find missing numbers in a range from multiple columns
- 16: Unique distinct values from multiple columns using array formula
- 13: Count number of times a string exist in multiple cells using excel formula
- 12: A more userfriendly version of: Automatically filter unique row records from multiple columns
- 11: Excel 2007: Calculate machine utilization
- 10: How to automatically create a unique distinct list and remove blanks
- 09: Filter records between two dates
- 06: How to count unique distinct records in a date range
- 05: How many common cell values are there in list 1 and 2?
- 04: How to automatically calculate a specific day of a month
- 03: Excel template: School attendance register
- 02: merge two sheets with array formula
February 2009
Detailed Monthly Archive
- 27: How to remove common values between two columns
- 25: excel find weekday in period
- 23: Categorize numbers in excel
- 20: How to identify two consecutive dates in a list
- 18: How to find duplicates in a range spanning multiple columns?
- 16: Finding values in an excel list
- 13: How to find common values from two lists
- 12: How to navigate quickly in a complex excel workbook using hyperlinks
- 09: Coordinates of cells that are not empty in a range
- 07: Get data from same cell references of every sheet in workbook
- 05: Excel 2007: How do i remove errors from a cell formula?
- 03: How to count unique combined column values
- 02: Lookup Unique based on Multiple Conditions
January 2009
Detailed Monthly Archive
- 31: Array formula to look up a value and return multiple values in excel
- 30: How to extract email addresses from a excel sheet
- 29: How to sum different rates with a date criteria
- 15: How to create a useful search formula
- 14: Filter unique distinct row records in excel 2007
- 13: What values are missing in List 1 that exists i List 2?
- 13: Multiple cells in a new row
- 12: Extract duplicates and their adjacent values
December 2008
Detailed Monthly Archive
November 2008
Detailed Monthly Archive
May 2008
Detailed Monthly Archive
April 2008
Detailed Monthly Archive
- 23: Excel: How to automatically summarize preceding month and year
- 09: Search and replace with formatted words
- 08: How to efficiently summarize data by category and month
March 2008
Detailed Monthly Archive
February 2008
Detailed Monthly Archive
January 2008
Detailed Monthly Archive
- 17: Excel: Efficiently navigate cells and do fast selections
- 16: Windows xp: Remove unsigned driver warning message
- 15: Internet explorer 7: Powerful timesaving keyboard shortcuts
- 11: Excel: Count cells
- 08: Windows xp: How to find out physical memory
- 08: Enable “File and printer sharing” in windows xp firewall
December 2007
Detailed Monthly Archive
- 17: Windows xp: How to include network drives into your filesearch
- 17: Windows xp: How to search for multiple filenames at once
- 11: Excel: How to evaluate a complex formula
- 10: Excel: Create a random list of specific text values
- 10: Excel: Find the smallest difference between the two closest values
- 07: Excel: Dynamic summation through numeric named sheets
- 05: Windows xp: Modify default search settings
- 05: Excel: Find closest value
- 05: Windows xp: How to disable passport balloon notification
- 04: Outlook 2007: How to hide Outlook in system tray
- 04: Excel: Vlookup with text and date formatting
- 04: Excel: Average but exclude zeros
- 03: Excel: Percentage of total number
- 03: Excel: Using lookup to categorize numbers
- 01: Office: Display all commands in menu
November 2007
Detailed Monthly Archive
- 30: Windows xp: How to manually delete index.dat files
- 30: Windows xp: How to remove an unwanted background
- 30: Windows xp: How to disable screensaver at welcome screen
- 30: Windows xp home: How to disable simple filesharing
- 29: Windows xp: Make your user subfolders private
- 29: Windows xp: Enable filesharing on network
- 29: Windows xp: Disable file and printer sharing for network
- 28: Windows xp: Edit registry to use classic logon
- 28: Windows xp: How to hide a user account on welcome screen
- 27: Excel 2007: Color unique values using conditional formatting
- 27: Excel 2007: Color cells that meet criteria using conditional formatting
- 23: Windows Media Center 2005: Backup series and settings data
- 23: Excel 2007: Create a template and save time
- 22: Windows media center 2005: Keyboard shortcuts
- 20: Excel: Remove rows containing specific dates
- 20: Software: Can your computer run that game?
- 20: Windows Media Center 2005: Fix Low Volume output through spdif
- 19: Windows xp: Hide desktop icons
- 19: Windows xp: How to customize notification area
- 19: Windows xp: How to increase icon font size on desktop
- 19: Windows xp: How to avoid users from using task manager
- 19: Windows xp: Force applications to exit without user intervention at shutdown
- 19: Windows xp: How to disable a cd/dvd
- 19: Excel 2007: Delete duplicate cell values
- 15: Windows xp: How to turn off windows animation
- 15: Windows xp: How to remove balloon tips in notification area
- 15: Excel: Dynamic charting with drop list
- 14: Excel: How to rank by two columns
- 14: Windows xp: Force mouse pointer to jump to default button of any window that opens
- 14: Windows xp: How to show Internet Explorer icon on desktop
- 13: Internet Explorer: Change default download folder
- 12: Windows xp: What updates, hotfixes and patches are installed on your computer
- 12: Windows xp: How to find out what process makes your computer slow
- 12: Excel and Word 2007: Increase workspace by minimizing the ribbon
- 10: Outlook Express: Remove messenger from being started in outlook express
- 10: Windows media player: Remove update notification
- 10: Windows xp: How to exclude a program permanently from most frequently used programs on start menu
- 10: Windows xp: Do not save desktop settings on exit
- 09: Excel 2007: How to freeze first row/column and scroll the others
- 09: Excel: Add screentip to your hyperlink
- 08: Windows xp: Folder customizations are incorrect
- 08: Excel: Regional settings
- 07: Excel 2007: How to find errors in a large sheet
- 07: Excel 2007: How to not display the formula in the formula bar
- 05: Excel: How to invert a list
- 05: Excel: Dynamically sum a column
- 05: Windows xp: How to turn off system sounds
- 05: Windows xp: How to turn off “My recent documents”
- 04: How to change owner and organization
- 04: Windows xp: How to burn a data cd/dvd in windows explorer
- 03: Microsoft Office 2003/2007: How to turn on/off clipboard
- 03: Excel 2007: How to create a dynamic chart
- 02: Windows xp: Change hard disk icons, visible in windows explorer
- 01: Windows media center 2005: How to adjust sound volume when using spdif
- 01: Excel: How to remove spaces
- 01: ‘Windows xp: Change word start in start button
- 01: Excel: Count rows between two values in a list
October 2007
Detailed Monthly Archive
- 31: Windows xp: Delete faulty entries in Add/Remove Programs
- 30: Excel: Notify if expired
- 29: Windows xp: How to uninstall Windows Picture and Fax Viewer
- 28: How to show status bar in windows explorer and internet explorer
- 28: Excel: Holidays and networkdays
- 28: Windows xp: Show content in system folder
- 28: Windows xp: How to scale and move taskbar
- 27: Windows xp: Restore values by looking at registry template
- 27: Windows xp: Change the way windows explorer displays uppercase files
- 26: Internet Explorer: Change font
- 26: Excel 2007: Collect unique values from several columns
- 24: Excel: Upcoming date
- 24: How to remove windows xp built-in zip support
- 23: Windows xp: How to run a program as an other user
- 23: Windows xp: Create shortcut to open a folder with windows explorer
- 22: Windows xp: Start your favourite programs fast
- 22: Excel: Count the number of a specific weekday in a range
- 21: Outlook Express: How to remove cleartype
- 21: Internet Explorer: Open multiple websites with one click
- 21: Internet Explorer: Create website thumbnails
- 20: Internet Explorer: Fastest way to open a website
- 19: Internet Explorer: Sort website favourites
- 19: Internet Explorer: Multiple startpages
- 18: How to start windows xp faster
- 18: Windows xp: Change default program installation folder
- 17: Windows xp: How to use your computer on daily basis with user accounts
- 17: How to save usernames and passwords on forms in Internet Explorer
- 16: Windows xp: How to remove low diskspace notification
- 16: Windows xp: How to change appearance of task manager
- 15: Windows xp: Configure system to show “blue screen of death” or a system restart
- 15: Windows xp: Disable windows from reading media info in windows explorer
- 15: Windows xp: Search window opens when doubleclicking on folder in windows explorer
- 14: Internet Explorer: Download webpages for offline viewing
- 13: Excel: Select only visible cells
- 13: Excel: How to convert to hexadecimal
- 12: Troubleshoot with event viewer
- 12: Windows xp restarts or hangs while loading
- 12: Windows xp: Recommended hardware
- 11: Windows xp: Customize shortcut icon with no arrow
- 11: Internet Explorer: Change window header title
- 10: Internet Explorer: Change icons on links field
- 10: Windows xp: Identify processes in command prompt
- 09: Windows xp: Copy and move files faster in windows explorer
- 09: Create shortcut to connect faster to remote computer
- 08: Remote assistance with several computers connected to a router
- 08: Windows xp: Remote assistance
- 07: Windows xp: How to create a shortcut to lock your computer
- 07: Windows xp: How to find out your computer name
- 07: Windows xp: How to abort going into hibernation
- 06: How to automatically download pictures from Canon camera
- 06: Disable preview image of avi file
- 06: Excel: Count time
- 05: Windows xp: How to turn off CD autorun
- 05: How to identify codec required to play an avi file
- 04: Windows xp: How to use mouse pointer without mouse
- 04: Excel 2007: How to install analysis toolpack
- 03: Find out your ip address
- 03: Firefox: Uninstall or block Macromedia Flash
- 02: Windows xp: On screen keyboard
- 02: Google: How to search a forum
- 01: Win xp: Remove highlight of newly installed programs
September 2007
Detailed Monthly Archive
- 30: Win xp: Create a secure ssh tunnel with putty to a linux server
- 29: Windows xp: Customize “Send to”
- 28: Windows xp: Easily create a vpn
- 27: IE 7: Enable menu bar
- 26: Azureus: How to download specific files in a torrent
- 25: Win xp: Start menu in alphabetical order
- 23: Create a playlist in start menu
- 23: Win xp: Remove most used software in start menu
- 23: Autostart USB memory
- 22: Excel: Convert word address list to excel
- 21: Windows xp: Increase log in security
- 20: Word 2007: Insert comments
- 20: Firefox: Surf web faster with site keywords
- 19: WMP: Allow screensaver during music playback
- 19: Acrobat Reader: Save pdf as a text file
- 18: Win xp: Free antivirus software
- 18: Win xp: Desktop Cleanup wizard
- 17: Win xp: Show desktop items
- 17: Explaining OFFSET function
- 16: Authorize external programs
- 16: Excel: Remove blank cells
- 15: WMC 2005: Slow down DVD-ROM to quiet mode
- 15: Remove sound effects and customize video background color
- 14: Win xp: List all offline files and folders
- 14: Excel:Calculate the difference between two dates
- 13: Win xp: How to select a network folder to synchronize
- 13: Excel: Calculate last date of a specific month
- 12: Windows xp: Synchronize folders
- 12: Excel: Count the number of occurances an integer is in a list
- 11: Win xp: Make My Documents only accessible to owner
- 11: WMC 2005: How to burn tv shows on a dvd
- 10: Windows media center 2005 requirements
- 09: Excel: Convert text to integer in formula
- 09: Win xp: How to password protect a zip file
- 08: My Computer with folder list
- 08: Excel: Count unique values in a list
- 07: Excel: Count and sum values between specific ranges in a column
- 07: Customize album cover
- 06: Windows xp: How to remove notification icon when connected
- 05: Start Windows media center 2005 automatically at boot
- 05: Windows xp: How to add programs to start menu
- 04: Excel: Autosum when a row is inserted
- 04: How to remove Windows xp messenger
- 03: Update windows media center 2005
- 03: Adjust process priority in Windows task manager
- 02: How to search for hidden files in windows xp
- 02: Windows xp: How to analyze dump file
- 01: Excel: Find latest date in a list
- 01: Excel: Interactive summation
August 2007
Detailed Monthly Archive
- 31: Excel: Sum automatically specific posts in a list
- 30: Excel: Count the number of cells within a range that meet the given condition
- 30: How to capture screenshots from windows media player
- 29: Excel: Find the smallest value in a list but bigger than 10.
- 29: Excel: Automatically create a numbered list
- 29: Windows xp: Hide previous logged on user name
- 28: Automatically adjust column width in windows explorer
- 27: Windows xp: Smart search
- 27: Excel 2007:How to remove empty cells
- 25: Windows xp: One program column in start menu
- 24: Print webpage and add information to footer or header
- 23: Internet explorer: Smart and fast webnavigation
- 22: Windows vista: How to remove old win xp folders
- 21: Word 2007: Change default font to times new roman
- 20: Excel:Advanced search between two tables
- 19: Excel 2007: Find names and their references in a sheet
- 18: Windows xp: Customize taskbar and startmenu
- 17: Excel: Refer to the same cell regardless of whether the row above the cell is deleted or the cell is moved
- 16: Excel: Effectively search and replace specific characters
- 15: Are you and your computer up to Windows Vista?
- 14: Excel:Print consecutive pagenumbers from several sheets
- 13: Top list of useful wordpress plugins
- 12: How to burn wma or mp3 to a cd in windows media player
- 10: Sum a filtered column
- 09: How to create a pdf
- 08: Excel: Count cells in a specific area
- 07: Excel: Find last input value
- 06: Find largest value in a table and return adjacent cell value
- 05: Hardware: How to connect a wireless router to an existing router
- 04: Hardware: Save electricity
- 03: When and how to use hibernate and standby mode
- 02: Windows xp: Schedule shutdown
- 01: How to share Recorded tv through your home network
July 2007
Detailed Monthly Archive
- 31: Windows xp: How to print on both sides of a paper
- 30: Excel:Print headers on every page
- 29: Win xp: Deleting a file or folder:Access denied error
- 28: Outlook Express: Share adressbook
- 10: Excel:Rotate text to save space
- 09: Windows xp:How to start your computer with mouse or keyboard
- 06: Html:How to display an email address on a webpage without receiving spam
- 04: Create a webpage within word 2007
- 04: Get a better overview within word 2007 and excel 2007
- 04: Windows xp:How to enable an alarm sound when Caps Lock is activiated
June 2007
Detailed Monthly Archive
April 2007
Detailed Monthly Archive
- 22: How to: Optimize USB flash drive for quick removal
- 09: Prevent background colors and images from printing
- 03: How to turn off Windows xp indexing service
- 01: How to turn off AutoComplete function in Internet Explorer
February 2007
Detailed Monthly Archive
January 2007
Detailed Monthly Archive
- 30: Disable thumbnail file “thumbs.db” being created
- 29: How to automatically clear pagefile.sys when shutting down your computer
- 26: Excel 2003: How to format numbers as text
- 23: Let Azureus monitor a folder and automatically import torrents
- 22: How to sort program list alphabetically in start menu
- 19: How to configure windows media player on top of other windows
- 18: How to configure start menu links
- 17: How to get the classic start menu in windows xp
- 16: Open submenus when i pause on them with my mouse
- 15: Delete files without moving them to recycle bin
- 12: How to find out your windows xp
- 11: How to automatically delete temporary internet files in Internet Explorer 6 browser
- 10: How to restore Outlook Express backup
- 09: Backup Outlook Express settings and mail
- 08: Configure internet explorer cache
- 05: How to correct album artist in windows media player library
- 04: How to schedule a task to run only when computer is idle
- 03: How to backup windows xp registry
- 02: Why use Pivot table and pivot chart?
- 01: Work smarter with the Internet Explorer address bar
- 01: Components of a excel chart
December 2006
Detailed Monthly Archive
- 30: How to remove index.dat file in your temporary internet folder
- 30: Sort windows explorer files and folders in groups
- 29: Where does Windows media player save the library information?
- 28: How to search for music on your computer in windows media player
- 28: How to rate music in windows media player
- 26: Customize windows explorer details view
- 26: Quick access to recently used files
- 17: Windows xp calculator explained
- 17: How to copy command prompt text
- 13: Identify your windows dvd decoder
- 10: Why use R1C1?
- 10: Configure windows xp security alerts
- 06: Create a email shortcut on your windows xp quick launch toolbar
- 03: Rename files with one command in windows explorer
- 02: Creating transparent bars in excel 2003 and excel 2007 charts
- 02: Problem with low volume while playing a divx/xvid clip/movie with ac3 sound
November 2006
Detailed Monthly Archive
- 03: Remove email notification at welcome screen in windows xp
- 03: Speed up Windows XP start menu
- 03: Transpose a column of values to values in a row
October 2006
Detailed Monthly Archive
- 31: Shortcut to create a folder in windows xp
- 31: Powerful way to search an excel list automatically
- 09: How to: Clearing prefetch cache shortens windows xp boot time
- 08: How to convert mp3 to wave using winamp
- 02: Long icon filenames on windows xp desktop
September 2006
Detailed Monthly Archive
- 30: Remove grey labels from desktop icon text
- 28: Change thumbnail size in windows xp explorer.
- 24: Enable windows xp screensaver password
- 23: Remove windows xp error reporting
- 18: Shortcuts in windows xp
- 15: How to find duplicates in a Microsoft Excel list
- 13: Remove windows xp boot screen
- 12: How to configure windows media center autologon
- 11: Increase Windows xp performance
- 10: Remove username from windows xp start-menu
- 10: Configure Windows xp startup
- 03: Convert your windows media center files to save storage
- 01: Increase sheet readability in excel
August 2006
Detailed Monthly Archive
Plugin by GeekWithLaptop.com
