Excel - Get Digital Help

$ Excel - Get Digital Help

Get Digital Help

<a href="//pixfuture-d.openx.net/w/1.0/rc?cs=5e204d84f8&cb=INSERT_RANDOM_NUMBER_HERE" ><img src="//pixfuture-d.openx.net/w/1.0/ai?auid=538803744&cs=5e204d84f8&cb=INSERT_RANDOM_NUMBER_HERE" border="0" alt=""></a>

Get Digital Help > Excel

Archive for the ‘Excel’ Category

Subcategories

Sep.04, 2017 How to extract a case sensitive unique list from a column
Comments(0)

Category: Case sensitive, Excel, Unique values

Aug.28, 2017 Count unique distinct values based on a condition
Comments(1)

Category: Count unique distinct values, Count values, Excel

Aug.25, 2017 Lookup multiple values in different columns and return multiple values
Comments(0)

Category: Excel, VLOOKUP and return multiple values

Aug.24, 2017 Extract a list of alphabetically sorted duplicates based on a condition
Comments(1)

Category: Duplicate values, Excel

Aug.19, 2017 Extract duplicate values with exceptions
Comments(3)

Category: Duplicate values, Excel

Aug.19, 2017 Filter duplicate values using critera
Comments(0)

Category: Duplicate values, Excel

Aug.17, 2017 Concatenate cell values based on a condition [No VBA]
Comments(0)

Category: Concatenate, Excel

Aug.16, 2017 Find last value in a column
Comments(1)

Category: Excel, Lookup function

Aug.15, 2017 Unique distinct list sorted alphabetically and based on a condition
Comments(1)

Category: Excel, Sorted unique distinct values, VLOOKUP and return multiple values

Aug.15, 2017 Find last matching value in an unsorted table
Comments(0)

Category: Excel, Lookup function

Aug.11, 2017 Use VLOOKUP and return multiple values sorted from A to Z
Comments(2)

Category: Excel, Sort values, VLOOKUP and return multiple values

Aug.03, 2017 Concatenate unique distinct values
Comments(2)

Category: Concatenate, Excel, Textjoin

Jul.22, 2017 Excel SUM function
Comments(0)

Category: Excel, Functions, Sum

Jul.18, 2017 How to use the HLOOKUP function
Comments(0)

Category: Excel, Functions

Jul.11, 2017 Everything you need to know about the VLOOKUP function
Comments(1)

Category: Excel, Functions, Vlookup

Jul.07, 2017 Nested Search
Comments(1)

Category: Excel, Search/Find

Jul.06, 2017 Track progress
Comments(0)

Category: Conditional formatting, Excel

May.31, 2017 Use VLOOKUP to calculate discount percentages
Comments(1)

Category: Cross reference table, Excel, Vlookup

May.24, 2017 Count matching strings using regular expressions
Comments(1)

Category: Excel, Regular expressions, User defined functions (udf), VBA

May.16, 2017 Reverse two-way lookup in a cross reference table
Comments(4)

Category: Cross reference table, Excel

May.09, 2017 Excel map chart
Comments(1)

Category: Charts, Excel, Maps

Apr.27, 2017 Split search value using delimiter and search for each substring
Comments(4)

Category: Excel, Search/Find

Apr.25, 2017 Fetching values from ThingSpeak using vba
Comments(0)

Category: Excel, Regular expressions, User defined functions (udf), VBA

Mar.30, 2017 Count colored cells
Comments(0)

Category: Excel, VBA

Mar.16, 2017 Become more productive – Learn Excel Defined Tables
Comments(0)

Category: Built-in features, Excel, Excel table

Feb.27, 2017 Rotating unique groups with no repeat
Comments(2)

Category: Excel, Permutations

Feb.17, 2017 Time sheet for work
Comments(7)

Category: Excel, Templates

Feb.07, 2017 Extract cell references from a formula
Comments(1)

Category: Excel, Regular expressions, User defined functions (udf), VBA

Dec.20, 2016 Filter rows where a cell contains a numeric value
Comments(10)

Category: Excel, Mmult

Dec.02, 2016 Like Operator
Comments(0)

Category: Excel, Regular expressions, User defined functions (udf), VBA

Nov.16, 2016 Build a stock chart with two series
Comments(1)

Category: Excel, stock chart

Nov.10, 2016 Calendar – monthly view
Comments(22)

Category: Calendar, Excel, Templates

Oct.24, 2016 Round-robin tournament
Comments(2)

Category: Excel, User defined functions (udf), VBA

Oct.11, 2016 List permutations with repetition and how many to choose from
Comments(2)

Category: Excel, Permutations

Sep.29, 2016 How to use dialog boxes in vba
Comments(0)

Category: Excel, User defined functions (udf), VBA

Aug.26, 2016 List all permutations with a condition
Comments(2)

Category: Permutations

Jul.04, 2016 Discover Pivot Tables – Excel’s most powerful feature and also least known
Comments(3)

Category: Built-in features, Excel, Pivot table

Jun.07, 2016 TEXTJOIN function
Comments(4)

Category: Excel, Functions, Textjoin

Jun.01, 2016 Excel vba – Array variables
Comments(2)

Category: Excel, VBA

Apr.21, 2016 Stock market trends – pivots
Comments(0)

Category: Excel, Stock market trend

Apr.12, 2016 Count identical numbers in two columns but items must be in same row
Comments(3)

Category: Count values, Excel

Mar.22, 2016 Compare two columns in different worksheets
Comments(0)

Category: Compare, Excel

Mar.16, 2016 Sort values by corresponding text
Comments(0)

Category: Excel, Sort values

Feb.15, 2016 Sort names by value
Comments(7)

Category: Excel, Mod, Sort values

Feb.03, 2016 Multiply cells efficiently
Comments(2)

Category: Excel, User defined functions (udf), VBA

Jan.26, 2016 Resize a range of values
Comments(1)

Category: Excel, User defined functions (udf), VBA

Jan.18, 2016 Website statistics for 2015
Comments(2)

Category: Excel

Nov.13, 2015 Follow stock market trends – trailing stop
Comments(0)

Category: Excel, Stock market trend

Nov.03, 2015 Follow stock market trends – Moving Average
Comments(1)

Category: Excel, Stock market trend

Oct.19, 2015 Dynamic stock chart
Comments(2)

Category: Excel, stock chart

Oct.09, 2015 Find the highest status and when it was acquired
Comments(1)

Category: Excel

Sep.22, 2015 Combine a column chart and a xy scatter chart
Comments(0)

Category: Charts, Column chart, Excel

Sep.18, 2015 Primary data is hidden behind secondary data
Comments(0)

Category: Charts, Excel

Sep.07, 2015 Learn the basics of Excel arrays
Comments(2)

Category: Built-in features, Count values, Excel

Aug.24, 2015 Highlight a column in a stacked column chart (no vba)
Comments(3)

Category: Charts, Column chart, Excel, Highlight

Aug.14, 2015 Color chart bars by value
Comments(0)

Category: Charts, Excel

Aug.12, 2015 Count overlapping days across multiple date ranges
Comments(1)

Category: Excel, Mmult, Overlapping

Aug.06, 2015 Find date given day and week
Comments(0)

Category: Dates, Excel

Aug.03, 2015 Improve your X Y Scatter Chart with custom data labels
Comments(3)

Category: Charts, Excel

Jun.30, 2015 TRANSPOSE function
Comments(4)

Category: Excel, Functions, Transpose

Jun.17, 2015 Calculate time between time zones
Comments(3)

Category: Dates, Excel

Jun.10, 2015 Find and replace a text string in file names, folder name and subfolders
Comments(3)

Category: Excel, Files and folders

Jun.04, 2015 Sum numerical ranges
Comments(2)

Category: Excel, Sum

Jun.02, 2015 Unzip files in folder and subfolders
Comments(2)

Category: Excel, Files and folders

May.29, 2015 Count per row
Comments(3)

Category: Count values, Excel, Sort values

May.25, 2015 Frequency bug?
Comments(5)

Category: Excel, Frequency, Mod

May.20, 2015 Count overlapping days in multiple date ranges, part 2
Comments(4)

Category: Overlapping

May.18, 2015 Count overlapping days in multiple date ranges
Comments(7)

Category: Excel, Overlapping

May.13, 2015 Find missing dates in a set of date ranges
Comments(3)

Category: Dates, Missing values

May.12, 2015 Dynamic scoreboard
Comments(7)

Category: Count values, Excel, Mmult, Sum

May.07, 2015 Working with overlapping date ranges
Comments(1)

Category: Excel, Mmult, Overlapping

May.05, 2015 Use MEDIAN function to calculate overlapping ranges
Comments(8)

Category: Dates, Excel, Overlapping

Apr.22, 2015 Team generator
Comments(4)

Category: Excel, Random, Team generator

Apr.16, 2015 Working with List Boxes (Form Controls)
Comments(4)

Category: Excel, Form Controls, Listbox

Apr.10, 2015 Split expenses calculator
Comments(0)

Category: Excel, Split values

Mar.31, 2015 Count contiguous values
Comments(4)

Category: Count values, Excel

Mar.25, 2015 List all hyperlinks in worksheet
Comments(3)

Category: Excel, Hyperlinks, Worksheet

Mar.19, 2015 Add new items to a drop down list automatically
Comments(9)

Category: Drop down lists, Excel

Mar.10, 2015 Quotient, Mod and Int functions
Comments(3)

Category: Excel, Functions, Mod

Mar.03, 2015 Permutations with and without repetition
Comments(4)

Category: Excel, Permutations

Feb.26, 2015 Return all combinations
Comments(35)

Category: Combinations, Excel, Permutations

Feb.19, 2015 Find numbers closest to sum
Comments(13)

Category: Excel, Mmult, Permutations, Sum

Feb.11, 2015 Filter duplicate files in a folder and sub folders
Comments(1)

Category: Excel, Files and folders

Feb.06, 2015 Compare file names in two different folder locations and their sub folders
Comments(6)

Category: Excel, Files and folders

Jan.27, 2015 Save selected sheets to a pdf file
Comments(6)

Category: Excel, VBA

Jan.19, 2015 Find cells containing formulas with literal (hard coded) values
Comments(12)

Category: Excel, User defined functions (udf), VBA

Jan.09, 2015 LOOKUP function
Comments(0)

Category: Excel, Lookup function

Dec.30, 2014 How to enter array formulas in merged cells
Comments(2)

Category: Combine/Merge, Excel, Misc

Dec.16, 2014 INDIRECT function
Comments(0)

Category: Excel, Functions

Dec.09, 2014 Find the longest/smallest consecutive sequence of a value (vba)
Comments(3)

Category: Excel, Sequence

Dec.02, 2014 Split text across columns
Comments(6)

Category: Excel, User defined functions (udf), VBA

Nov.18, 2014 Count the number of cells within a range that match multiple comma separated values
Comments(7)

Category: Count values, Excel, User defined functions (udf)

Nov.11, 2014 Find the longest/smallest consecutive sequence of a value
Comments(5)

Category: Excel, Sequence

Nov.04, 2014 Find a sequence of values – wildcard search
Comments(1)

Category: Excel, Sequence

Oct.28, 2014 Find a sequence
Comments(2)

Category: Excel, Sequence

Oct.23, 2014 Search all workbooks in a folder and sub folders
Comments(14)

Category: Excel, Files and folders

Oct.14, 2014 List of all comments (excel vba)
Comments(1)

Category: Excel, VBA

Oct.08, 2014 Use pictures in a column chart
Comments(0)

Category: Charts, Column chart, Excel

Sep.30, 2014 Build a comparison chart
Comments(1)

Category: Charts, Excel

Sep.23, 2014 Add pictures to a chart axis
Comments(7)

Category: Charts, Excel

Sep.18, 2014 Group data by quarters
Comments(0)

Category: Excel, Split values

Aug.20, 2014 Copy filtered excel tables in vba
Comments(3)

Category: Excel, Excel table, VBA

Jul.16, 2014 Highlight a selected cell´s row and column
Comments(9)

Category: Excel, VBA

Jul.04, 2014 Optimize pick path in a warehouse
Comments(6)

Category: Excel, Pathfinding, Solver

Jun.26, 2014 Compare two lists and filter unique values where the sum in one column doesn’t match the other column
Comments(5)

Category: Compare, Excel, Unique distinct values

Jun.16, 2014 A quicker A * pathfinding algorithm
Comments(0)

Category: Excel, Pathfinding

Jun.03, 2014 Learn how the MOD function works
Comments(8)

Category: Excel, Functions, Mod, Quotient

May.27, 2014 Finding the shortest path – A * pathfinding
Comments(5)

Category: Pathfinding

May.20, 2014 Basic substitution cipher
Comments(4)

Category: Excel, VBA

May.07, 2014 Move data to workbooks
Comments(3)

Category: Excel, VBA

Apr.29, 2014 Learn Excel’s Subtotal feature
Comments(0)

Category: Built-in features, Conditional formatting, Excel, Sort values

Apr.18, 2014 Sort and return unique single digit numbers
Comments(6)

Category: Excel, Sorted unique distinct values

Apr.16, 2014 Print screen the entire worksheet
Comments(2)

Category: Excel, Print

Apr.14, 2014 Highlight unique values in a filtered excel table
Comments(0)

Category: Conditional formatting, Excel

Apr.08, 2014 Customize excel maze
Comments(2)

Category: Excel, Maze

Apr.02, 2014 Solve a maze
Comments(3)

Category: Excel, Maze

Mar.31, 2014 Build a maze
Comments(9)

Category: Excel, Maze

Mar.27, 2014 Introducing Get Digital Help´s Advanced Excel Course
Comments(0)

Category: Excel

Mar.21, 2014 Shortest path
Comments(3)

Category: Excel, Pathfinding

Mar.14, 2014 Animating a line chart
Comments(2)

Category: Animate, Charts, Excel

Feb.27, 2014 Merge lists with criteria
Comments(7)

Category: Combine/Merge, Excel

Feb.18, 2014 An animated bar chart
Comments(4)

Category: Animate, Charts, Excel

Feb.11, 2014 Find the most urgent work orders
Comments(1)

Category: Compare, Excel

Feb.07, 2014 Find last matching value in an unsorted list
Comments(22)

Category: Excel, Lookup function

Feb.04, 2014 Multi-level To-Do list template
Comments(7)

Category: Check-boxes, Excel, Templates, VBA

Jan.28, 2014 An animated excel chart
Comments(1)

Category: Animate, Charts, Excel

Jan.21, 2014 Highlight a group of chart bars
Comments(3)

Category: Charts, Excel, Highlight

Jan.14, 2014 Team ranking with criteria
Comments(7)

Category: Excel, Rank

Jan.08, 2014 Search all workbooks in a folder
Comments(80)

Category: Excel, Files and folders

Dec.29, 2013 5 most popular blog posts 2013
Comments(0)

Category: Excel

Dec.20, 2013 All you need to know about calculating NAV units for your stock portfolio
Comments(0)

Category: Excel, Stock portfolio

Dec.13, 2013 Lookup and return multiple values sorted in a custom order
Comments(13)

Category: Excel, Sort values, Vlookup

Dec.03, 2013 Add your personal excel macros to the ribbon
Comments(2)

Category: Excel, User defined functions (udf), VBA

Nov.26, 2013 Identify overlapping records
Comments(7)

Category: Excel, Overlapping

Nov.22, 2013 Remove print preview lines (Page Breaks)
Comments(0)

Category: Excel, Print

Nov.12, 2013 Compare values between two columns and filter values existing in only one column
Comments(3)

Category: Compare, Excel

Nov.06, 2013 Quickly change chart data source
Comments(2)

Category: Charts, Drop down lists, Excel, Interactive

Oct.30, 2013 Working with textboxes (vba)
Comments(2)

Category: Excel, Form Controls

Oct.25, 2013 Show and hide a picture (vba)
Comments(9)

Category: Excel, VBA

Oct.22, 2013 Multiple wildcard lookups and include or exclude criteria
Comments(3)

Category: Excel

Oct.18, 2013 Lookup with an unknown number of criteria
Comments(4)

Category: Excel

Oct.15, 2013 Click a button to make specific worksheets hidden or visible (vba)
Comments(2)

Category: Excel, Macro, Worksheet

Oct.11, 2013 Click a cell to make a column hidden or visible (vba)
Comments(3)

Category: Excel, VBA

Oct.08, 2013 Scroll through a data set
Comments(0)

Category: Excel, Excel table, VBA

Oct.02, 2013 Counting conditionally formatted cells (vba)
Comments(26)

Category: Conditional formatting, Count values, Excel, User defined functions (udf), VBA

Sep.27, 2013 Count cells by cell and font color
Comments(5)

Category: Count values, Excel, Unique distinct values, User defined functions (udf)

Sep.23, 2013 Calculate min and max date among overlapping date ranges and based on a condition
Comments(0)

Category: Excel, Overlapping

Sep.20, 2013 Select and delete formulas evaluating to an empty text string
Comments(0)

Category: Excel, VBA

Sep.17, 2013 Prevent duplicate records (data validation)
Comments(1)

Category: Data validation, Excel

Sep.14, 2013 Format fill color on a column chart based on cell color
Comments(13)

Category: Charts, Column chart, Excel

Sep.10, 2013 Count unique distinct values by cell color
Comments(10)

Category: Excel, Unique distinct values, User defined functions (udf), VBA

Sep.05, 2013 Pivot table calendar
Comments(3)

Category: Calendar, Excel, Pivot table

Aug.30, 2013 Highlight date ranges overlapping selected record (vba)
Comments(2)

Category: Conditional formatting, Excel, Overlapping, VBA

Aug.23, 2013 Basic mathematics in excel for school children
Comments(0)

Category: Excel, User defined functions (udf), VBA

Aug.20, 2013 Find out if excel files in a folder are password protected
Comments(1)

Category: Files and folders

Aug.15, 2013 Count text strings in formulas (vba)
Comments(4)

Category: Excel, VBA

Aug.07, 2013 Quickly select a data set or an excel defined table [HYPERLINK]
Comments(2)

Category: Excel

Jul.30, 2013 Quickly jump to last row in a data set using excel hyperlink function
Comments(5)

Category: Excel

Jul.16, 2013 IFERROR function
Comments(0)

Category: Excel, Functions

Jul.09, 2013 Locate a particular cell in a table
Comments(7)

Category: Excel

Jul.05, 2013 Excel RANDBETWEEN and RAND functions – How to generate random numbers and text
Comments(10)

Category: Excel, Functions

Jul.03, 2013 Use drop down lists to compare data series in an excel chart
Comments(5)

Category: Charts, Drop down lists, Excel

Jun.27, 2013 Hierarchical relationships in an excel chart
Comments(1)

Category: Charts, Excel, VBA

Jun.19, 2013 Locate a shape in a workbook
Comments(1)

Category: Excel, VBA

Jun.14, 2013 Interactive candlestick chart
Comments(3)

Category: Charts, Excel, Interactive

Jun.05, 2013 Find consecutive dates in a cell range
Comments(2)

Category: Dates, Excel

May.31, 2013 How to use FREQUENCY function
Comments(3)

Category: Excel, Functions

May.27, 2013 Highlight a data series in a line chart
Comments(2)

Category: Excel, Highlight

May.24, 2013 Heat map using pictures
Comments(7)

Category: Charts, Excel, Maps

May.21, 2013 How to use excel SUMPRODUCT function
Comments(2)

Category: Excel, Functions

May.16, 2013 Count students
Comments(0)

Category: Count values, Excel

May.14, 2013 Use a map in an excel chart
Comments(7)

Category: Charts, Drop down lists, Excel, Excel table, Maps

May.06, 2013 SEARCH and FIND functions
Comments(3)

Category: Excel, Functions, Search/Find

May.03, 2013 Yet another excel calendar
Comments(3)

Category: Calendar, Excel

Apr.26, 2013 MMULT function – Matrix multiplication
Comments(4)

Category: Excel, Functions, Mmult

Apr.23, 2013 SMALL function and LARGE function
Comments(12)

Category: Excel, Functions

Apr.19, 2013 Copy/Rename a file (excel vba)
Comments(17)

Category: Excel, Files and folders

Apr.17, 2013 Assign each person with randomly unique objects as a daily activity
Comments(3)

Category: Excel, Random, Unique distinct values

Apr.15, 2013 ROW function explained
Comments(1)

Category: Excel, Functions, Row

Apr.09, 2013 Highlight duplicates in a filtered excel defined table
Comments(4)

Category: Conditional formatting, Excel, Excel table

Apr.07, 2013 COUNTIFS function
Comments(1)

Category: Excel, Functions

Apr.02, 2013 IF function explained
Comments(9)

Category: Excel, Functions

Mar.27, 2013 COUNTIF function
Comments(5)

Category: Excel, Functions

Mar.25, 2013 Days contained in a range that overlap another range
Comments(0)

Category: Excel, Overlapping

Mar.20, 2013 MATCH function
Comments(12)

Category: Excel, Functions

Mar.15, 2013 INDEX function explained
Comments(14)

Category: Excel, Functions, Index

Mar.13, 2013 Custom data labels in a chart
Comments(11)

Category: Charts, Excel

Mar.08, 2013 Change picture (vba)
Comments(17)

Category: Excel, VBA

Mar.05, 2013 Heat map calendar
Comments(16)

Category: Calendar, Excel, Templates

Mar.01, 2013 Lookup using multiple conditions
Comments(5)

Category: Excel

Feb.27, 2013 Substitute multiple text strings (vba)
Comments(5)

Category: Excel, Substitute Replace

Feb.25, 2013 Sort cell values in corresponding columns
Comments(2)

Category: Excel, Sort values

Feb.18, 2013 Count multiple text strings in a cell range
Comments(0)

Category: Count values, Excel

Feb.15, 2013 Move a shape (vba)
Comments(7)

Category: Excel, VBA

Feb.11, 2013 Sort a table with an array formula
Comments(1)

Category: Excel, Excel table, Sort values

Feb.06, 2013 2012 website statistics
Comments(5)

Category: Excel, Misc

Feb.04, 2013 No more array formulas?
Comments(7)

Category: Excel, Unique distinct values, Vlookup

Feb.01, 2013 Dynamic data labels in a chart
Comments(1)

Category: Charts, Drop down lists, Excel, Interactive

Jan.29, 2013 Highlight a column in a stacked column chart
Comments(2)

Category: Charts, Excel, Highlight

Jan.25, 2013 Highlight events in a calendar
Comments(10)

Category: Calendar, Excel, Templates

Jan.24, 2013 Highlight a bar in a chart
Comments(4)

Category: Charts, Excel, VBA

Jan.18, 2013 Repeat values
Comments(13)

Category: Excel, Sequence

Jan.15, 2013 Merge two related tables
Comments(7)

Category: Excel, Pivot table, Related tables

Jan.11, 2013 Highlight events overlapping federal holidays
Comments(6)

Category: Excel, Overlapping

Jan.07, 2013 Lookup multiple values in one cell (vba)
Comments(6)

Category: Excel, User defined functions (udf), VBA

Jan.03, 2013 Sum security holdings monthly and yearly in a pivot table
Comments(4)

Category: Excel, Finance, Pivot table

Dec.28, 2012 Run a macro from a drop down list (vba)
Comments(17)

Category: Drop down lists, Excel, VBA

Dec.10, 2012 Use a drop down list to change conditional formatting
Comments(3)

Category: Conditional formatting, Drop down lists, Excel

Dec.05, 2012 Prevent users from entering overlapping date and time ranges
Comments(0)

Category: Data validation, Excel, Overlapping

Nov.30, 2012 Group a number of rows together by the first column
Comments(5)

Category: Combine/Merge, Excel

Nov.29, 2012 Lookup and return multiple values on the same row from a range excluding blanks
Comments(14)

Category: Excel, VLOOKUP and return multiple values

Nov.22, 2012 Find date range
Comments(5)

Category: Dates, Excel

Nov.20, 2012 Find max unique value from a range that have duplicate numbers and blanks
Comments(0)

Category: Excel, Excel table, Sort values

Nov.13, 2012 Monthly time sheet by project
Comments(2)

Category: Excel, Excel table, Pivot table, Templates

Nov.09, 2012 Analyze trends using pivot tables
Comments(2)

Category: Charts, Excel, Pivot table

Nov.07, 2012 Hide specific columns (vba)
Comments(5)

Category: Charts, Excel, Excel table, VBA

Nov.05, 2012 Compare your stock portfolio with S&P500 in excel
Comments(2)

Category: Excel, Stock portfolio

Oct.31, 2012 Use multiple conditions in Vlookup
Comments(26)

Category: Excel, Vlookup

Oct.26, 2012 Locate lookup values in a table [HYPERLINK]
Comments(14)

Category: Excel, Vlookup

Oct.23, 2012 Applying conditional formatting to related tables
Comments(1)

Category: Excel, Related tables

Oct.19, 2012 Working with three related tables
Comments(10)

Category: Excel, Related tables

Oct.17, 2012 Extract unique distinct values from a related table
Comments(7)

Category: Excel, Related tables

Oct.15, 2012 Learn this genius trick on how to use a Table name in Data Validation Lists and Conditional Formatting formulas
Comments(30)

Category: Data validation, Drop down lists, Excel, Excel table

Oct.12, 2012 Change bar color in charts (vba)
Comments(1)

Category: Charts, Excel, VBA

Oct.10, 2012 Lookups in a related table (array formula)
Comments(3)

Category: Excel, Related tables

Oct.05, 2012 Inventory consumption
Comments(2)

Category: Count values, Dates, Excel

Oct.02, 2012 Copy each sheet in active workbook to new workbooks
Comments(4)

Category: Excel, VBA

Sep.27, 2012 Filter values that exists in all three lists
Comments(5)

Category: Compare, Excel

Sep.26, 2012 Copy excel table filter criteria (vba)
Comments(1)

Category: Excel, Excel table, VBA

Sep.21, 2012 Quickly search a data set with many criteria
Comments(0)

Category: Excel, Records, Sort values

Sep.17, 2012 Create name initials
Comments(13)

Category: Excel, Misc

Sep.12, 2012 Search a table and use the returning value to search another table
Comments(0)

Category: Dates, Excel

Sep.10, 2012 Use a calendar to filter a table
Comments(4)

Category: Calendar, Excel

Sep.05, 2012 Excel calendar (vba)
Comments(21)

Category: Calendar, Excel

Sep.03, 2012 Fetch data from another table
Comments(1)

Category: Excel

Aug.27, 2012 Use filtered table values in a drop down list (vba)
Comments(5)

Category: Drop down lists, Excel, User defined functions (udf), VBA

Aug.22, 2012 Dynamic chart – Display values from a table row or column
Comments(4)

Category: Charts, Excel, Interactive

Aug.20, 2012 How slow is ReDim Preserve?
Comments(7)

Category: Excel, VBA

Aug.17, 2012 Shift Schedule
Comments(5)

Category: Conditional formatting, Cross reference table, Excel, Schedule, Templates

Aug.15, 2012 Extract cell references from all cell ranges populated with values in a sheet
Comments(3)

Category: Excel, VBA

Aug.07, 2012 Use a mouse hovering technique to create an interactive chart
Comments(22)

Category: Charts, Excel, Interactive

Aug.06, 2012 Sort values in a cell using a custom delimiter (vba)
Comments(5)

Category: Excel, Sort values, VBA

Jul.31, 2012 Count and visualize specific weekdays in a custom date range
Comments(0)

Category: Calendar, Excel

Jul.27, 2012 Visualize date ranges in a calendar part 2
Comments(14)

Category: Calendar, Excel, Templates

Jul.25, 2012 Quickly create links to sheets, tables, pivot tables and named ranges in a workbook
Comments(3)

Category: Excel, Hyperlinks

Jul.23, 2012 Count unique distinct values in a filtered table
Comments(7)

Category: Count values, Excel, Unique distinct values

Jul.18, 2012 Create links to all sheets in a workbook
Comments(30)

Category: Excel, Hyperlinks

Jul.14, 2012 Quickly create new sheets (vba)
Comments(0)

Category: Excel, VBA

Jul.13, 2012 Adjust stock chart axis automatically
Comments(4)

Category: Excel, stock chart

Jul.05, 2012 Insert hyperlinks to all files in current folder
Comments(1)

Category: Excel, Files and folders

Jul.02, 2012 Match a criterion and extract multiple corresponding table headers
Comments(3)

Category: Excel, Sort values, Unique distinct values

Jun.29, 2012 Plot buy and sell points in an excel chart using two moving averages
Comments(3)

Category: Excel, Stock market trend

Jun.27, 2012 Add buy and sell points to a stock chart
Comments(2)

Category: Excel, Stock market trend

Jun.18, 2012 Interactive chart in excel (vba)
Comments(17)

Category: Charts, Excel, Interactive

Jun.12, 2012 Highlight values within specific ranges
Comments(1)

Category: Conditional formatting, Excel

Jun.06, 2012 Sort values in a table (vba)
Comments(7)

Category: Excel, Sort values, VBA

Jun.04, 2012 Normalize data, part 2
Comments(0)

Category: Excel, VBA

May.28, 2012 Search two related tables simultaneously (vba)
Comments(0)

Category: Excel, Related tables

May.23, 2012 Create comments in cells whose value is larger than the column width
Comments(0)

Category: Excel, VBA

May.22, 2012 Lookup multiple values in different columns and return a single value
Comments(31)

Category: Excel, Vlookup

May.21, 2012 Learn how to return values depending on udf deployment (vba)
Comments(4)

Category: User defined functions (udf), VBA

May.19, 2012 Select a cell in a table and the chart updates automatically (vba)
Comments(7)

Category: Charts, Excel, Interactive

May.16, 2012 Excel template: Getting Things Done (vba)
Comments(10)

Category: Excel, Templates, VBA

May.11, 2012 Disable autofit column widths for all pivot tables in a sheet
Comments(3)

Category: Excel, Pivot table, VBA

May.07, 2012 Vba macro: Normalize data
Comments(11)

Category: Excel, Pivot table, VBA

May.02, 2012 Date ranges: Weeks within a month
Comments(4)

Category: Dates, Excel

Apr.30, 2012 Add values to different sheets (vba)
Comments(7)

Category: Excel, VBA

Apr.26, 2012 Add values to a table (vba)
Comments(4)

Category: Excel, VBA

Apr.23, 2012 Unique distinct records sorted by frequency
Comments(3)

Category: Excel, Sorted unique distinct values

Apr.21, 2012 Count the number of groupings of each value
Comments(1)

Category: Count values, Excel

Apr.21, 2012 Use a drop down list to extract and concatenate unique distinct values
Comments(6)

Category: Concatenate, Drop down lists, Excel, VBA

Apr.18, 2012 Add or remove a value in a drop down list
Comments(5)

Category: Excel, VBA

Apr.16, 2012 Count specific weekdays in a date range
Comments(3)

Category: Count values, Dates, Excel

Apr.10, 2012 Open excel files in a folder (vba)
Comments(38)

Category: Excel, Files and folders

Apr.02, 2012 Copy table design settings
Comments(0)

Category: Excel, VBA

Mar.30, 2012 Auto populate a sheet
Comments(2)

Category: Combine/Merge, Count values, Excel, Pivot table, VBA

Mar.28, 2012 Search for a text string and return multiple adjacent values
Comments(46)

Category: Excel, Search/Find

Mar.26, 2012 Toggle a macro on/off using a button
Comments(4)

Category: Check-boxes, Excel, Macro

Mar.23, 2012 Calculate dates in each step in a project based on a finish date
Comments(4)

Category: Dates

Mar.19, 2012 Use a drop down list to select company info in header (vba)
Comments(8)

Category: Drop down lists, Excel, VBA

Mar.14, 2012 Automate data entry (vba)
Comments(8)

Category: Excel, VBA

Mar.12, 2012 Apply data validation lists dynamically (vba)
Comments(4)

Category: Data validation, Excel

Mar.09, 2012 Workbook log (vba)
Comments(3)

Category: Excel, VBA

Mar.05, 2012 Working with formulas in conditional formatting
Comments(3)

Category: Conditional formatting, Excel

Feb.28, 2012 How to create random numbers, text strings, dates and time values
Comments(2)

Category: Dates, Excel, Misc

Feb.26, 2012 Categorize data entry values (vba)
Comments(3)

Category: Excel, Split values

Feb.22, 2012 Dependent data validation lists in multiple rows
Comments(29)

Category: Dependent drop down lists, Excel

Feb.20, 2012 Holiday planner
Comments(5)

Category: Excel, Templates

Feb.13, 2012 Advanced Gantt Chart Template
Comments(2)

Category: Charts, Excel, Gantt, Templates

Feb.10, 2012 Auto resize columns as you type
Comments(16)

Category: Excel, VBA

Feb.07, 2012 Search with conditional formatting
Comments(4)

Category: Conditional formatting, Excel

Jan.31, 2012 Tracking calls in excel
Comments(0)

Category: Excel

Jan.27, 2012 Free School Schedule Template
Comments(5)

Category: Excel, Schedule, Templates

Jan.24, 2012 Copy a cell range whose size is likely to change from time to time (vba)
Comments(0)

Category: Excel, VBA

Jan.20, 2012 Easily identify groups of duplicate rows
Comments(1)

Category: Duplicate values, Excel

Jan.17, 2012 List all open workbooks and corresponding sheets (vba)
Comments(1)

Category: Excel, VBA

Jan.14, 2012 Basic data entry (vba)
Comments(4)

Category: Excel, VBA

Jan.09, 2012 List all tables and corresponding headers in a workbook (vba)
Comments(1)

Category: Excel, VBA

Jan.02, 2012 Basic invoice template
Comments(3)

Category: Drop down lists, Excel, Invoice, Templates

Dec.23, 2011 Filter weeks from a date range
Comments(2)

Category: Dates, Excel

Dec.21, 2011 Working with combo boxes (Form Control) using vba
Comments(26)

Category: Combobox, Excel, Form Controls

Dec.09, 2011 Excel charts: Multiple series and named ranges
Comments(13)

Category: Charts, Excel, Interactive

Dec.07, 2011 Use a drop down list to search and return multiple values
Comments(12)

Category: Drop down lists, Excel, VLOOKUP and return multiple values

Dec.02, 2011 Change chart data range using a drop down list (vba)
Comments(22)

Category: Charts, Drop down lists, Excel, Interactive

Nov.29, 2011 Change pivot table data source using a drop down list
Comments(18)

Category: Combobox, Drop down lists, Excel, Pivot table

Nov.24, 2011 How many of a specific weekday falls between a start date and an end date except holidays
Comments(2)

Category: Count values, Dates, Excel

Nov.17, 2011 Separate numbers from a text string
Comments(3)

Category: Excel

Nov.11, 2011 Select numbers in each permutation
Comments(2)

Category: Excel, Permutations

Nov.08, 2011 Dynamic Gantt charts in excel 2007
Comments(11)

Category: Charts, Excel, Gantt

Nov.04, 2011 Excel vba: Filter a table using the selection change event
Comments(1)

Category: Excel, VBA

Nov.02, 2011 Extract unique distinct values from a filtered table (udf and array formula)
Comments(17)

Category: Excel, Sort values, Unique distinct values, User defined functions (udf), VBA

Oct.28, 2011 Zen archery problem
Comments(6)

Category: Excel

Oct.24, 2011 Excel vba: Populate a combobox with values from a pivot table
Comments(7)

Category: Combobox, Excel

Oct.19, 2011 Excel array formula: Enter a value in a cell and instantly populate adjacent cells
Comments(2)

Category: Excel

Oct.17, 2011 Excel: Look for values containing a lookup value and return multiple values horizontally
Comments(0)

Category: Excel

Oct.12, 2011 Copy selected rows (checkboxes) (2/2)
Comments(31)

Category: Check-boxes, Excel, VBA

Oct.10, 2011 Excel vba: Add checkboxes to a sheet (1/2)
Comments(3)

Category: Check-boxes, Excel, VBA

Oct.06, 2011 Excel: List intervals between two values
Comments(16)

Category: Count values, Excel, Range

Oct.05, 2011 Add values to a data validation list (vba)
Comments(2)

Category: Excel, VBA

Sep.29, 2011 Follow hyperlinks in a pivot table
Comments(19)

Category: Pivot table

Sep.20, 2011 List five smallest numbers, excluding zeros
Comments(0)

Category: Excel, Sort values

Sep.16, 2011 Quickly filter a column in an excel table
Comments(1)

Category: Excel

Sep.14, 2011 Excel udf: Reorganize data
Comments(0)

Category: Excel

Sep.12, 2011 Populate a list box with visible unique values from an excel table (vba)
Comments(6)

Category: Excel, Listbox

Sep.07, 2011 Excel vba: Populate a combo box (form control)
Comments(10)

Category: Combobox, Excel, Form Controls

Aug.31, 2011 Excel table: Filter unique distinct rows and use additional filters at the same time
Comments(0)

Category: Unique distinct records

Aug.26, 2011 Excel table: Filter unique distinct values (array formula)
Comments(2)

Category: Excel

Aug.25, 2011 Count unique distinct values in a large dataset with a date criterion
Comments(3)

Category: Count values, Excel, Unique distinct values

Aug.23, 2011 Excel udf: Looking up data in multiple cross reference tables
Comments(3)

Category: Cross reference table, User defined functions (udf), VBA

Aug.19, 2011 Count entries between date and time criteria in excel
Comments(2)

Category: Count values, Dates

Aug.18, 2011 Vlookup visible data in a table and return multiple values in excel
Comments(1)

Category: Vlookup

Aug.15, 2011 Compare two tables in excel: Remove common rows
Comments(5)

Category: Compare, Records

Aug.13, 2011 Excel 2007 vba: Create a custom-made item on the shortcut menu
Comments(0)

Category: Misc, VBA

Aug.09, 2011 Excel udf: Sumif across multiple sheets
Comments(1)

Category: Excel, Misc, User defined functions (udf), VBA

Aug.05, 2011 Insert rows for missing values
Comments(3)

Category: Excel, Missing values

Aug.03, 2011 Excel vba: Select cell A1 on all sheets before you close a workbook
Comments(5)

Category: Excel, VBA

Aug.01, 2011 Filter unique distinct and duplicate values from a large data set in excel 2007
Comments(4)

Category: Case sensitive, Duplicate values, Excel, Unique distinct values

Jul.28, 2011 Excel 2007/2010 array formula: Filter unique distinct values, sorted and blanks removed
Comments(11)

Category: Excel, Sorted unique distinct values

Jul.27, 2011 Excel udf: Import historical stock prices from yahoo – added features
Comments(18)

Category: Excel, stock chart

Jul.22, 2011 How to sort a table in a custom order in excel [No formula]
Comments(0)

Category: Excel, Records, Sort values

Jul.17, 2011 Vlookup across multiple sheets in excel
Comments(27)

Category: Add-in, Excel, Vlookup

Jul.12, 2011 Count unique distinct values that meet multiple criteria
Comments(93)

Category: Count unique distinct values, Count values, Excel

Jul.08, 2011 Excel udf: Import historical stock prices from yahoo
Comments(4)

Category: Excel, stock chart

Jul.04, 2011 Sum the cells in a range that meet multiple criteria in excel
Comments(2)

Category: Excel

Jun.30, 2011 Identify duplicate files in excel
Comments(7)

Category: Excel, Files and folders

Jun.29, 2011 Excel recursive udf: List files in a folder and subfolders
Comments(15)

Category: Excel, Files and folders

Jun.22, 2011 Vlookup a cell range and return multiple values
Comments(0)

Category: Excel, Unique distinct values, VLOOKUP and return multiple values

Jun.20, 2011 Count unique distinct values in an Excel Pivot Table
Comments(4)

Category: Count values, Excel, Pivot table, Unique distinct values

Jun.17, 2011 Merge matching rows in excel (text values)
Comments(2)

Category: Combine/Merge, Excel, Unique distinct values

Jun.16, 2011 Excel toolbox: Save your custom functions and macros in an Add-In
Comments(3)

Category: Excel, User defined functions (udf), VBA

Jun.13, 2011 Auto refresh a pivot table
Comments(92)

Category: Excel, Pivot table

Jun.09, 2011 Date ranges for 7 days in excel
Comments(4)

Category: Dates, Excel

Jun.07, 2011 Lookup with multiple criteria and display multiple unique search results (array formula)
Comments(5)

Category: Excel, Mmult, Search/Find, Unique distinct values

Jun.02, 2011 Compare pricelists in excel 2007
Comments(7)

Category: Compare, Excel

Jun.01, 2011 Quickly compare two tables in excel 2007
Comments(0)

Category: Compare, Excel, Records

May.25, 2011 Excel 2007 pivot table: Count unique distinct records (rows)
Comments(9)

Category: Excel, Pivot table, Unique distinct records

May.24, 2011 Sum unique distinct invoices
Comments(0)

Category: Excel, Invoice, Sum, Unique distinct values

May.23, 2011 Count unique distinct records with a date and column criteria in excel 2007
Comments(5)

Category: Count values, Excel, Unique distinct records

May.20, 2011 Google spreadsheets: Pivot tables
Comments(4)

Category: Excel, Pivot table

May.19, 2011 Filter unique distinct records with a condition
Comments(3)

Category: Excel, Unique distinct records

May.17, 2011 Excel charts: Use dynamic ranges to add new values to both chart and drop down list
Comments(21)

Category: Excel

May.13, 2011 Vlookup – Return multiple unique distinct values
Comments(45)

Category: Excel, Unique distinct values, VLOOKUP and return multiple values

May.10, 2011 Chandoo’s excel VBA classes are now open!
Comments(0)

Category: Excel

May.09, 2011 Calculate average of last 10 data (possible blanks) in excel
Comments(17)

Category: Excel

May.06, 2011 Excel udf: Filter unique distinct records (case sensitive)
Comments(0)

Category: Excel, Unique distinct records

May.03, 2011 Excel udf: Filter unique distinct values (case sensitive)
Comments(1)

Category: Case sensitive, Excel, Unique distinct values

May.01, 2011 Excel vba: Create dynamic conditional formatting
Comments(0)

Category: Conditional formatting, Excel, VBA

Apr.28, 2011 Create a dynamic named range in excel
Comments(12)

Category: Excel

Apr.26, 2011 How to create a dynamic pivot table and refresh automatically in excel
Comments(17)

Category: Excel, Pivot table

Apr.21, 2011 Excel udf: Combine cell ranges into a single range while eliminating blanks
Comments(4)

Category: Combine/Merge, Excel, User defined functions (udf), VBA

Apr.19, 2011 Bill reminder in excel
Comments(14)

Category: Excel, Finance

Apr.17, 2011 Dependent drop down lists – Enable/Disable selection filter
Comments(8)

Category: Dependent drop down lists, Excel

Apr.12, 2011 Running totals within date range in excel
Comments(9)

Category: Excel

Apr.06, 2011 How to quickly compare pricelists in excel
Comments(2)

Category: Compare, Conditional formatting, Excel

Apr.05, 2011 Excel udf: Word frequency
Comments(16)

Category: Count values, Excel, Frequency, User defined functions (udf), VBA

Apr.04, 2011 Excel udf: Fuzzy lookups
Comments(2)

Category: Excel, User defined functions (udf), VBA, Vlookup

Mar.28, 2011 Filter records within two dates and search for a text string in excel
Comments(0)

Category: Dates, Excel, Search/Find

Mar.24, 2011 Fuzzy vlookup (excel array formula)
Comments(17)

Category: Excel, Vlookup

Mar.23, 2011 Text to columns: Split words in a cell (excel array formula)
Comments(23)

Category: Excel, Split values

Mar.21, 2011 Quickly highlight records containing text strings in excel (AND Logic)
Comments(0)

Category: Excel, Search/Find

Mar.16, 2011 Excel udf: Filter emails from an excel range
Comments(4)

Category: Excel, Filter emails

Mar.12, 2011 Quickly highlight records in a list in excel (AND logic)
Comments(0)

Category: Conditional formatting, Excel, Records

Mar.09, 2011 Quickly highlight records in a list using multiple criteria in excel
Comments(3)

Category: Conditional formatting, Excel, Records

Mar.07, 2011 Cash drawer bill extractor template in excel
Comments(0)

Category: Excel, Finance, Solver, Templates

Mar.03, 2011 Filter duplicate records
Comments(3)

Category: Duplicate records, Excel, Excel table

Mar.02, 2011 Highlight closest value in excel
Comments(10)

Category: Conditional formatting, Excel

Feb.27, 2011 Merge matching rows in excel
Comments(3)

Category: Combine/Merge, Excel, VBA

Feb.25, 2011 Excel udf: Find positive and negative amounts that net to zero
Comments(5)

Category: Excel, Sum

Feb.22, 2011 Excel udf: Find numbers in sum
Comments(2)

Category: Excel, Finance, Sum

Feb.16, 2011 Filter overlapping date ranges in excel 2007
Comments(0)

Category: Excel, Overlapping

Feb.15, 2011 Count digits and ignore duplicates in any line in excel
Comments(2)

Category: Count values, Excel

Feb.09, 2011 Quickly concatenate values into one cell [No VBA]
Comments(86)

Category: Concatenate, Excel, Textjoin

Feb.08, 2011 Tracking a stock portfolio #2 in excel
Comments(3)

Category: Combine/Merge, Excel, Finance

Feb.03, 2011 Excel udf: List permutations without repetition
Comments(5)

Category: Excel, Permutations

Jan.31, 2011 Tracking a stock portfolio in excel (auto update)
Comments(9)

Category: Excel, Stock portfolio

Jan.29, 2011 Create a drop down calendar in excel
Comments(6)

Category: Calendar, Drop down lists, Excel

Jan.26, 2011 Weekly appointment calendar in excel
Comments(1)

Category: Calendar, Excel, Schedule

Jan.24, 2011 Monthly calendar template #2 in excel
Comments(1)

Category: Calendar, Excel, Templates

Jan.19, 2011 Monthly calendar template in excel
Comments(8)

Category: Calendar, Excel, Templates

Jan.17, 2011 Count unique distinct records in excel 2007
Comments(2)

Category: Count values, Excel, Unique distinct records

Jan.13, 2011 Compare two lists of data: Filter records existing in only one list in excel
Comments(0)

Category: Compare, Excel, Records

Jan.12, 2011 Compare two lists of data: Highlight records existing in only one list in excel
Comments(1)

Category: Compare, Excel, Records

Jan.11, 2011 Compare two lists of data: Highlight common records in excel
Comments(2)

Category: Compare, Excel, Records

Jan.08, 2011 Compare two lists of data: Filter common row records in excel
Comments(7)

Category: Compare, Excel, Records

Jan.04, 2011 Filter and highlight duplicate column records in excel 2007
Comments(0)

Category: Conditional formatting, Excel, Records

Jan.03, 2011 Extract duplicate records
Comments(0)

Category: Duplicate records, Excel

Dec.30, 2010 Highlight duplicate rows in excel 2007
Comments(7)

Category: Excel, Unique distinct records

Dec.30, 2010 Excel udf: List permutations with repetition
Comments(4)

Category: Excel, Permutations

Dec.22, 2010 Count matching cells in date range in excel
Comments(3)

Category: Count values, Dates, Excel

Dec.20, 2010 Lookup and return multiple values concatenated into one cell
Comments(249)

Category: Concatenate, Excel, Textjoin

Dec.15, 2010 Automate excel: Update list with new values
Comments(4)

Category: Combine/Merge, Excel

Dec.13, 2010 Excel vba: Use text qualifiers to make text to columns conversion easier
Comments(2)

Category: Excel, VBA

Dec.10, 2010 Excel vba: Create a Print button
Comments(11)

Category: Excel, Form Controls, Print

Dec.09, 2010 Select and view invoice [VBA]
Comments(3)

Category: Excel, Invoice

Dec.06, 2010 Populate listbox with unique invoice numbers [VBA]
Comments(5)

Category: Excel, Invoice, Listbox

Dec.03, 2010 Excel vba: Edit invoice data
Comments(3)

Category: Excel, Invoice

Dec.01, 2010 Save invoice data [VBA]
Comments(40)

Category: Excel, Invoice

Nov.28, 2010 Invoice template with dependent drop down lists
Comments(11)

Category: Dependent drop down lists, Excel, Invoice, Templates

Nov.26, 2010 Create random dates, Mon to Fri, within a year in excel
Comments(4)

Category: Dates, Excel

Nov.22, 2010 Return multiple matches with wildcard vlookup
Comments(8)

Category: Excel, Search/Find, Vlookup

Nov.16, 2010 Create dependent drop down lists containing unique distinct values in multiple rows
Comments(12)

Category: Dependent drop down lists, Excel

Nov.15, 2010 Excel udf: Filter values existing only in one out of two ranges
Comments(0)

Category: Compare, Excel, User defined functions (udf)

Nov.12, 2010 Excel udf: Filter common values between two cell ranges in excel
Comments(2)

Category: Compare, Excel, User defined functions (udf)

Nov.11, 2010 Excel vba: Select value based on time and date
Comments(0)

Category: Dates, Excel, VBA

Nov.09, 2010 Excel udf:Filter duplicates in a large dataset in excel
Comments(0)

Category: Excel

Nov.08, 2010 Compare and filter values between two lists in excel
Comments(4)

Category: Compare, Excel

Nov.03, 2010 Select 6 unique and random numbers from 1 to 49 (Lottery) in excel
Comments(16)

Category: Excel, Random

Nov.02, 2010 Generate list of random dates with criterion in excel
Comments(2)

Category: Dates, Excel, Random

Nov.01, 2010 Remove duplicate text strings based on the 4 last characters in a cell in excel
Comments(1)

Category: Excel, Text string manipulation

Oct.28, 2010 Apply dependent combo box selections to a filter in excel 2007
Comments(42)

Category: Combobox, Dependent drop down lists, Excel

Oct.26, 2010 Create a drop down list containing alphabetically sorted values in excel
Comments(15)

Category: Drop down lists, Excel

Oct.22, 2010 Excel udf: Count unique distinct values in a large dataset
Comments(0)

Category: Count values, Excel, Unique distinct values, User defined functions (udf)

Oct.20, 2010 List people with the highest scores based on criteria in a pivot table (Excel 2007)
Comments(0)

Category: Excel, Pivot table

Oct.18, 2010 List people with the highest scores based on criteria in excel
Comments(0)

Category: Excel, Sort values

Oct.17, 2010 Remove duplicates and sort dates by each row in excel
Comments(2)

Category: Dates, Excel, Sorted unique distinct values

Oct.16, 2010 Excel udf: Remove duplicates from a large dataset
Comments(3)

Category: Duplicate values, Excel, Unique distinct values, User defined functions (udf), VBA

Oct.12, 2010 Sort a list in random order in excel
Comments(4)

Category: Excel, Random, Sort values

Oct.10, 2010 Create a random playlist in excel – True round-robin tournament
Comments(0)

Category: Excel, Random

Oct.09, 2010 Highlight duplicate values and overlapping dates in excel
Comments(23)

Category: Excel, Overlapping

Oct.07, 2010 Dynamic team generator in excel
Comments(9)

Category: Excel, Random, Team generator

Oct.05, 2010 Create a random playlist in excel
Comments(10)

Category: Excel, Random

Sep.30, 2010 Team Generator in excel
Comments(7)

Category: Excel, Random, Team generator

Sep.28, 2010 Count records between two dates with multiple parameters in excel
Comments(14)

Category: Count values, Dates, Excel

Sep.26, 2010 Sort values in parallel in excel, part 2
Comments(4)

Category: Excel, Sort values

Sep.24, 2010 Random row from a boolean matrix in excel
Comments(0)

Category: Excel, Random

Sep.22, 2010 Search case sensitive and return multiple values in excel
Comments(0)

Category: Case sensitive, Excel, VLOOKUP and return multiple values

Sep.21, 2010 Filter unique words from a range in excel (udf)
Comments(0)

Category: Excel, Unique values, User defined functions (udf)

Sep.19, 2010 Vlookup with multiple matches returns a different value
Comments(9)

Category: Excel, Vlookup

Sep.15, 2010 Filter unique distinct words from a cell range in excel (udf)
Comments(11)

Category: Excel, Unique distinct values, User defined functions (udf), VBA

Sep.12, 2010 Filter duplicate words from a cell range in excel (udf)
Comments(2)

Category: Duplicate values, Excel, User defined functions (udf), VBA

Sep.10, 2010 User defined function to split words in a cell range into a cell each in excel
Comments(13)

Category: Excel, Split values

Sep.06, 2010 Consolidate sheets in excel, part 2
Comments(0)

Category: Excel

Sep.03, 2010 Extract a unique distinct list by matching items that meet a criterion in excel 2007 using pivot table
Comments(0)

Category: Excel, Pivot table, Unique distinct values

Sep.01, 2010 Extract a unique distinct list by matching items that meet a criterion in excel
Comments(40)

Category: Excel, Unique distinct values

Aug.31, 2010 Extract dates from a cell block schedule in excel, part 3
Comments(0)

Category: Calendar, Excel, Schedule

Aug.30, 2010 Extract dates from a cell block schedule in excel, part 2
Comments(0)

Category: Calendar, Excel, Schedule

Aug.29, 2010 Extract dates from a cell block schedule in excel
Comments(1)

Category: Calendar, Excel, Schedule

Aug.23, 2010 Concatenate cell values in excel
Comments(6)

Category: Concatenate, Excel

Aug.20, 2010 Filter emails spread over several columns in excel
Comments(5)

Category: Excel

Aug.16, 2010 Search for a cell in a table and then display the column title in excel
Comments(4)

Category: Excel

Aug.15, 2010 Schedule recurring events in a weekly schedule in excel
Comments(12)

Category: Excel, Schedule

Aug.08, 2010 Setting up your work hours in a weekly schedule in excel
Comments(0)

Category: Excel, Schedule

Aug.05, 2010 Populate cells dynamically in a weekly schedule in excel
Comments(33)

Category: Excel, Schedule

Aug.01, 2010 How to filter numbers inside (and outside) number ranges in excel
Comments(1)

Category: Excel, Range, Sort values

Jul.29, 2010 Find empty hours in a weekly schedule in excel
Comments(1)

Category: Excel, Schedule

Jul.26, 2010 Count cell blocks in excel
Comments(2)

Category: Count values, Dates, Excel

Jul.21, 2010 Schedule recurring expenses in a calendar in excel (Personal Finance)
Comments(11)

Category: Excel, Finance

Jul.17, 2010 Create dependent drop down lists containing unique distinct values
Comments(113)

Category: Dependent drop down lists, Excel

Jul.13, 2010 Count overlapping dates in excel
Comments(4)

Category: Excel, Overlapping

Jul.11, 2010 Create a unique distinct sorted list containing both numbers text removing blanks
Comments(24)

Category: Excel, Sorted unique distinct values

Jul.08, 2010 Filter overlapping dates from date ranges in excel
Comments(0)

Category: Dates, Excel

Jul.04, 2010 Highlight specific time ranges in a weekly schedule in excel
Comments(20)

Category: Calendar, Excel, Schedule

Jul.01, 2010 Weekly schedule template in excel
Comments(8)

Category: Excel, Schedule, Templates

Jun.28, 2010 Convert date ranges into dates in excel
Comments(5)

Category: Dates, Excel

Jun.22, 2010 Convert dates into date ranges in excel
Comments(7)

Category: Dates, Excel

Jun.20, 2010 List dates outside specified date ranges in excel
Comments(4)

Category: Dates, Excel

Jun.14, 2010 Visualize date ranges in a calendar
Comments(10)

Category: Calendar, Excel, Overlapping

Jun.10, 2010 How to use absolute and relative references in excel
Comments(12)

Category: Excel

Jun.03, 2010 Highlight overlapping date ranges using conditional formatting in excel
Comments(31)

Category: Excel, Overlapping

May.30, 2010 Find overlapping date ranges in excel
Comments(24)

Category: Excel, Overlapping

May.25, 2010 Use a number range when trying to find the frequency of a number in excel
Comments(0)

Category: Excel

May.22, 2010 How to return the total for orders with more than one item in excel
Comments(0)

Category: Excel, Pivot table

May.18, 2010 Merge two columns with possible blank cells
Comments(28)

Category: Combine/Merge, Excel

May.16, 2010 Count unique and duplicates text values in a closed workbook in excel (formula)
Comments(1)

Category: Count values, Excel, Unique distinct values, Unique values

May.12, 2010 Extracting unique distinct text values from a closed workbook in excel (formula)
Comments(3)

Category: Excel

May.11, 2010 Count unique and duplicate numbers from a closed workbook in excel (formula)
Comments(0)

Category: Count values, Excel, Unique distinct values, Unique values

May.10, 2010 Extract unique distinct numbers from closed workbook in excel (formula)
Comments(0)

Category: Excel, Unique distinct values

May.05, 2010 List all the unique events for a month in excel (array formula)
Comments(5)

Category: Dates, Excel, Unique distinct values, Unique values

May.02, 2010 Sort numeric values by closest to farthest to a specific number in excel (array formula)
Comments(0)

Category: Excel, Sort values

Apr.28, 2010 How to quickly select a large non contiguous range with keyboard in excel
Comments(5)

Category: Excel

Apr.24, 2010 Highlight duplicates on same date, week or month using conditional formatting in excel
Comments(0)

Category: Conditional formatting, Dates, Excel

Apr.19, 2010 Filter duplicates within same date, week or month in excel
Comments(2)

Category: Dates, Duplicate values, Excel

Apr.17, 2010 Count unique distinct values within same week, month or year in excel
Comments(8)

Category: Count values, Dates, Excel, Frequency, Sum, Unique distinct values, Year

Apr.15, 2010 How to count unique distinct occurrences for each date in excel
Comments(4)

Category: Count values, Excel, Unique distinct values

Apr.13, 2010 Remove duplicates within same month or year in excel
Comments(0)

Category: Dates, Duplicate values, Excel, Unique distinct values

Apr.13, 2010 Remove duplicates in same week in excel
Comments(0)

Category: Dates, Duplicate values, Excel, Unique distinct values

Apr.12, 2010 Remove duplicates on same date in excel
Comments(3)

Category: Dates, Duplicate values, Excel, Unique distinct values

Apr.07, 2010 Lookup values in a range using two or more criteria and return multiple matches in excel, part 2
Comments(21)

Category: Excel, Vlookup

Apr.05, 2010 Explaining a formula: Lookup values in a range using two or more criteria and return multiple matches in excel
Comments(5)

Category: Excel, Vlookup

Mar.31, 2010 Calculate your stock portfolio performance with Net Asset Value based on units in excel
Comments(13)

Category: Excel, Stock portfolio

Mar.29, 2010 Consolidate sheets in excel (vba)
Comments(11)

Category: Combine/Merge, Excel, VBA

Mar.24, 2010 Lookup using two criteria in excel
Comments(0)

Category: Excel, Vlookup

Mar.22, 2010 Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel
Comments(27)

Category: Excel, Stock portfolio

Mar.18, 2010 Calculate your stock portfolio performance in excel
Comments(31)

Category: Excel, Stock portfolio

Mar.15, 2010 Pass multiple conditions dynamically in excel
Comments(2)

Category: Excel

Mar.11, 2010 Categorize values into multiple columns (excel formulas)
Comments(6)

Category: Excel, Split values

Mar.10, 2010 Categorize values into multiple columns using vba in excel
Comments(1)

Category: Excel, Split values

Mar.07, 2010 Count unique distinct numbers across multiple sheets (3D range) in excel
Comments(0)

Category: Count values, Excel

Mar.04, 2010 Return unique and duplicate numerical data entries from multiple sheets (3D range) in excel
Comments(2)

Category: Excel, Unique distinct values, Unique values

Mar.03, 2010 Split data across multiple sheets in excel (vba)
Comments(29)

Category: Add-in, Excel, Split values

Feb.28, 2010 Combine data from multiple sheets in excel
Comments(29)

Category: Combine/Merge, Excel

Feb.26, 2010 Calendar with scheduling in excel 2007 (vba)
Comments(2)

Category: Calendar, Excel, Schedule

Feb.21, 2010 Dynamic stock chart in excel – Add date ranges
Comments(2)

Category: Excel, stock chart

Feb.18, 2010 Create unique distinct year and months from a long date listing
Comments(0)

Category: Dates, Excel, Unique distinct values

Feb.16, 2010 Create a dynamic stock chart using a web query and a drop down list in excel
Comments(0)

Category: Excel, stock chart

Feb.11, 2010 Match two criteria and return multiple records
Comments(143)

Category: Excel, Records

Feb.10, 2010 Create a unique distinct list of a long list without sacrificing performance using vba in excel
Comments(14)

Category: Advanced filter, Excel, Unique distinct values, VBA

Feb.07, 2010 Scan stock markets in excel
Comments(7)

Category: Excel, Stock market trend

Feb.02, 2010 Extract negative values and adjacent cells in excel
Comments(3)

Category: Excel, Sort values

Jan.30, 2010 Stock alerts in excel
Comments(1)

Category: Excel, Stock portfolio

Jan.27, 2010 Quickly select a range of values in excel
Comments(2)

Category: Excel, Misc

Jan.24, 2010 Create number sequences in excel 2007
Comments(9)

Category: Excel, Sequence

Jan.20, 2010 Excel formula to count cells between two values
Comments(4)

Category: Count values, Excel

Jan.19, 2010 Return multiple values if above frequency criterion in excel
Comments(2)

Category: Excel, Frequency

Jan.16, 2010 Filter unique distinct values using “contain” condition of a column in excel
Comments(6)

Category: Advanced filter, Excel, Unique distinct values

Jan.14, 2010 Return multiple values if in range in excel
Comments(0)

Category: Excel

Jan.13, 2010 How to return a value if lookup value is in range
Comments(23)

Category: Excel, Lookup function, Vlookup

Jan.12, 2010 Sort values in parallel (array formula)
Comments(16)

Category: Excel, Sort values

Jan.10, 2010 Vlookup of three columns to pull a single record
Comments(10)

Category: Excel, Records, Vlookup

Jan.08, 2010 Using Excel Solver to schedule employees
Comments(0)

Category: Excel, Solver

Jan.07, 2010 Find positive and negative amounts that net to zero in excel
Comments(4)

Category: Count values, Excel, Misc, Solver

Jan.05, 2010 Identify numbers in sum using solver in excel
Comments(48)

Category: Combinations, Excel, Solver, Sum

Jan.04, 2010 Sequencing and numbering of batches in excel
Comments(6)

Category: Excel, Sequence

Jan.03, 2010 Sum adjacent values from a range using multiple lookup values in excel
Comments(8)

Category: Excel, Vlookup

Jan.03, 2010 Lookup values in a range using two or more criteria and return multiple matches in excel
Comments(11)

Category: Excel, Vlookup

Dec.31, 2009 Sum adjacent values using multiple lookup text values in a column in excel
Comments(1)

Category: Excel, Sum, Vlookup

Dec.29, 2009 Vlookup with 2 or more lookup criteria and return multiple matches
Comments(38)

Category: Excel, VLOOKUP and return multiple values

Dec.27, 2009 Filter duplicate values in a range using “contain” condition in excel
Comments(0)

Category: Duplicate values, Excel

Dec.23, 2009 Filter unique text values in a range using “contain” condition in excel
Comments(0)

Category: Excel, Unique values

Dec.21, 2009 Filter unique distinct text values in a range using “contain” condition in excel
Comments(1)

Category: Excel, Unique distinct values

Dec.17, 2009 Filter duplicate text values in a range using “begins with” criterion in excel
Comments(0)

Category: Duplicate values, Excel

Dec.17, 2009 Filter unique text values using “begins with” criterion in a range in excel
Comments(0)

Category: Excel, Unique values

Dec.14, 2009 Filter unique distinct text values using “begins with” criterion in a range using array formula in excel
Comments(2)

Category: Excel, Unique distinct values

Dec.13, 2009 Formula for matching a date within a date range in excel
Comments(48)

Category: Dates, Excel

Dec.10, 2009 Count unique values in two lists combined in excel
Comments(0)

Category: Count values, Excel, Unique values

Dec.10, 2009 Count matching values in one or more columns in excel
Comments(0)

Category: Count values, Excel

Dec.07, 2009 Find records using two numerical criteria in excel
Comments(0)

Category: Excel

Dec.05, 2009 Lookup a value and find max date
Comments(83)

Category: Dates, Excel

Dec.04, 2009 Filter unique distinct values where adjacent cells contain search string in excel
Comments(16)

Category: Excel, Unique distinct values

Dec.02, 2009 Validate duplicates in excel
Comments(0)

Category: Duplicate values, Excel

Nov.30, 2009 Validate unique distinct list in excel
Comments(0)

Category: Excel, Unique distinct values

Nov.30, 2009 Validate unique list in excel
Comments(0)

Category: Excel, Unique values

Nov.26, 2009 Sum values in a range where adjacent cell value equals a criterion in excel
Comments(19)

Category: Excel, Sum

Nov.25, 2009 Search for multiple text strings in multiple cells and use in data validation in excel
Comments(5)

Category: Excel

Nov.23, 2009 Highlight odd/even months using conditional formatting in excel 2007
Comments(0)

Category: Conditional formatting, Dates, Excel, Mod

Nov.22, 2009 Lookup a value in a list and return multiple matches in excel
Comments(9)

Category: Excel, Vlookup

Nov.21, 2009 How to calculate missing months in a given date range
Comments(2)

Category: Dates, Excel, Missing values

Nov.18, 2009 Count date records between two dates in a range in excel
Comments(1)

Category: Count values, Dates, Excel

Nov.16, 2009 Sum values between two dates with criteria in excel
Comments(27)

Category: Excel, Sum

Nov.15, 2009 Most common value between two dates in a range in excel
Comments(0)

Category: Count values, Dates, Excel

Nov.14, 2009 Most common value between two dates in excel
Comments(2)

Category: Count values, Dates, Excel

Nov.14, 2009 Count unique distinct values using date criteria in a range in excel
Comments(0)

Category: Count values, Dates, Excel, Unique distinct values

Nov.12, 2009 Largest value in a range using date criteria in excel
Comments(4)

Category: Dates, Excel

Nov.11, 2009 Lookup min max values within a date range
Comments(7)

Category: Dates, Excel

Nov.09, 2009 Lookup two index columns using min max values and a date range as criteria
Comments(0)

Category: Dates, Excel

Nov.08, 2009 Lookup two index columns returning multiple matches in excel
Comments(0)

Category: Excel

Nov.07, 2009 Text to be on top of column in excel
Comments(4)

Category: Excel, Misc

Nov.07, 2009 Lookup two index columns in excel
Comments(10)

Category: Dates, Excel

Nov.04, 2009 Count matching cell values in two columns in excel
Comments(1)

Category: Count values, Excel

Nov.04, 2009 Create a custom date range in excel
Comments(8)

Category: Dates, Excel

Nov.02, 2009 Create a quartely date range in excel
Comments(0)

Category: Dates, Excel

Nov.01, 2009 Create a monthly date range in excel
Comments(2)

Category: Dates, Excel

Nov.01, 2009 Extract unique values from a range using array formula in excel
Comments(2)

Category: Excel, Unique values

Oct.29, 2009 Count unique text values in a range containing both numerical and text values
Comments(0)

Category: Count values, Excel, Unique values

Oct.26, 2009 Extract and sort text cells from a range containing both numerical and text values
Comments(1)

Category: Excel, Sort values

Oct.25, 2009 5 easy ways to VLOOKUP and return multiple values
Comments(441)

Category: Excel, VLOOKUP and return multiple values

Oct.23, 2009 Extract cell values in a range using a criterion in excel
Comments(5)

Category: Excel

Oct.20, 2009 Filter common text values in range 1 and in range 2 using array formula in excel
Comments(0)

Category: Compare, Excel

Oct.19, 2009 Filter text values existing in range 1 but not in range 2 using array formula in excel
Comments(0)

Category: Compare, Excel

Oct.17, 2009 Filter unique distinct list sorted based on sum of adjacent values using array formula in excel
Comments(10)

Category: Excel, Sorted unique distinct values

Oct.15, 2009 Filter unique values from a range using array formula in excel
Comments(2)

Category: Excel, Unique values

Oct.13, 2009 Filter unique values sorted from A to Z
Comments(0)

Category: Excel, Sort values, Unique values

Oct.12, 2009 Filter unique text values from a range containing both numerical and text values in excel
Comments(0)

Category: Excel, Unique values

Oct.10, 2009 Extract duplicate text values from a range containing both numerical and text values in excel
Comments(0)

Category: Duplicate values, Excel

Oct.09, 2009 Extract dates and adjacent value in a range using a date critera in excel
Comments(0)

Category: Dates, Excel

Oct.07, 2009 Create a list with most recent data available in excel
Comments(1)

Category: Compare, Excel

Oct.05, 2009 Count unique distinct text values in a range in excel
Comments(6)

Category: Count values, Excel, Unique distinct values

Oct.04, 2009 Create a unique distinct text list from a range containing both numerical and text values in excel
Comments(0)

Category: Excel, Unique distinct values

Oct.01, 2009 Lookup with multiple criteria and display multiple search results using excel formula, part 4
Comments(27)

Category: Excel, Search/Find

Sep.29, 2009 Extract numbers and text from a range using array formula in excel
Comments(1)

Category: Excel, Sort values

Sep.28, 2009 Extract all rows from a range that meet criteria in one column
Comments(35)

Category: Excel, VLOOKUP and return multiple values

Sep.28, 2009 Identify largest text value in a column using array formula in excel
Comments(3)

Category: Excel

Sep.27, 2009 Sort text values by length using array formula in excel
Comments(0)

Category: Excel, Sort values

Sep.26, 2009 Create unique distinct list sorted based on text length using array formula
Comments(0)

Category: Excel, Sorted unique distinct values

Sep.24, 2009 Unique distinct list sorted based on occurrance in a column in excel
Comments(0)

Category: Excel, Sorted unique distinct values

Sep.22, 2009 Unique distinct list from a column sorted A to Z using array formula
Comments(6)

Category: Excel, Sorted unique distinct values

Sep.20, 2009 Identify missing numbers in a range in excel
Comments(5)

Category: Excel, Missing values

Sep.18, 2009 Create a list of all numbers or text in a column in excel
Comments(0)

Category: Excel

Sep.16, 2009 Extract a unique distinct list sorted alphabetically removing blanks from a range
Comments(21)

Category: Excel, Sorted unique distinct values

Sep.15, 2009 Count unique distinct records in a date range and a numeric range in excel
Comments(0)

Category: Count unique distinct values, Count values, Excel

Sep.14, 2009 Create a list of dates with blanks between quarters in excel
Comments(6)

Category: Dates, Excel, Misc

Sep.13, 2009 Count unique records between two dates in excel
Comments(2)

Category: Count values, Dates, Excel, Unique distinct values, Unique values

Sep.09, 2009 Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel part 2
Comments(0)

Category: Conditional formatting, Excel

Sep.08, 2009 How to highlight max and min value in every month in excel
Comments(7)

Category: Conditional formatting, Dates, Excel

Sep.06, 2009 Count unique distinct months in excel
Comments(0)

Category: Count unique distinct values, Count values, Excel

Sep.04, 2009 Identify missing three character alpha code numbers in excel
Comments(1)

Category: Excel, Missing values

Sep.02, 2009 Filter duplicates from two columns combined and sort from A to Z using array formula in excel
Comments(2)

Category: Combine/Merge, Duplicate values, Excel, Sort values

Aug.31, 2009 Find min and max unique and duplicate numerical values
Comments(4)

Category: Duplicate values, Excel, Unique values

Aug.29, 2009 Reverse a list ignoring blanks in excel
Comments(0)

Category: Excel, Misc, Sort values

Aug.26, 2009 List names whos date has past in excel
Comments(1)

Category: Dates, Excel

Aug.26, 2009 Calculate occurences the past 90 days in excel
Comments(1)

Category: Count values, Dates, Excel

Aug.24, 2009 Search and display all cells that contain all search strings in excel
Comments(15)

Category: Excel, Search/Find

Aug.23, 2009 Sum text cells using criteria in excel
Comments(1)

Category: Excel, Misc

Aug.21, 2009 Highlight more than once taken online course in any given day in excel
Comments(0)

Category: Conditional formatting, Excel

Aug.19, 2009 Sort a range by occurence using array formula in excel
Comments(4)

Category: Excel, Sort values

Aug.17, 2009 Comparing two columns and sum unique values using array formula in excel
Comments(0)

Category: Compare, Excel, Unique values

Aug.16, 2009 Search and display a range of values in excel
Comments(17)

Category: Excel

Aug.13, 2009 Lookup with multiple criteria and display multiple search results using excel formula, part 3
Comments(16)

Category: Excel

Aug.12, 2009 Filter common values between two ranges using array formula in excel
Comments(1)

Category: Compare, Excel

Aug.12, 2009 Filter values existing in range 1 but not in range 2 using array formula in excel
Comments(0)

Category: Compare, Excel

Aug.10, 2009 Filter common values from three columns in excel
Comments(4)

Category: Compare, Excel

Aug.09, 2009 Filter unique distinct values from two ranges combined in excel 2007
Comments(2)

Category: Excel, Unique distinct values

Aug.06, 2009 Filter duplicate rows and sort by date using array formula in excel
Comments(0)

Category: Dates, Duplicate values, Excel

Aug.05, 2009 Filter unique rows and sort by date using array formula in excel
Comments(10)

Category: Excel, Unique values

Aug.04, 2009 Advanced custom date filter in Excel 2007
Comments(4)

Category: Advanced filter, Dates, Excel

Aug.02, 2009 How to filter values between 0.5 and 1.5 from two columns in excel 2007
Comments(0)

Category: Excel

Aug.01, 2009 Sort a range from A to Z using array formula in excel
Comments(3)

Category: Excel, Sort values

Jul.30, 2009 Highlight unique distinct values in two ranges combined using conditional formatting in excel
Comments(1)

Category: Compare, Conditional formatting, Excel, Unique distinct values

Jul.28, 2009 Extract a unique distinct list sorted from A-Z from range in excel
Comments(3)

Category: Excel, Sorted unique distinct values, Unique distinct values

Jul.26, 2009 Highlight duplicate values in two ranges combined using conditional formatting in excel
Comments(1)

Category: Compare, Conditional formatting, Excel

Jul.25, 2009 Exact word in string without using vba in excel
Comments(25)

Category: Excel, Misc

Jul.23, 2009 Highlight smallest duplicate value in a column using conditional formatting in excel
Comments(0)

Category: Conditional formatting, Excel

Jul.21, 2009 Extract a list of alphabetically sorted duplicates from a column
Comments(1)

Category: Duplicate values, Excel, Sort values

Jul.20, 2009 Highlight duplicate values in a range using conditional formatting in excel
Comments(2)

Category: Conditional formatting, Excel

Jul.19, 2009 Highlight unique values and unique distinct values in a range using conditional formatting in excel
Comments(1)

Category: Conditional formatting, Excel, Unique distinct values, Unique values

Jul.17, 2009 Extract largest values from two columns using array formula in excel
Comments(8)

Category: Excel

Jul.15, 2009 Search for multiple text strings in multiple cells in excel, part 2
Comments(32)

Category: Excel, Search/Find

Jul.14, 2009 Count unique values and unique distinct values in three ranges combined in excel
Comments(0)

Category: Count unique distinct values, Count values, Excel

Jul.13, 2009 Extract duplicates from a range using excel array formula
Comments(0)

Category: Duplicate values, Excel

Jul.11, 2009 Count unique values and unique distinct values in two ranges combined
Comments(0)

Category: Count unique distinct values, Count values, Excel

Jul.11, 2009 Count occurences of a specific text string in a column in excel
Comments(9)

Category: Count text values, Count values, Excel

Jul.09, 2009 Search for a text string in a data set and return matching records
Comments(28)

Category: Excel, Search/Find, VLOOKUP and return multiple values

Jul.09, 2009 Search for a cell value in a dataset
Comments(1)

Category: Excel, VLOOKUP and return multiple values

Jul.07, 2009 Count unique and unique distinct values in a multicolumn range in excel
Comments(0)

Category: Count unique distinct values, Count values, Excel

Jul.06, 2009 Count text that occurs multiple times in excel cell
Comments(9)

Category: Count text values, Excel

Jul.05, 2009 Count unique distinct values in two columns with date criteria in excel
Comments(0)

Category: Count unique distinct values, Count values, Excel

Jul.03, 2009 How to create a list of random unique numbers in excel
Comments(102)

Category: Excel, Random

Jul.03, 2009 Web statistics and most popular articles in June
Comments(0)

Category: Excel

Jul.01, 2009 Sort text cells alphabetically from two columns using excel array formula
Comments(13)

Category: Excel, Sort values

Jun.29, 2009 Merge two columns into one list in excel
Comments(50)

Category: Combine/Merge, Excel

Jun.28, 2009 Merge three columns into one list in excel
Comments(26)

Category: Combine/Merge, Excel

Jun.27, 2009 How to create a unique distinct list where other columns meet two criteria
Comments(19)

Category: Excel, Unique distinct values

Jun.25, 2009 Sum only if unique value in another column in excel
Comments(0)

Category: Excel, Sum, Unique values

Jun.24, 2009 Looking up data in a cross reference table
Comments(19)

Category: Cross reference table, Excel

Jun.23, 2009 Extract a list of duplicates from three columns combined using array formula in excel
Comments(7)

Category: Duplicate values, Excel

Jun.22, 2009 Extract a list of duplicates from a column
Comments(41)

Category: Duplicate values, Excel

Jun.22, 2009 Extract a list of duplicates from two columns combined using array formula in excel
Comments(2)

Category: Duplicate values, Excel

Jun.21, 2009 Lookup with multiple criteria and display multiple search results using excel formula, part 2
Comments(3)

Category: Excel

Jun.20, 2009 Extract a unique distinct list from three columns
Comments(31)

Category: Excel, Unique distinct values

Jun.16, 2009 Extract a unique distinct list from two columns
Comments(79)

Category: Excel, Unique distinct values

Jun.16, 2009 Create a date range using excel formula
Comments(142)

Category: Dates, Excel

Jun.15, 2009 Identify missing values in two columns using excel formula
Comments(4)

Category: Excel, Missing values

Jun.13, 2009 Identify missing values in a column using excel formula
Comments(25)

Category: Excel, Missing values

Jun.11, 2009 Count unique distinct values in three columns combined in excel
Comments(2)

Category: Count unique distinct values, Count values, Excel

Jun.10, 2009 Count unique distinct values in two columns in excel
Comments(14)

Category: Count unique distinct values, Count values, Excel

Jun.09, 2009 Count unique distinct values in a column
Comments(26)

Category: Count unique distinct values, Count values, Excel

Jun.08, 2009 Most popular excel articles in May
Comments(0)

Category: Excel

Jun.06, 2009 Sorting numbers and text cells descending also removing blanks using array formula in excel
Comments(0)

Category: Excel

Jun.06, 2009 Sorting numbers and text cells also removing blanks using an array formula
Comments(22)

Category: Excel

Jun.04, 2009 Highlight the second or more duplicates in two lists using conditional formatting
Comments(0)

Category: Excel, Highlight duplicates

Jun.03, 2009 Highlight common values in two lists using conditional formatting in excel
Comments(0)

Category: Conditional formatting, Excel

Jun.02, 2009 Sort dates within a date range using excel array formula
Comments(23)

Category: Excel, Sort values

May.31, 2009 Extract dates using a drop down list in excel
Comments(3)

Category: Dates, Drop down lists, Excel

May.31, 2009 Extract distinct unique sorted year and month list from a date series in excel
Comments(1)

Category: Excel

May.27, 2009 Create a dynamic border to your list using excel conditional formatting
Comments(5)

Category: Conditional formatting, Excel

May.26, 2009 Split values equally into groups using excel array formula
Comments(11)

Category: Excel, Split values

May.25, 2009 Create a drop down list containing only unique distinct alphabetically sorted text values using excel array formula
Comments(76)

Category: Drop down lists, Excel

May.22, 2009 Find the largest number in a dynamic column using excel formula
Comments(1)

Category: Excel

May.21, 2009 Lookup between two lists of data to highlight missing data using conditional formatting in excel
Comments(0)

Category: Conditional formatting, Excel, Missing values

May.20, 2009 Highlight duplicates using conditional formatting in excel
Comments(1)

Category: Conditional formatting, Excel

May.19, 2009 How to filter out every second row using excel formula
Comments(0)

Category: Excel

May.18, 2009 Finding the nearest date in a range of dates using excel formula
Comments(42)

Category: Dates, Excel

May.17, 2009 Color every second row using conditional formatting in excel
Comments(6)

Category: Excel

May.17, 2009 Prevent duplicates using dynamic conditional formatting in excel
Comments(3)

Category: Excel

May.14, 2009 Lookup with multiple criteria and display multiple search results using excel formula
Comments(47)

Category: Excel, Search/Find

May.13, 2009 Highlight duplicates where an adjacent column is in a date interval using conditional formatting in excel
Comments(2)

Category: Excel

May.12, 2009 Create a unique distinct list from a date range
Comments(4)

Category: Dates, Excel, Unique distinct values

May.10, 2009 Highlight dates within a date range using conditional formatting
Comments(15)

Category: Conditional formatting, Excel

May.09, 2009 Create a repeating list of numbers from 1 to Nth value
Comments(2)

Category: Excel, Mod

May.08, 2009 Identify duplicate invoice records using conditional formatting
Comments(3)

Category: Excel, Invoice

May.07, 2009 Identify duplicate invoice records
Comments(1)

Category: Excel, Invoice

May.06, 2009 How to color every cell in excel
Comments(0)

Category: Excel

May.05, 2009 Invert a list using named ranges
Comments(0)

Category: Excel

May.04, 2009 Invert a list using cell references in excel
Comments(0)

Category: Excel

May.03, 2009 Unique distinct list to be created from a column where an adjacent column has text cell values
Comments(5)

Category: Excel, Unique distinct values

May.03, 2009 Create a list of distinct values from a list where an adjacent cell value meets a criteria
Comments(15)

Category: Excel, Unique distinct values

May.01, 2009 Create a list of duplicates where adjacent cell value meets a condition
Comments(0)

Category: Duplicate values, Excel

Apr.30, 2009 Highlight duplicates where adjacent cell value meets criteria using conditional formatting
Comments(2)

Category: Excel

Apr.28, 2009 Group similar cell values on same row in excel
Comments(0)

Category: Excel

Apr.26, 2009 How to rank uniquely with criteria in excel
Comments(1)

Category: Excel, Rank

Apr.25, 2009 How to rank text uniquely in excel
Comments(21)

Category: Excel, Rank

Apr.24, 2009 Create a unique distinct list and sort by occurrances from large to small
Comments(15)

Category: Excel, Sorted unique distinct values

Apr.23, 2009 How to create an array of uniquely ranked duplicate values in excel
Comments(1)

Category: Excel, Rank

Apr.21, 2009 Search for multiple text strings in multiple cells
Comments(17)

Category: Excel, Search/Find

Apr.20, 2009 Sum unique values in excel
Comments(4)

Category: Excel, Unique values

Apr.19, 2009 How to create a unique list using conditional formatting in excel 2007
Comments(3)

Category: Conditional formatting, Excel

Apr.17, 2009 Create and sort distinct list by adjacent cell value size
Comments(1)

Category: Excel, Sorted unique distinct values

Apr.16, 2009 Create unique distinct list from column where an adjacent column meets criteria
Comments(2)

Category: Excel, Unique distinct values

Apr.15, 2009 Insert a new row at the top every time a value has been entered
Comments(1)

Category: Excel

Apr.14, 2009 Create a unique distinct alphabetically sorted list extracted from a column
Comments(53)

Category: Excel, Sorted unique distinct values

Apr.13, 2009 Max or min out of two columns
Comments(0)

Category: Excel

Apr.11, 2009 How to automatically fill all blanks with missing data or formula
Comments(0)

Category: Blank cells, Excel, Missing values

Apr.10, 2009 Create unique list from two columns
Comments(10)

Category: Excel, Unique values

Apr.08, 2009 Merge two lists
Comments(2)

Category: Excel

Apr.07, 2009 Sorting date ranges in excel
Comments(0)

Category: Excel

Apr.06, 2009 Conditional formatting highlights more than 10 if there are duplicates
Comments(0)

Category: Excel

Apr.05, 2009 Determine the sum between a range of dates for a specific currency
Comments(0)

Category: Excel

Apr.04, 2009 Sort cell values into categories, part 2
Comments(2)

Category: Excel

Apr.03, 2009 Sort cell values into categories
Comments(7)

Category: Excel, Split values

Apr.02, 2009 Count records between two dates in excel
Comments(22)

Category: Count values, Dates, Excel

Apr.01, 2009 Split first and last names in excel and then sort them alphabetically
Comments(3)

Category: Excel

Mar.31, 2009 How to extract a list of duplicates from a column in excel
Comments(4)

Category: Duplicate values, Excel

Mar.30, 2009 5 easy ways to extract unique distinct values
Comments(149)

Category: Advanced filter, Excel, Unique distinct values, Unique values

Mar.29, 2009 Return row reference of largest to smallest
Comments(6)

Category: Excel

Mar.28, 2009 Next upcoming date from list
Comments(2)

Category: Excel

Mar.27, 2009 Sort a column alphabetically
Comments(81)

Category: Excel, Sort values

Mar.26, 2009 How to sort text cells filtered by two dates, part 2
Comments(0)

Category: Excel

Mar.25, 2009 Extract all rows that contain a value between this and that
Comments(20)

Category: Excel, VLOOKUP and return multiple values

Mar.24, 2009 How to sort cells filtered by two dates
Comments(12)

Category: Dates, Excel, Sort values

Mar.23, 2009 How to find out if a number is between two dates
Comments(0)

Category: Excel

Mar.20, 2009 Delete blanks and errors in a list
Comments(0)

Category: Blank cells, Excel

Mar.19, 2009 Search three columns on three sheets, part 2
Comments(0)

Category: Excel

Mar.18, 2009 Search three columns on three sheets
Comments(0)

Category: Excel

Mar.17, 2009 Find missing numbers in a range from multiple columns
Comments(1)

Category: Excel, Missing values

Mar.16, 2009 Unique distinct values from multiple columns using array formula
Comments(23)

Category: Excel, Unique distinct values

Mar.13, 2009 Count number of times a string exist in multiple cells using excel formula
Comments(19)

Category: Count text values, Count values, Excel

Mar.12, 2009 A more userfriendly version of: Automatically filter unique row records from multiple columns
Comments(0)

Category: Excel

Mar.11, 2009 Excel 2007: Calculate machine utilization
Comments(0)

Category: Dates, Excel

Mar.10, 2009 Filter a unique distinct list and remove blanks
Comments(24)

Category: Excel, Unique distinct values

Mar.09, 2009 Filter records between two dates
Comments(6)

Category: Dates, Excel, VLOOKUP and return multiple values

Mar.06, 2009 How to count unique distinct records in a date range
Comments(6)

Category: Count unique distinct values, Count values, Excel

Mar.05, 2009 How many common cell values are there in list 1 and 2?
Comments(2)

Category: Compare, Count values, Excel

Mar.04, 2009 How to automatically calculate a specific day of a month
Comments(0)

Category: Dates, Excel

Mar.03, 2009 Excel template: School attendance register
Comments(0)

Category: Excel

Mar.02, 2009 merge two sheets with array formula
Comments(0)

Category: Excel

Feb.27, 2009 How to remove common values between two columns
Comments(1)

Category: Compare, Excel

Feb.25, 2009 excel find weekday in period
Comments(0)

Category: Excel

Feb.23, 2009 Categorize numbers in excel
Comments(2)

Category: Excel

Feb.20, 2009 How to identify two consecutive dates in a list
Comments(0)

Category: Compare, Excel

Feb.18, 2009 How to find duplicates in a range spanning multiple columns?
Comments(3)

Category: Excel

Feb.16, 2009 Finding values in an excel list
Comments(0)

Category: Excel

Feb.13, 2009 How to find common values from two lists
Comments(13)

Category: Compare, Excel

Feb.12, 2009 How to navigate quickly in a complex excel workbook using hyperlinks
Comments(1)

Category: Excel

Feb.09, 2009 Coordinates of cells that are not empty in a range
Comments(0)

Category: Excel

Feb.07, 2009 Get data from same cell references of every sheet in workbook
Comments(0)

Category: Excel

Feb.05, 2009 Excel 2007: How do i remove errors from a cell formula?
Comments(1)

Category: Excel

Feb.03, 2009 How to count unique combined column values
Comments(0)

Category: Count unique distinct values, Count values, Excel

Feb.02, 2009 Lookup Unique based on Multiple Conditions
Comments(0)

Category: Excel, Unique values

Jan.31, 2009 Improve you VLOOKUP formula and return multiple values
Comments(157)

Category: Excel, VLOOKUP and return multiple values

Jan.30, 2009 How to extract email addresses from a excel sheet
Comments(39)

Category: Excel, Filter emails

Jan.29, 2009 How to sum different rates with a date criteria
Comments(0)

Category: Excel

Jan.15, 2009 How to create a useful search formula
Comments(0)

Category: Excel

Jan.14, 2009 Filter unique distinct row records
Comments(2)

Category: Excel, Unique distinct records

Jan.13, 2009 What values are missing in List 1 that exists i List 2?
Comments(4)

Category: Compare, Excel, Missing values

Jan.13, 2009 Multiple cells in a new row
Comments(0)

Category: Excel

Jan.12, 2009 Extract duplicates and their adjacent values
Comments(3)

Category: Duplicate values, Excel

Dec.19, 2008 Get cell addresses from several cells with array formula
Comments(2)

Category: Excel, Misc

Nov.12, 2008 Sum cells with check boxes
Comments(2)

Category: Check-boxes, Excel, Sum

May.05, 2008 Excel: How to calculate negative time
Comments(1)

Category: Excel

Apr.23, 2008 Excel: How to automatically summarize preceding month and year
Comments(0)

Category: Excel

Apr.08, 2008 How to efficiently summarize data by category and month
Comments(0)

Category: Excel

Jan.17, 2008 Excel: Efficiently navigate cells and do fast selections
Comments(0)

Category: Excel

Jan.11, 2008 Excel: Count cells
Comments(0)

Category: Excel

Dec.11, 2007 Excel: How to evaluate a complex formula
Comments(0)

Category: Excel

Dec.10, 2007 Excel: Create a random list of specific text values
Comments(0)

Category: Excel

Dec.10, 2007 Excel: Find the smallest difference between the two closest values
Comments(0)

Category: Excel

Dec.07, 2007 Excel: Dynamic summation through numeric named sheets
Comments(0)

Category: Excel

Dec.05, 2007 Excel: Find closest value
Comments(74)

Category: Excel, Vlookup

Dec.04, 2007 Excel: Vlookup with text and date formatting
Comments(0)

Category: Excel

Dec.04, 2007 Excel: Average but exclude zeros
Comments(0)

Category: Excel

Dec.03, 2007 Excel: Percentage of total number
Comments(0)

Category: Excel

Dec.03, 2007 Excel: Using lookup to categorize numbers
Comments(3)

Category: Excel, Split values

Dec.01, 2007 Office: Display all commands in menu
Comments(0)

Category: Excel, Software, Word

Nov.27, 2007 Excel 2007: Color unique values using conditional formatting
Comments(0)

Category: Excel

Nov.27, 2007 Excel 2007: Color cells that meet criteria using conditional formatting
Comments(2)

Category: Excel

Nov.23, 2007 Excel 2007: Create a template and save time
Comments(1)

Category: Excel

Nov.20, 2007 Excel: Remove rows containing specific dates
Comments(0)

Category: Excel

Nov.19, 2007 Excel 2007: Delete duplicate cell values
Comments(0)

Category: Excel

Nov.15, 2007 Excel: Dynamic charting with drop list
Comments(0)

Category: Excel

Nov.14, 2007 Excel: How to rank by two columns
Comments(0)

Category: Excel, Rank

Nov.12, 2007 Excel and Word 2007: Increase workspace by minimizing the ribbon
Comments(0)

Category: Excel, Software, Word

Nov.09, 2007 Excel 2007: How to freeze first row/column and scroll the others
Comments(0)

Category: Excel

Nov.09, 2007 Excel: Add screentip to your hyperlink
Comments(1)

Category: Excel

Nov.08, 2007 Excel: Regional settings
Comments(1)

Category: Excel

Nov.07, 2007 Excel 2007: How to find errors in a large sheet
Comments(5)

Category: Blank cells, Excel

Nov.07, 2007 Excel 2007: How to not display the formula in the formula bar
Comments(0)

Category: Excel

Nov.05, 2007 Excel: How to invert a list
Comments(1)

Category: Excel

Nov.05, 2007 Excel: Dynamically sum a column
Comments(0)

Category: Excel

Nov.03, 2007 How to create a dynamic chart
Comments(161)

Category: Charts, Excel, Interactive

Nov.01, 2007 Excel: How to remove spaces
Comments(0)

Category: Excel

Nov.01, 2007 Excel: Count rows between two values in a list
Comments(1)

Category: Excel

Oct.30, 2007 Excel: Notify if expired
Comments(0)

Category: Excel

Oct.28, 2007 Excel: Holidays and networkdays
Comments(0)

Category: Excel

Oct.26, 2007 Excel 2007: Collect unique values from several columns
Comments(0)

Category: Excel

Oct.24, 2007 Excel: Upcoming date
Comments(0)

Category: Excel

Oct.22, 2007 Excel: Count the number of a specific weekday in a range
Comments(4)

Category: Excel

Oct.13, 2007 Excel: Select only visible cells
Comments(0)

Category: Excel

Oct.13, 2007 Excel: How to convert to hexadecimal
Comments(0)

Category: Excel

Oct.06, 2007 Excel: Count time
Comments(0)

Category: Excel

Oct.04, 2007 Excel 2007: How to install analysis toolpack
Comments(0)

Category: Excel

Sep.22, 2007 Excel: Convert word address list to excel
Comments(0)

Category: Excel

Sep.17, 2007 Explaining OFFSET function
Comments(2)

Category: Excel, Functions

Sep.16, 2007 Remove blank cells
Comments(111)

Category: Blank cells, Excel

Sep.14, 2007 Excel:Calculate the difference between two dates
Comments(1)

Category: Excel

Sep.13, 2007 Excel: Calculate last date of a specific month
Comments(0)

Category: Excel

Sep.12, 2007 Excel: Count the number of occurances an integer is in a list
Comments(0)

Category: Excel, Search/Find

Sep.09, 2007 Excel: Convert text to integer in formula
Comments(0)

Category: Excel

Sep.08, 2007 Excel: Count unique values in a list
Comments(0)

Category: Excel

Sep.07, 2007 Excel: Count and sum values between specific ranges in a column
Comments(0)

Category: Excel

Sep.04, 2007 Excel: Autosum when a row is inserted
Comments(0)

Category: Excel

Sep.01, 2007 Excel: Find latest date in a list
Comments(0)

Category: Dates, Excel

Sep.01, 2007 Excel: Interactive summation
Comments(0)

Category: Excel

Aug.31, 2007 Excel: Sum automatically specific posts in a list
Comments(0)

Category: Excel

Aug.30, 2007 Excel: Count the number of cells within a range that meet the given condition
Comments(0)

Category: Excel

Aug.29, 2007 Excel: Find the smallest value in a list but bigger than 10.
Comments(0)

Category: Excel

Aug.29, 2007 Excel: Automatically create a numbered list
Comments(0)

Category: Excel

Aug.27, 2007 Excel 2007:How to remove empty cells
Comments(0)

Category: Excel

Aug.20, 2007 Excel:Advanced search between two tables
Comments(0)

Category: Excel

Aug.19, 2007 Excel 2007: Find names and their references in a sheet
Comments(0)

Category: Excel

Aug.17, 2007 Excel: Refer to the same cell regardless of whether the row above the cell is deleted or the cell is moved
Comments(0)

Category: Excel

Aug.16, 2007 Excel: Effectively search and replace specific characters
Comments(0)

Category: Excel

Aug.14, 2007 Print consecutive pagenumbers from several sheets
Comments(0)

Category: Excel, Print

Aug.10, 2007 Sum a filtered column
Comments(0)

Category: Excel, Sum

Aug.08, 2007 Excel: Count cells in a specific area
Comments(0)

Category: Excel

Aug.07, 2007 Excel: Find last input value
Comments(0)

Category: Excel

Aug.06, 2007 Find largest value in a table and return adjacent cell value
Comments(2)

Category: Excel

Jul.30, 2007 Print headers on every page
Comments(0)

Category: Excel, Print

Jul.10, 2007 Excel:Rotate text to save space
Comments(0)

Category: Excel

Jul.04, 2007 Get a better overview within word 2007 and excel 2007
Comments(0)

Category: Excel, Word

Jan.26, 2007 Excel 2003: How to format numbers as text
Comments(0)

Category: Excel

Jan.01, 2007 Components of a excel chart
Comments(0)

Category: Excel

Dec.10, 2006 Why use R1C1?
Comments(0)

Category: Excel

Dec.02, 2006 Creating transparent bars in excel 2003 and excel 2007 charts
Comments(0)

Category: Excel

Nov.03, 2006 Transpose a column of values to values in a row
Comments(0)

Category: Excel

Oct.31, 2006 Powerful way to search an excel list automatically
Comments(0)

Category: Excel

Sep.15, 2006 How to find duplicates in a Microsoft Excel list
Comments(0)

Category: Excel

Sep.01, 2006 Increase sheet readability in excel
Comments(0)

Category: Excel

Aug.20, 2006 Learn how to create a stock chart in excel
Comments(1)

Category: Excel, stock chart

« previous entries

Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
Don´t forget to add my RSS feed and subscribe to new blog articles by email.
Sign up for free blog updates

Email
Search website
Popular categories

Charts

Compare

Conditional formatting

Count values

Dates

Drop down lists

Misc

Pivot tables

Sort values

Tables

Templates

UDF

VBA

Vlookup
9,988 subscribers