Excel - Get Digital Help

Archive for Excel

Date	Article
Apr.18, 2018	How to use the MINIFS function
Apr.18, 2018	How to use the MINA function
Apr.18, 2018	If cell has value
Apr.17, 2018	How to use the MINVERSE function
Apr.17, 2018	Count a given pattern in a cell value
Apr.17, 2018	How to create a stacked column chart
Apr.16, 2018	Four ways to resize a chart
Apr.16, 2018	How to use the NORM.INV function
Apr.16, 2018	How to use the SPLIT function [VBA]
Apr.14, 2018	How to customize chart axis
Apr.13, 2018	How to graph a Normal Distribution
Apr.13, 2018	How to use the NORM.DIST function
Apr.12, 2018	How to use the WEBSERVICE function
Apr.12, 2018	Extract k-th word in cell value
Apr.12, 2018	How to create a COLUMN chart
Apr.11, 2018	How to align a chart with the cell grid
Apr.11, 2018	If cell contains any text
Apr.10, 2018	How to delete empty rows
Apr.10, 2018	How to use the VAR.S function
Apr.10, 2018	How to select cells with data
Apr.10, 2018	How to use the VAR.P function
Apr.10, 2018	How to find blank cells
Apr.09, 2018	How to use the DVARP function
Apr.09, 2018	How to quickly select blank cells
Apr.09, 2018	How to add a macro to your Excel Quick Access Toolbar
Apr.03, 2018	How to quickly select a cell range
Apr.02, 2018	Highlight cells based on coordinates
Mar.29, 2018	How to use the DSUM function
Mar.29, 2018	How to use the DSTDEVP function
Mar.29, 2018	How to use the DSTDEV function
Mar.28, 2018	How to use the DPRODUCT function
Mar.27, 2018	How to use the DMIN function
Mar.27, 2018	How to use the DMAX function
Mar.27, 2018	How to use the DGET function
Mar.27, 2018	How to use the DCOUNTA function
Mar.27, 2018	How to use the DCOUNT function
Mar.26, 2018	How to use the DAVERAGE function
Mar.26, 2018	How to use the FORECAST.LINEAR function
Mar.26, 2018	Count cells with text
Mar.25, 2018	Count rows with data
Mar.23, 2018	How to use the BITXOR function
Mar.23, 2018	How to use the BITRSHIFT function
Mar.23, 2018	How to use the BITOR function
Mar.22, 2018	Count cells equal to any value in a list
Mar.21, 2018	How to use the BITLSHIFT function
Mar.21, 2018	How to use the BITAND function
Mar.21, 2018	How to use the BIN2OCT function
Mar.21, 2018	How to use the BIN2HEX function
Mar.21, 2018	How to use the BIN2DEC function
Mar.20, 2018	How to use the BASE function
Mar.20, 2018	How to use the AVEDEV function
Mar.20, 2018	How to use the ATANH function
Mar.20, 2018	How to use the ATAN2 function
Mar.20, 2018	How to use the ATAN function
Mar.19, 2018	How to use the ASINH function
Mar.19, 2018	How to convert radians to fractions of pi
Mar.19, 2018	How to use the ASIN function
Mar.19, 2018	How to use the ASC function
Mar.19, 2018	How to use the ACCRINTM function
Mar.16, 2018	How to use the ACCRINT function
Mar.16, 2018	How to use the ACOTH function
Mar.16, 2018	How to use the ACOT function
Mar.16, 2018	How to use the ACOSH function
Mar.16, 2018	How to use the ACOS function
Mar.15, 2018	How to use the NA function
Mar.15, 2018	How to use the TYPE function
Mar.15, 2018	How to use the TRUNC function
Mar.15, 2018	How to use the TRIMMEAN function
Mar.14, 2018	How to use the TREND function
Mar.14, 2018	How to use the SERIESSUM function
Mar.14, 2018	How to use the SECH function
Mar.14, 2018	How to use the COT function
Mar.14, 2018	How to use the COSH function
Mar.13, 2018	How to use the SINH function
Mar.13, 2018	How to use the TANH function
Mar.13, 2018	How to use the SUMXMY2 function
Mar.13, 2018	How to use the SUMX2PY2 function
Mar.13, 2018	How to use the SUMX2MY2 function
Mar.13, 2018	How to use the SUMSQ function
Mar.13, 2018	How to use the STDEVPA function
Mar.13, 2018	How to use the STANDARDIZE function
Mar.13, 2018	How to use the STDEV.S function
Mar.13, 2018	How to use the STDEV.P function
Mar.09, 2018	How to use the SEC function
Mar.09, 2018	How to use the RANK.AVG function
Mar.09, 2018	How to use the QUARTILE.INC function
Mar.09, 2018	How to use the FLOOR.MATH function
Mar.09, 2018	How to count overlapping time
Mar.08, 2018	How to use the FIXED function
Mar.08, 2018	How to use the FACTDOUBLE function
Mar.07, 2018	How to use the EXPON.DIST function
Mar.07, 2018	How to use the EOMONTH function
Mar.06, 2018	How to use the ENCODEURL function
Mar.06, 2018	How to use the EFFECT function
Mar.06, 2018	How to use the EDATE function
Mar.05, 2018	How to use the DEC2OCT function
Mar.05, 2018	How to use the DEC2HEX function
Mar.05, 2018	How to use the DEC2BIN function
Mar.05, 2018	How to use the DECIMAL function
Mar.02, 2018	How to use the DAYS function
Mar.02, 2018	How to use the CONVERT function
Mar.01, 2018	DATEVALUE function not working
Mar.01, 2018	How to use the CONFIDENCE function
Feb.28, 2018	How to use the CORREL function
Feb.28, 2018	How to use the CONCAT function
Feb.28, 2018	How to use the COMPLEX function
Feb.28, 2018	How to use the CEILING function
Feb.27, 2018	How to use the AVERAGEA function
Feb.27, 2018	How to use the AREAS function
Feb.27, 2018	How to use the LCM function
Feb.27, 2018	How to use the ISPMT function
Feb.26, 2018	How to use the NOW function
Feb.26, 2018	How to use the TIMEVALUE function
Feb.26, 2018	Match a range value containing both text and numerical characters
Feb.26, 2018	How to use the SWITCH function
Feb.23, 2018	How to use the STDEVA function
Feb.22, 2018	How to use the STDEV function
Feb.21, 2018	How to use the SHEETS function
Feb.20, 2018	How to use the SHEET function
Feb.19, 2018	How to use the RATE function
Feb.16, 2018	How to use the MROUND function
Feb.16, 2018	How to use the NOT function
Feb.16, 2018	SMALL function with multiple cell ranges
Feb.15, 2018	How to use the SQRT function
Feb.15, 2018	How to use the SIGN function
Feb.15, 2018	How to use the T function
Feb.15, 2018	How to use the N function
Feb.14, 2018	How to use the MODEMULT function
Feb.14, 2018	How to use the MODE function
Feb.14, 2018	How to use the MEDIAN function
Feb.14, 2018	How to use the LOG function
Feb.13, 2018	How to use the LN function
Feb.13, 2018	How to use the INFO function
Feb.13, 2018	How to use the FV function
Feb.13, 2018	How to use the PERMUTATIONA function
Feb.12, 2018	How to use the COMBINA function
Feb.12, 2018	How to filter using OR logic between columns [Formula]
Feb.12, 2018	How to filter using OR logic between columns [Advanced Filter]
Feb.12, 2018	How to use the PRODUCT function
Feb.09, 2018	Rearrange cells in a cell range to vertically distributed values
Feb.09, 2018	Get the latest revision
Feb.08, 2018	How to use the TRUE function
Feb.08, 2018	How to use the DEGREES function
Feb.08, 2018	How to use the RANK function
Feb.08, 2018	How to use the RADIANS function
Feb.08, 2018	How to use the PI function
Feb.07, 2018	How to use the FORMULATEXT function
Feb.07, 2018	How to use the ISFORMULA function
Feb.07, 2018	How to use the ISODD function
Feb.07, 2018	How to use the ISERR function
Feb.07, 2018	How to use the FIND function
Feb.06, 2018	How to use the ISNA function
Feb.06, 2018	How to use the ISREF function
Feb.06, 2018	How to use the ISNONTEXT function
Feb.06, 2018	How to use the ISLOGICAL function
Feb.06, 2018	How to use the ISTEXT function
Feb.05, 2018	How to use the ISERROR function
Feb.05, 2018	How to use the ISBLANK function
Feb.05, 2018	How to use the POWER function
Feb.05, 2018	How to graph an equation
Feb.05, 2018	How to extract numbers from a cell value
Feb.02, 2018	How to use the VALUE function
Feb.02, 2018	How to use the TODAY function
Feb.02, 2018	How to use the DATEVALUE function
Feb.02, 2018	How to use the WITH … END WITH statement
Feb.02, 2018	How to use the DATEDIF function
Feb.01, 2018	How to use the DO LOOP statement
Feb.01, 2018	How to use the TAN function
Feb.01, 2018	How to use the COS function
Feb.01, 2018	How to use the SIN function
Feb.01, 2018	How to use the EVEN function
Jan.31, 2018	Highlight opposite numbers
Jan.31, 2018	How to use the MINUTE function
Jan.31, 2018	How to use the EXP function
Jan.31, 2018	How to use the RANDBETWEEN function
Jan.31, 2018	How to use the SECOND function
Jan.30, 2018	How to use the HOUR function
Jan.30, 2018	How to use the FLOOR function
Jan.30, 2018	How to use the FALSE function
Jan.30, 2018	How to use the FACT function
Jan.30, 2018	How to use the IFNA function
Jan.29, 2018	How to use the IFS function
Jan.29, 2018	How to use the INT function
Jan.29, 2018	How to use the CLEAN function
Jan.29, 2018	How to use the COMBIN function
Jan.29, 2018	How to use the PERMUT function
Jan.26, 2018	How to remove unwanted characters in a cell
Jan.26, 2018	How to use the LEN function
Jan.26, 2018	Identify all characters in a cell value
Jan.26, 2018	How to use the COUNTBLANK function
Jan.26, 2018	How to use the COUNTA function
Jan.25, 2018	How to use the COLUMNS function
Jan.25, 2018	How to use the ROWS function
Jan.25, 2018	How to use SELECT CASE statement
Jan.24, 2018	How to use the MAX function
Jan.24, 2018	How to use the MAXIFS function
Jan.24, 2018	How to use the LARGE function
Jan.23, 2018	How to use the CELL function
Jan.23, 2018	How to use the COUNT function
Jan.22, 2018	How to use the CHAR function
Jan.22, 2018	How to use the CODE function
Jan.22, 2018	How to use the COLUMN function
Jan.19, 2018	How to use the FOR NEXT statement
Jan.19, 2018	How to use the AVERAGEIFS function
Jan.19, 2018	How to use the AVERAGEIF function
Jan.19, 2018	How to use the AGGREGATE function
Jan.18, 2018	How to use the NETWORKDAYS function
Jan.17, 2018	How to use the ADDRESS function
Jan.17, 2018	How to use the TIME function
Jan.17, 2018	How to use the ISNUMBER function
Jan.16, 2018	WEEKDAYS between two dates
Jan.16, 2018	How to use the WEEKDAY function
Jan.16, 2018	How to use the DAY function
Jan.16, 2018	How to use the MONTH function
Jan.16, 2018	How to use the LOWER function
Jan.15, 2018	How to use the REPT function
Jan.15, 2018	How to use the SUBSTITUTE function
Jan.15, 2018	How to use the UPPER function
Jan.15, 2018	How to use the EXACT function
Jan.15, 2018	How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
Jan.12, 2018	How to use the TRIM function
Jan.12, 2018	Extract last word in cell
Jan.11, 2018	How to remove numbers from a cell value
Jan.11, 2018	How to use the ABS function
Jan.11, 2018	Extract first word in cell
Jan.10, 2018	LEFT function for numbers
Jan.10, 2018	CHOOSE function from list
Jan.09, 2018	How to use the RIGHT function
Jan.09, 2018	How to use the LEFT function
Jan.09, 2018	How to use the MID function
Jan.08, 2018	How to use the MIN function
Jan.08, 2018	How to use the SUMIFS function
Jan.07, 2018	How to use the CHOOSE function
Dec.27, 2017	Highlight empty cells
Dec.21, 2017	INDEX and MATCH – multiple criteria and multiple results
Dec.20, 2017	Count cells containing text from list
Dec.20, 2017	AVERAGE based on criteria
Dec.19, 2017	If cell contains multiple values
Dec.19, 2017	Days between two dates
Dec.18, 2017	SMALL function – INDEX MATCH
Dec.18, 2017	How to ignore zeros using the SMALL function
Dec.15, 2017	SMALL function – multiple criteria
Dec.14, 2017	SMALL function for text
Dec.14, 2017	AVERAGE ignore NA()
Dec.13, 2017	How to AVERAGE time
Dec.13, 2017	AVERAGE ignore blanks
Dec.13, 2017	How to use the AVERAGE function
Dec.12, 2017	SMALL function with duplicates
Dec.12, 2017	SUMPRODUCT and nested IF functions
Dec.11, 2017	SUMPRODUCT if not blank
Dec.08, 2017	SUMPRODUCT and IF function
Dec.07, 2017	SUMPRODUCT – multiple criteria
Dec.06, 2017	INDEX MATCH – Case sensitive
Dec.06, 2017	Excel formula not working
Dec.05, 2017	INDEX MATCH – multiple results
Dec.05, 2017	Compare two columns and highlight differences
Dec.04, 2017	Match two columns
Dec.04, 2017	If cell equals value from list
Dec.01, 2017	Sum by group
Dec.01, 2017	Learn how to use the SUBTOTAL function
Nov.30, 2017	If cell contains text from list
Nov.30, 2017	IF with OR function
Nov.29, 2017	INDEX MATCH with multiple criteria
Nov.29, 2017	Sum between two dates
Nov.28, 2017	COUNTIF not blank cells
Nov.27, 2017	If cell contains text
Nov.27, 2017	How to use the OR function
Nov.24, 2017	How to use the AND function
Nov.23, 2017	Use IF + COUNTIF to perform numerous conditions
Nov.23, 2017	IF with AND function – multiple conditions
Nov.22, 2017	Nested IF functions
Nov.22, 2017	How to use the YEAR function
Nov.21, 2017	How to use the HYPERLINK function
Nov.20, 2017	Two-dimensional lookup using two tables
Nov.17, 2017	How to use the DATE function
Nov.14, 2017	How to use the TEXT function
Nov.06, 2017	How to use the SUMIF function
Nov.01, 2017	Filter values based on numerical ranges
Oct.25, 2017	Running totals
Oct.16, 2017	Find empty cells and sum cells above
Oct.12, 2017	Rearrange values
Oct.05, 2017	Opening a workbook runs a macro automatically
Sep.04, 2017	How to extract a case sensitive unique list from a column
Aug.28, 2017	Count unique distinct values based on a condition
Aug.25, 2017	Lookup multiple values in different columns and return multiple values
Aug.24, 2017	Extract a list of alphabetically sorted duplicates based on a condition
Aug.19, 2017	Extract duplicate values with exceptions
Aug.19, 2017	Filter duplicate values using critera
Aug.17, 2017	Concatenate cell values based on a condition [No VBA]
Aug.16, 2017	Find last value in a column
Aug.15, 2017	Unique distinct list sorted alphabetically based on a condition
Aug.15, 2017	Find last matching value in an unsorted table
Aug.11, 2017	Use VLOOKUP and return multiple values sorted from A to Z
Aug.03, 2017	Concatenate unique distinct values
Jul.22, 2017	How to use the SUM function
Jul.18, 2017	How to use the HLOOKUP function
Jul.11, 2017	How to use the VLOOKUP function
Jul.07, 2017	Nested Search
Jul.06, 2017	Track progress
May.31, 2017	Use VLOOKUP to calculate discount percentages
May.24, 2017	Count matching strings using regular expressions
May.16, 2017	Reverse two-way lookups
May.09, 2017	Excel map chart
Apr.27, 2017	Split search value using delimiter and search for each substring
Apr.25, 2017	Fetching values from ThingSpeak using vba
Mar.30, 2017	Count colored cells
Mar.16, 2017	Become more productive – Learn Excel Defined Tables
Feb.27, 2017	Rotating unique groups with no repeat
Feb.17, 2017	Time sheet for work
Feb.07, 2017	Extract cell references from a formula
Dec.20, 2016	Filter records that contain numeric values
Dec.02, 2016	Working with the LIKE OPERATOR
Nov.16, 2016	Build a stock chart with two series
Nov.10, 2016	Calendar – monthly view
Oct.24, 2016	Round-robin tournament
Oct.11, 2016	List permutations with repetition and how many to choose from
Sep.29, 2016	How to use DIALOG BOXES
Aug.26, 2016	List all permutations with a condition
Jul.04, 2016	Discover Pivot Tables – Excel’s most powerful feature and also least known
Jun.07, 2016	How to use the TEXTJOIN function
Jun.01, 2016	Working with ARRAY VARIABLES
Apr.21, 2016	Stock market trends – pivots
Apr.12, 2016	Count identical numbers in two columns but items must be in same row
Mar.22, 2016	Compare two columns in different worksheets
Mar.16, 2016	Sort values by corresponding text
Feb.15, 2016	Sort names by value
Feb.03, 2016	Multiply cells efficiently
Jan.26, 2016	Resize a range of values
Jan.18, 2016	Website statistics for 2015
Nov.13, 2015	Follow stock market trends – trailing stop
Nov.03, 2015	Follow stock market trends – Moving Average
Oct.19, 2015	Dynamic stock chart
Oct.09, 2015	Find the highest status and when it was acquired
Sep.22, 2015	How to create an horizontal line in a chart
Sep.18, 2015	Primary data is hidden behind secondary data
Sep.07, 2015	Learn the basics of Excel arrays
Aug.24, 2015	Highlight a column in a stacked column chart (no vba)
Aug.14, 2015	Color chart bars by value
Aug.12, 2015	Count overlapping days across multiple date ranges
Aug.06, 2015	Find date given day and week
Aug.03, 2015	Improve your X Y Scatter Chart with custom data labels
Jun.30, 2015	How to use the TRANSPOSE function
Jun.17, 2015	Calculate time between time zones
Jun.10, 2015	Find and replace a text string in file names, folder name and subfolders
Jun.04, 2015	Sum numerical ranges
Jun.02, 2015	Unzip files in folder and subfolders
May.29, 2015	Count per row
May.25, 2015	Frequency bug?
May.20, 2015	Count overlapping days in multiple date ranges, part 2
May.18, 2015	Count overlapping days in multiple date ranges
May.13, 2015	Find missing dates in a set of date ranges
May.12, 2015	Dynamic scoreboard
May.07, 2015	Working with overlapping date ranges
May.05, 2015	Use MEDIAN function to calculate overlapping ranges
Apr.22, 2015	Team generator
Apr.16, 2015	Working with LIST BOXES (Form Controls)
Apr.10, 2015	Split expenses calculator
Mar.31, 2015	Count contiguous values
Mar.25, 2015	List all hyperlinks in worksheet
Mar.19, 2015	Add new items to a drop down list automatically
Mar.10, 2015	QUOTIENT function
Mar.03, 2015	Permutations with and without repetition
Feb.26, 2015	Return all combinations
Feb.19, 2015	Find numbers closest to sum
Feb.11, 2015	Filter duplicate files in a folder and sub folders
Feb.06, 2015	Compare file names in two different folder locations and their sub folders
Jan.27, 2015	Save selected sheets to a pdf file
Jan.19, 2015	Find cells containing formulas with literal (hard coded) values
Jan.09, 2015	How to use the LOOKUP function
Dec.30, 2014	How to enter array formulas in merged cells
Dec.16, 2014	How to use the INDIRECT function
Dec.09, 2014	Find the longest/smallest consecutive sequence of a value [VBA]
Dec.02, 2014	Split text across columns
Nov.18, 2014	Count the number of cells within a range that match multiple comma separated values
Nov.11, 2014	Find the longest/shortest consecutive sequence of a value
Nov.04, 2014	Find a sequence of values – wildcard search
Oct.28, 2014	Find a sequence
Oct.23, 2014	Search all workbooks in a folder and sub folders
Oct.14, 2014	List comments [VBA]
Oct.08, 2014	Use pictures in a column chart
Sep.30, 2014	Build a comparison chart
Sep.23, 2014	Add pictures to a chart axis
Sep.18, 2014	Group data by quarters
Aug.20, 2014	Copy filtered Excel tables [VBA]
Jul.16, 2014	Highlight row and column of selected cell
Jul.04, 2014	Optimize pick path in a warehouse
Jun.26, 2014	Compare two lists and filter unique values where the sum in one column doesn’t match the other column
Jun.16, 2014	A quicker A * pathfinding algorithm
Jun.03, 2014	How to use the MOD function
May.27, 2014	Finding the shortest path – A * pathfinding
May.20, 2014	Basic substitution cipher
May.07, 2014	Move data to workbooks
Apr.29, 2014	Learn Excel’s Subtotal feature
Apr.18, 2014	Sort and return unique single digit numbers
Apr.16, 2014	Print screen the entire worksheet
Apr.14, 2014	Highlight unique values in a filtered excel table
Apr.08, 2014	Customize Excel maze
Apr.02, 2014	Solve a maze
Mar.31, 2014	Build a maze
Mar.21, 2014	Shortest path
Mar.14, 2014	Animating a line chart
Feb.27, 2014	Merge tables based on a condition
Feb.18, 2014	An animated bar chart
Feb.11, 2014	Find the most urgent work orders
Feb.07, 2014	Find last matching value in an unsorted list
Feb.04, 2014	Multi-level To-Do list template
Jan.28, 2014	An animated excel chart
Jan.21, 2014	Highlight a group of chart bars
Jan.14, 2014	Team ranking with criteria
Jan.08, 2014	Search all workbooks in a folder
Dec.29, 2013	5 most popular blog posts 2013
Dec.20, 2013	All you need to know about calculating NAV units for your stock portfolio
Dec.13, 2013	Lookup and return multiple values sorted in a custom order
Dec.03, 2013	Add your personal excel macros to the ribbon
Nov.26, 2013	Identify overlapping records
Nov.22, 2013	Remove print preview lines (Page Breaks)
Nov.12, 2013	Compare values between two columns and filter values existing in only one column
Nov.06, 2013	Quickly change chart data source
Oct.30, 2013	Working with TEXT BOXES [VBA]
Oct.25, 2013	Show and hide a picture [VBA]
Oct.22, 2013	Multiple wildcard lookups and include or exclude criteria
Oct.18, 2013	Lookup with an unknown number of criteria
Oct.15, 2013	Click a button to make specific worksheets hidden or visible (vba)
Oct.11, 2013	Click a cell to make a column hidden or visible [VBA]
Oct.08, 2013	Scroll through a data set [VBA]
Oct.02, 2013	Counting conditionally formatted cells (vba)
Sep.27, 2013	Count cells by cell and font color
Sep.23, 2013	Calculate min and max date among overlapping date ranges and based on a condition
Sep.20, 2013	Select and delete formulas evaluating to an empty text string
Sep.17, 2013	Prevent duplicate records [Data Validation]
Sep.14, 2013	Format fill color on a column chart based on cell color
Sep.10, 2013	Count unique distinct values by cell color
Sep.05, 2013	Pivot table calendar
Aug.30, 2013	Highlight date ranges overlapping selected record [VBA]
Aug.23, 2013	Basic mathematics in excel for school children
Aug.20, 2013	Find out if excel files in a folder are password protected
Aug.15, 2013	Count text strings in formulas [VBA]
Aug.07, 2013	Quickly select a data set or an excel defined table [HYPERLINK]
Jul.30, 2013	Quickly jump to last row in a data set using excel hyperlink function
Jul.16, 2013	How to use the IFERROR function
Jul.09, 2013	Locate a particular cell in a table
Jul.05, 2013	How to use the RAND function
Jul.03, 2013	Use drop down lists to compare data series in an excel chart
Jun.27, 2013	Hierarchical relationships in an excel chart
Jun.19, 2013	Locate a shape in a workbook
Jun.14, 2013	Interactive candlestick chart
Jun.05, 2013	Find consecutive dates in a cell range
May.31, 2013	How to use the FREQUENCY function
May.27, 2013	Highlight a data series in a line chart
May.24, 2013	Heat map using pictures
May.21, 2013	How to use the SUMPRODUCT function
May.16, 2013	Count students
May.14, 2013	Use a map in an Excel chart
May.06, 2013	How to use the SEARCH function
May.03, 2013	Yet another excel calendar
Apr.26, 2013	How to use the MMULT function
Apr.23, 2013	How to use the SMALL function
Apr.19, 2013	COPY RENAME LIST FILES
Apr.17, 2013	Assign each person with randomly unique objects as a daily activity
Apr.15, 2013	How to use the ROW function
Apr.09, 2013	Highlight duplicates in a filtered Excel defined table
Apr.07, 2013	How to use the COUNTIFS function
Apr.02, 2013	How to use the IF function
Mar.27, 2013	How to use the COUNTIF function
Mar.25, 2013	Days contained in a range that overlap another range
Mar.20, 2013	How to use the MATCH function
Mar.15, 2013	How to use the INDEX function
Mar.13, 2013	Custom data labels in a chart
Mar.08, 2013	Change picture [VBA]
Mar.05, 2013	Heat map calendar
Mar.01, 2013	Lookup using multiple conditions
Feb.27, 2013	Substitute multiple text strings [UDF]
Feb.25, 2013	Sort cell values in corresponding columns
Feb.18, 2013	Count multiple text strings in a cell range
Feb.15, 2013	Move a shape [VBA]
Feb.11, 2013	Sort a table with an array formula
Feb.06, 2013	2012 website statistics
Feb.04, 2013	No more array formulas?
Feb.01, 2013	Dynamic data labels in a chart
Jan.29, 2013	Highlight a column in a stacked column chart
Jan.25, 2013	Highlight events in a calendar
Jan.24, 2013	Highlight a bar in a chart
Jan.18, 2013	Repeat values
Jan.15, 2013	Merge two related tables
Jan.11, 2013	Highlight events overlapping federal holidays
Jan.07, 2013	Lookup multiple values in one cell [UDF]
Jan.03, 2013	Sum security holdings monthly and yearly in a pivot table
Dec.28, 2012	Run a Macro from a Drop Down list [VBA]
Dec.10, 2012	Drop down list changes cell formatting
Dec.05, 2012	Prevent users from entering overlapping date and time ranges
Nov.30, 2012	Group a number of rows together by the first column
Nov.29, 2012	Lookup and return multiple values on the same row from a range excluding blanks
Nov.22, 2012	Find date range
Nov.20, 2012	Find max unique value from a range that have duplicate numbers and blanks
Nov.13, 2012	Monthly time sheet by project
Nov.09, 2012	Analyze trends using pivot tables
Nov.07, 2012	Hide specific columns [VBA]
Nov.05, 2012	Compare your stock portfolio with S&P500 in excel
Oct.31, 2012	VLOOKUP with multiple criteria
Oct.26, 2012	Locate lookup values in a table [HYPERLINK]
Oct.23, 2012	Use Conditional Formatting to do lookups in related tables
Oct.19, 2012	Working with three related tables
Oct.17, 2012	Extract unique distinct values from a related table
Oct.15, 2012	How to use a Table name in Data Validation Lists and Conditional Formatting formulas
Oct.12, 2012	Change bar color in charts [VBA]
Oct.10, 2012	Lookups in a related table (array formula)
Oct.05, 2012	Inventory consumption
Oct.02, 2012	Copy each sheet in active workbook to new workbooks
Sep.27, 2012	Filter values that exists in all three lists
Sep.26, 2012	Copy excel table filter criteria [VBA]
Sep.21, 2012	Quickly search a data set with many criteria
Sep.17, 2012	Create name initials
Sep.12, 2012	Search a table and use the returning value to search another table
Sep.10, 2012	Use a calendar to filter a table
Sep.05, 2012	Excel calendar [VBA]
Sep.03, 2012	Fetch data from another table
Aug.27, 2012	Use filtered table values in a drop down list [VBA]
Aug.22, 2012	Dynamic chart – Display values from a table row or column
Aug.20, 2012	How slow is ReDim Preserve?
Aug.17, 2012	Shift Schedule
Aug.15, 2012	Extract cell references from all cell ranges populated with values in a sheet
Aug.07, 2012	Use a mouse hovering technique to create an interactive chart
Aug.06, 2012	Sort values in a cell using a custom delimiter [VBA]
Jul.31, 2012	Count and visualize specific weekdays in a custom date range
Jul.27, 2012	Visualize date ranges in a calendar part 2
Jul.25, 2012	Quickly create links to sheets, tables, pivot tables and named ranges in a workbook
Jul.23, 2012	Count unique distinct values in a filtered table
Jul.18, 2012	Create links to all sheets in a workbook
Jul.14, 2012	Quickly create new sheets [VBA]
Jul.13, 2012	Adjust stock chart axis automatically
Jul.05, 2012	Insert hyperlinks to all files in current folder
Jul.02, 2012	Match a criterion and extract multiple corresponding table headers
Jun.29, 2012	Plot buy and sell points in an excel chart using two moving averages
Jun.27, 2012	Add buy and sell points to a stock chart
Jun.18, 2012	Interactive Excel chart [VBA]
Jun.12, 2012	Highlight numbers within specific ranges
Jun.06, 2012	Sort values in an Excel table [VBA]
Jun.04, 2012	Normalize data, part 2
May.28, 2012	Search two related tables simultaneously [VBA]
May.23, 2012	Create comments in cells whose value is larger than the column width
May.22, 2012	Lookup multiple values in different columns and return a single value
May.21, 2012	Learn how to return values depending on how you enter the UDF
May.19, 2012	Select a cell in a table and the chart updates automatically [VBA]
May.16, 2012	Excel template: Getting Things Done [VBA]
May.11, 2012	Disable autofit column widths for all pivot tables in a sheet
May.07, 2012	Normalize data [VBA]
May.02, 2012	Date ranges: Weeks within a month
Apr.30, 2012	Add values to different sheets [VBA]
Apr.26, 2012	Add values to a table [VBA]
Apr.23, 2012	Unique distinct records sorted by frequency
Apr.21, 2012	Count the number of groupings of each value
Apr.21, 2012	Use a drop down list to extract and concatenate unique distinct values
Apr.18, 2012	Add or remove a value in a drop down list
Apr.16, 2012	Count a specific weekday in a date range
Apr.10, 2012	Open Excel files in a folder [VBA]
Apr.02, 2012	Copy table design settings [VBA]
Mar.30, 2012	Auto populate a sheet
Mar.28, 2012	Search for a text string and return multiple adjacent values
Mar.26, 2012	Toggle a macro on/off using a button
Mar.23, 2012	Calculate dates in each step in a project based on a finish date
Mar.19, 2012	Use a drop down list to select company info in header (vba)
Mar.14, 2012	Automate data entry [VBA]
Mar.12, 2012	Apply data validation lists dynamically [VBA]
Mar.09, 2012	Workbook log [VBA]
Mar.05, 2012	Working with Conditional Formatting formulas
Feb.28, 2012	How to create random numbers, text strings, dates and time values
Feb.26, 2012	Categorize data entry values [VBA]
Feb.22, 2012	Dependent data validation lists in multiple rows
Feb.20, 2012	Holiday planner
Feb.13, 2012	Advanced Gantt Chart Template
Feb.10, 2012	Auto resize columns as you type
Feb.07, 2012	Highlight lookup values
Jan.31, 2012	Tracking calls in excel
Jan.27, 2012	Free School Schedule Template
Jan.24, 2012	Copy a cell range whose size is likely to change from time to time [VBA]
Jan.20, 2012	Easily identify groups of duplicate rows
Jan.17, 2012	List all open workbooks and corresponding sheets [VBA]
Jan.14, 2012	Basic data entry [VBA]
Jan.09, 2012	List all tables and corresponding headers in a workbook [VBA]
Jan.02, 2012	Basic invoice template
Dec.23, 2011	Filter weeks from a date range
Dec.21, 2011	Working with COMBO BOXES [Form Controls]
Dec.09, 2011	Excel charts: Multiple series and named ranges
Dec.07, 2011	Use a drop down list to search and return multiple values
Dec.02, 2011	Change chart data range using a Drop Down List [VBA]
Nov.29, 2011	Change pivot table data source using a drop down list
Nov.24, 2011	How many of a specific weekday falls between a start date and an end date except holidays
Nov.17, 2011	Extract numbers from a value
Nov.11, 2011	Select numbers in each permutation
Nov.08, 2011	Dynamic Gantt charts in excel 2007
Nov.04, 2011	Filter an Excel table using the selection change event [VBA]
Nov.02, 2011	Extract unique distinct values from a filtered table [udf and array formula]
Oct.28, 2011	Zen archery problem
Oct.24, 2011	Populate a combobox with values from a pivot table [VBA]
Oct.19, 2011	Excel array formula: Enter a value in a cell and instantly populate adjacent cells
Oct.17, 2011	Excel: Look for values containing a lookup value and return multiple values horizontally
Oct.12, 2011	Copy selected rows (checkboxes) (2/2)
Oct.10, 2011	Add checkboxes to a sheet (1/2) [VBA]
Oct.06, 2011	Count how many numbers between a specific value occurring multiple times
Oct.05, 2011	Add values to a data validation list [VBA]
Sep.29, 2011	Follow hyperlinks in a pivot table
Sep.20, 2011	List five smallest numbers, excluding zeros
Sep.16, 2011	Quickly filter a column in an excel table
Sep.14, 2011	Reorganize data [UDF]
Sep.12, 2011	Populate a list box with visible unique values from an Excel table [VBA]
Sep.07, 2011	Populate a combo box (form control) [VBA]
Aug.31, 2011	Excel table: Filter unique distinct rows and use additional filters at the same time
Aug.26, 2011	Excel table: Filter unique distinct values (array formula)
Aug.25, 2011	Count unique distinct values in a large dataset with a date criterion
Aug.23, 2011	Two-way lookup using multiple tables [UDF]
Aug.19, 2011	Count entries between date and time criteria
Aug.18, 2011	Vlookup visible data in a table and return multiple values
Aug.15, 2011	Compare two tables: Remove common rows
Aug.13, 2011	Create a custom-made item on the shortcut menu [VBA]
Aug.09, 2011	Sumif across multiple sheets [UDF]
Aug.05, 2011	Insert rows for missing values
Aug.03, 2011	Select cell A1 on all sheets before you close a workbook [VBA]
Aug.01, 2011	Filter unique distinct and duplicate values from a large data set in excel 2007
Jul.28, 2011	Filter unique distinct values, sorted and blanks removed
Jul.27, 2011	Excel udf: Import historical stock prices from yahoo – added features
Jul.22, 2011	How to sort a table in a custom order in excel [No formula]
Jul.17, 2011	Vlookup across multiple sheets
Jul.12, 2011	Count unique distinct values that meet multiple criteria
Jul.08, 2011	Import historical stock prices from yahoo [UDF]
Jul.04, 2011	Sum cells based on criteria
Jun.30, 2011	Identify duplicate files in excel
Jun.29, 2011	List files in a folder and subfolders [UDF]
Jun.22, 2011	Vlookup a cell range and return multiple values
Jun.20, 2011	Count unique distinct values in an Excel Pivot Table
Jun.17, 2011	Merge matching rows in excel (text values)
Jun.16, 2011	Excel toolbox: Save your custom functions and macros in an Add-In
Jun.13, 2011	Auto refresh a pivot table
Jun.09, 2011	7 days (weekly) date ranges
Jun.07, 2011	Search each column for a string each and return multiple records – OR logic
Jun.02, 2011	Compare price lists
Jun.01, 2011	How to compare two data sets
May.25, 2011	Excel 2007 pivot table: Count unique distinct records (rows)
May.24, 2011	Sum unique distinct invoices
May.23, 2011	Count unique distinct records with a date and column criteria
May.20, 2011	Google spreadsheets: Pivot tables
May.19, 2011	Filter unique distinct records with a condition
May.17, 2011	Use dynamic ranges to automatically add new values
May.13, 2011	Vlookup – Return multiple unique distinct values
May.10, 2011	Chandoo’s excel VBA classes are now open!
May.09, 2011	Calculate average of last 10 data with possible blank cells
May.06, 2011	Filter unique distinct records (case sensitive)
May.03, 2011	Filter unique distinct values (case sensitive) [Excel UDF]
Apr.28, 2011	Create a dynamic named range
Apr.26, 2011	How to create a dynamic pivot table and refresh automatically
Apr.21, 2011	Combine cell ranges eliminating blanks
Apr.19, 2011	Bill reminder in excel
Apr.17, 2011	Dependent drop down lists – Enable/Disable selection filter
Apr.12, 2011	Running totals within date range
Apr.06, 2011	How to highlight differences in price lists
Apr.05, 2011	Word frequency [UDF]
Apr.04, 2011	Fuzzy lookups [UDF]
Mar.28, 2011	Filter records within two dates and search for a text string
Mar.24, 2011	Fuzzy vlookup [Array formula]
Mar.23, 2011	Text to columns: Split words in a cell [Array formula]
Mar.21, 2011	Quickly highlight records containing text strings in excel (AND Logic)
Mar.16, 2011	Filter emails from an excel range [UDF]
Mar.12, 2011	Highlight records [AND logic]
Mar.09, 2011	Highlight records – multiple criteria [OR logic]
Mar.07, 2011	Cash drawer bill extractor template in excel
Mar.03, 2011	Filter duplicate records
Mar.02, 2011	Highlight closest number
Feb.27, 2011	Merge matching rows in excel
Feb.25, 2011	Find positive and negative amounts that net to zero [UDF]
Feb.22, 2011	Find numbers in sum [UDF]
Feb.16, 2011	Filter overlapping date ranges in excel 2007
Feb.15, 2011	Count digits and ignore duplicates in any line
Feb.09, 2011	Quickly concatenate values into one cell [No VBA]
Feb.08, 2011	Tracking a stock portfolio #2 in excel
Feb.03, 2011	List permutations without repetition [UDF]
Jan.31, 2011	Tracking a stock portfolio in excel (auto update)
Jan.29, 2011	Create a drop down calendar in excel
Jan.26, 2011	Weekly appointment calendar in excel
Jan.24, 2011	Monthly calendar template #2 in excel
Jan.19, 2011	Monthly calendar template
Jan.17, 2011	Count unique distinct records in Excel
Jan.13, 2011	Compare two lists of data: Filter records occurring in only one list
Jan.12, 2011	Compare two lists of data: Highlight records occurring in only one list
Jan.11, 2011	Compare two lists of data: Highlight common records
Jan.08, 2011	Compare two tables: Filter common records
Jan.04, 2011	Highlight duplicate columns
Jan.03, 2011	Extract duplicate records
Dec.30, 2010	Highlight duplicate records
Dec.30, 2010	List permutations with repetition [UDF]
Dec.22, 2010	Count cells based on a condition and month
Dec.20, 2010	Lookup and return multiple values concatenated into one cell
Dec.15, 2010	Automate excel: Update list with new values
Dec.13, 2010	Use text qualifiers to make text to columns conversion easier [VBA]
Dec.10, 2010	Create a Print button [VBA]
Dec.09, 2010	Select and view invoice [VBA]
Dec.06, 2010	Populate listbox with unique invoice numbers [VBA]
Dec.03, 2010	Edit invoice data [VBA]
Dec.01, 2010	Save invoice data [VBA]
Nov.28, 2010	Invoice template with dependent drop down lists
Nov.26, 2010	Create random dates, Mon to Fri, within a year in excel
Nov.22, 2010	Return multiple matches with wildcard vlookup
Nov.16, 2010	Create dependent drop down lists containing unique distinct values in multiple rows
Nov.15, 2010	Filter values existing only in one out of two ranges [UDF]
Nov.12, 2010	Filter values in common between two cell ranges [UDF]
Nov.11, 2010	Select value based on time and date [VBA]
Nov.09, 2010	Filter duplicates in a large dataset [UDF]
Nov.08, 2010	Compare two columns and show differences
Nov.03, 2010	Select 6 unique and random numbers from 1 to 49 (Lottery) in excel
Nov.02, 2010	Generate list of random dates with criterion
Nov.01, 2010	Remove duplicate text strings based on the 4 last characters
Oct.28, 2010	Apply dependent combo box selections to a filter
Oct.26, 2010	Create a drop down list containing alphabetically sorted values
Oct.22, 2010	Count unique distinct values in a large dataset [UDF]
Oct.20, 2010	List people with the highest scores based on criteria in a pivot table (Excel 2007)
Oct.18, 2010	List people with the highest scores based on criteria in excel
Oct.17, 2010	Remove duplicates and sort dates by each row in excel
Oct.16, 2010	Remove duplicates from a large dataset [UDF]
Oct.12, 2010	Sort a list in random order in excel
Oct.10, 2010	Create a random playlist in excel – True round-robin tournament
Oct.09, 2010	Highlight duplicate values and overlapping dates in excel
Oct.07, 2010	Dynamic team generator in excel
Oct.05, 2010	Create a random playlist
Sep.30, 2010	Team Generator in excel
Sep.28, 2010	Count records between two dates with multiple parameters
Sep.26, 2010	Sort values in parallel in excel, part 2
Sep.24, 2010	Random row from a boolean matrix in excel
Sep.22, 2010	Case sensitive lookup and return multiple values
Sep.21, 2010	Filter unique words from a range [UDF]
Sep.19, 2010	Vlookup with multiple matches returns a different value
Sep.15, 2010	Filter unique distinct words from a cell range [UDF]
Sep.12, 2010	Filter duplicate words from a cell range [UDF]
Sep.10, 2010	Split words in a cell range into a cell each [UDF]
Sep.06, 2010	Consolidate sheets in excel, part 2
Sep.03, 2010	Extract a unique distinct list based on a condition [Pivot Table]
Sep.01, 2010	Extract a unique distinct list and sum amounts based on a condition
Aug.31, 2010	Extract dates from a cell block schedule in excel, part 3
Aug.30, 2010	Extract dates from a cell block schedule in excel, part 2
Aug.29, 2010	Extract dates from a cell block schedule in excel
Aug.23, 2010	Concatenate cell values
Aug.20, 2010	Filter emails spread over several columns in excel
Aug.16, 2010	Search for a cell in a table and then display the column title in excel
Aug.15, 2010	Schedule recurring events in a weekly schedule
Aug.08, 2010	Setting up your work hours in a weekly schedule
Aug.05, 2010	Populate cells dynamically in a weekly schedule
Aug.01, 2010	How to filter numbers inside (and outside) number ranges in excel
Jul.29, 2010	Find empty hours in a weekly schedule
Jul.26, 2010	Count cell blocks
Jul.21, 2010	Schedule recurring expenses in a calendar in excel (Personal Finance)
Jul.17, 2010	Create dependent drop down lists containing unique distinct values
Jul.13, 2010	Count overlapping dates
Jul.11, 2010	Create a unique distinct sorted list containing both numbers text removing blanks
Jul.08, 2010	Filter overlapping dates from date ranges in excel
Jul.04, 2010	Highlight specific time ranges in a weekly schedule
Jul.01, 2010	Weekly schedule template in excel
Jun.28, 2010	Convert date ranges into dates
Jun.22, 2010	Convert dates into date ranges
Jun.20, 2010	List dates outside specified date ranges in excel
Jun.14, 2010	Visualize date ranges in a calendar
Jun.10, 2010	How to use absolute and relative references
Jun.03, 2010	Highlight overlapping date ranges using conditional formatting
May.30, 2010	Identify overlapping date ranges
May.25, 2010	Use a number range when trying to find the frequency of a number in excel
May.22, 2010	How to return the total for orders with more than one item in excel
May.18, 2010	Merge two columns with possible blank cells
May.16, 2010	Count unique and duplicates text values in a closed workbook
May.12, 2010	Extracting unique distinct text values from a closed workbook in excel (formula)
May.11, 2010	Count unique and duplicate numbers in a closed workbook
May.10, 2010	Extract unique distinct numbers from closed workbook in excel (formula)
May.05, 2010	List all unique events in a month
May.02, 2010	Sort numeric values by closest to farthest to a specific number in excel (array formula)
Apr.28, 2010	How to quickly select a non contiguous range
Apr.24, 2010	Highlight duplicates with same date, week or month
Apr.19, 2010	Filter duplicates within same date, week or month in excel
Apr.17, 2010	Count unique distinct values within same week, month or year
Apr.15, 2010	How to count unique distinct occurrences for each date
Apr.13, 2010	Remove duplicates within same month or year
Apr.13, 2010	Remove duplicates in same week in excel
Apr.12, 2010	Remove duplicates on same date in excel
Apr.07, 2010	Lookup values in a range using two or more criteria and return multiple matches in excel, part 2
Apr.05, 2010	Lookup values in a range based on criteria and return multiple values
Mar.31, 2010	Calculate your stock portfolio performance with Net Asset Value based on units in excel
Mar.29, 2010	Consolidate sheets [vba]
Mar.24, 2010	Lookup using two criteria
Mar.22, 2010	Automate net asset value (NAV) calculation on your stock portfolio
Mar.18, 2010	Calculate your stock portfolio performance in excel
Mar.15, 2010	Sum based on multiple criteria
Mar.11, 2010	Categorize values into multiple columns (excel formulas)
Mar.10, 2010	Categorize values into multiple columns [VBA]
Mar.07, 2010	Count unique distinct numbers across multiple sheets (3D range
Mar.04, 2010	Return unique and duplicate numerical data entries from multiple sheets (3D range) in excel
Mar.03, 2010	Split data across multiple sheets [VBA]
Feb.28, 2010	Combine data from multiple sheets
Feb.26, 2010	Calendar with scheduling [vba]
Feb.21, 2010	Dynamic stock chart in excel – Add date ranges
Feb.18, 2010	Extract unique distinct year and months from dates
Feb.16, 2010	Create a dynamic stock chart using a web query and a drop down list in excel
Feb.11, 2010	Match two criteria and return multiple records
Feb.10, 2010	Create a unique distinct list using Advanced Filter in a macro [VBA]
Feb.07, 2010	Scan stock markets in excel
Feb.02, 2010	Extract negative values and adjacent cells in excel
Jan.30, 2010	Stock alerts in excel
Jan.27, 2010	Quickly select a range of values in excel
Jan.24, 2010	Create number sequences
Jan.20, 2010	Excel formula to count cells between two values
Jan.19, 2010	Return value if it exists more then n times
Jan.16, 2010	Filter unique distinct values if value contains specific string [Formula and Advanced Filter]
Jan.14, 2010	Return multiple values if in range in excel
Jan.13, 2010	How to return a value if lookup value is in range
Jan.12, 2010	Sort values in parallel (array formula)
Jan.10, 2010	VLOOKUP of three columns to pull a single record
Jan.08, 2010	Using Excel Solver to schedule employees
Jan.07, 2010	Find positive and negative amounts that net to zero
Jan.05, 2010	Identify numbers in sum using Excel solver
Jan.04, 2010	Sequencing and numbering of batches
Jan.03, 2010	Sum adjacent values from a range using multiple lookup criteria
Jan.03, 2010	Lookup multiple values in a range and return multiple corresponding values
Dec.31, 2009	Sum adjacent values using multiple lookup text values in a column
Dec.29, 2009	Vlookup with 2 or more lookup criteria and return multiple matches
Dec.27, 2009	Filter duplicate values in a range using “contain” condition in excel
Dec.23, 2009	Filter unique text values in a range using “contain” condition in excel
Dec.21, 2009	Filter unique distinct text values in a range using “contain” condition in excel
Dec.17, 2009	Filter duplicate text values in a range using “begins with” criterion in excel
Dec.17, 2009	Filter unique text values using “begins with” criterion in a range in excel
Dec.14, 2009	Filter unique distinct text values using “begins with” criterion in a range using array formula in excel
Dec.13, 2009	Formula for matching a date within a date range
Dec.10, 2009	Count unique values in two lists combined in excel
Dec.10, 2009	Count matching values in one or more columns
Dec.07, 2009	Find records using two numerical criteria
Dec.05, 2009	Find latest date based on a condition
Dec.04, 2009	Filter unique distinct values where adjacent cells contain search string
Dec.02, 2009	Validate duplicates in excel
Nov.30, 2009	Validate unique distinct list in excel
Nov.30, 2009	Validate unique list in excel
Nov.26, 2009	Sum values in a range where adjacent cell value equals a criterion
Nov.25, 2009	Search for multiple text strings in multiple cells and use in data validation
Nov.23, 2009	Highlight odd/even months
Nov.22, 2009	Search values distributed horizontally and return corresponding value
Nov.21, 2009	How to calculate missing months in a given date range
Nov.18, 2009	Count date records between two dates in a range
Nov.16, 2009	Sum values between two dates and based on a condition
Nov.15, 2009	Most common value between two dates in a range in excel
Nov.14, 2009	Most common value between two dates in excel
Nov.14, 2009	Count unique distinct values based on date criteria in a range
Nov.12, 2009	Largest value in a range using date criteria in excel
Nov.11, 2009	Lookup min max values within a date range
Nov.09, 2009	Lookup two index columns using min max values and a date range as criteria
Nov.08, 2009	Lookup two index columns returning multiple matches in excel
Nov.07, 2009	Text to be on top of column in excel
Nov.07, 2009	Lookup two index columns in excel
Nov.04, 2009	Count matching cell values in two columns
Nov.04, 2009	Create a custom date range
Nov.02, 2009	Create a quartely date range
Nov.01, 2009	Create a monthly date range
Nov.01, 2009	Extract unique values from a range
Oct.29, 2009	Count unique text values in a range containing both numerical and text values
Oct.26, 2009	Extract and sort text cells from a range containing both numerical and text values
Oct.25, 2009	5 easy ways to VLOOKUP and return multiple values
Oct.23, 2009	Extract cell values in a range using a criterion in excel
Oct.20, 2009	Filter common text values in two different ranges
Oct.19, 2009	Filter text values existing in the first range but not in the 2nd range
Oct.17, 2009	Extract unique distinct values sorted based on sum of adjacent values
Oct.15, 2009	Filter unique values from a range using array formula in excel
Oct.13, 2009	Filter unique values sorted from A to Z
Oct.12, 2009	Filter unique text values from a range containing both numerical and text values
Oct.10, 2009	Extract duplicate text values from a range containing both numerical and text values
Oct.09, 2009	Extract dates and adjacent value in a range using a date critera in excel
Oct.07, 2009	Create a list with most recent data available
Oct.05, 2009	Count unique distinct text values in a range
Oct.04, 2009	Extract unique distinct text list from a range containing both numerical and text values
Oct.01, 2009	Extract records where all criteria match if not empty
Sep.29, 2009	Extract numbers and text from a range sorted from A to Z
Sep.28, 2009	Extract all rows from a range that meet criteria in one column
Sep.28, 2009	Identify largest text value in a column using array formula in excel
Sep.27, 2009	Sort text values by length using array formula in excel
Sep.26, 2009	Create unique distinct list sorted based on text length using array formula
Sep.24, 2009	Unique distinct list sorted based on occurrance in a column in excel
Sep.22, 2009	Unique distinct list from a column sorted A to Z using array formula
Sep.20, 2009	Identify missing numbers in a range
Sep.18, 2009	Filter numbers or text in a column
Sep.16, 2009	Extract a unique distinct list sorted alphabetically and ignore blanks from a range
Sep.15, 2009	Count unique distinct records in a date range and a numeric range
Sep.14, 2009	Create a list of dates with blanks between quarters in excel
Sep.13, 2009	Count unique records between two dates
Sep.09, 2009	Highlight duplicates based on criteria, part 2
Sep.08, 2009	How to highlight MAX and MIN value based on month
Sep.06, 2009	Count unique distinct months
Sep.04, 2009	Identify missing three character alpha code numbers
Sep.02, 2009	Filter duplicates from two columns combined and sort from A to Z using array formula in excel
Aug.31, 2009	Find min and max unique and duplicate numerical values
Aug.29, 2009	Reverse a list ignoring blanks in excel
Aug.26, 2009	List names whos date has past in excel
Aug.26, 2009	Calculate frequency the past 90 days
Aug.24, 2009	Search and display all cells that contain all search strings in excel
Aug.23, 2009	Sum text cells using criteria
Aug.21, 2009	Highlight more than once taken course in any given day
Aug.19, 2009	Sort a range based on value frequency
Aug.17, 2009	Comparing two columns and sum unique values
Aug.16, 2009	Search and display a range of values in excel
Aug.13, 2009	Search each column for a string each and return multiple records – AND logic
Aug.12, 2009	Filter common values between two ranges
Aug.12, 2009	Filter values occurring in range 1 but not in range 2
Aug.10, 2009	Filter common values from three columns
Aug.09, 2009	Filter unique distinct values from two ranges combined in excel 2007
Aug.06, 2009	Filter duplicate rows and sort by date using array formula in excel
Aug.05, 2009	Filter unique values and sort based on adjacent date
Aug.04, 2009	Advanced custom date filter
Aug.02, 2009	How to filter values between 0.5 and 1.5 from two columns in excel 2007
Aug.01, 2009	Sort a range from A to Z using array formula in excel
Jul.30, 2009	Highlight unique distinct values in two cell ranges
Jul.28, 2009	Extract a unique distinct list sorted from A-Z from range
Jul.26, 2009	Highlight duplicate values in two cell ranges combined
Jul.25, 2009	Exact word in string
Jul.23, 2009	Highlight smallest duplicate number
Jul.21, 2009	Extract a list of alphabetically sorted duplicates from a column
Jul.20, 2009	Highlight duplicate values in a cell range
Jul.19, 2009	Highlight unique values and unique distinct values in a cell range
Jul.17, 2009	Extract largest values from two columns
Jul.15, 2009	Search for multiple text strings in multiple cells in excel, part 2
Jul.14, 2009	Count unique values and unique distinct values in three ranges combined
Jul.13, 2009	Extract duplicates from a range using excel array formula
Jul.11, 2009	Count unique values and unique distinct values in two ranges combined
Jul.11, 2009	Count text string in a range (case sensitive)
Jul.09, 2009	Search for a text string in a data set and return matching records
Jul.09, 2009	Search for a cell value in a dataset
Jul.07, 2009	Count unique and unique distinct values in a multicolumn range
Jul.06, 2009	Count specific text string in a cell
Jul.05, 2009	Count unique distinct values in two columns with date criteria
Jul.03, 2009	How to create a list of random unique numbers
Jul.03, 2009	Web statistics and most popular articles in June
Jul.01, 2009	Sort text cells alphabetically from two columns using excel array formula
Jun.29, 2009	Merge two columns
Jun.28, 2009	Merge three columns into one list in excel
Jun.27, 2009	How to create a unique distinct list where other columns meet two criteria
Jun.25, 2009	Sum number based on if a corresponding value is unique
Jun.24, 2009	How to perform a two-dimensional lookup
Jun.23, 2009	Extract a list of duplicates from three columns combined using array formula in excel
Jun.22, 2009	Extract a list of duplicates from a column
Jun.22, 2009	Extract a list of duplicates from two columns combined using array formula in excel
Jun.21, 2009	A record is returned if both search strings are found on the same row
Jun.20, 2009	Extract a unique distinct list from three columns
Jun.16, 2009	Extract a unique distinct list from two columns
Jun.16, 2009	Create a date range [Formula]
Jun.15, 2009	Identify missing values in two columns using excel formula
Jun.13, 2009	Identify missing numbers in a column
Jun.11, 2009	Count unique distinct values in three columns combined
Jun.10, 2009	Count unique distinct values in two columns
Jun.09, 2009	Count unique distinct values
Jun.08, 2009	Most popular excel articles in May
Jun.06, 2009	Sorting numbers and text cells in an descending order also removing blanks
Jun.06, 2009	Sorting numbers and text cells also removing blanks using an array formula
Jun.04, 2009	Highlight duplicates in two columns
Jun.03, 2009	Compare two columns and highlight values in common
Jun.02, 2009	Sort dates within a date range
May.31, 2009	Extract dates using a drop down list in excel
May.31, 2009	Extract distinct unique sorted year and month list from a date series in excel
May.27, 2009	Dynamic formatting
May.26, 2009	Split values equally into groups
May.25, 2009	Create a drop down list containing only unique distinct alphabetically sorted text values
May.22, 2009	Find the largest number in an expanding cell range
May.21, 2009	Highlight missing values between to columns
May.20, 2009	How to highlight duplicate values
May.19, 2009	How to filter out every second row using excel formula
May.18, 2009	Lookup the nearest date
May.17, 2009	Highlight every other row
May.17, 2009	Prevent duplicates using dynamic conditional formatting in excel
May.14, 2009	Lookup with multiple criteria and return multiple search results
May.13, 2009	Highlight duplicates where an adjacent column is in a date interval using conditional formatting in excel
May.12, 2009	Create a unique distinct list from a date range
May.10, 2009	Highlight dates in a date range
May.09, 2009	Create a repeating list of numbers from 1 to Nth value
May.08, 2009	Identify duplicate invoice records using conditional formatting
May.07, 2009	Identify duplicate invoice records
May.06, 2009	How to color every cell in excel
May.05, 2009	Invert a list using named ranges
May.04, 2009	Invert a list using cell references
May.03, 2009	Create a unique distinct list where a corresponding column has text cell values
May.03, 2009	Create a list of distinct values from a list where an adjacent cell value meets a criteria
May.01, 2009	Create a list of duplicates where adjacent cell value meets a condition
Apr.30, 2009	Highlight duplicates based on criteria, part 1
Apr.28, 2009	Group similar cell values on same row in excel
Apr.26, 2009	How to rank uniquely with criteria in excel
Apr.25, 2009	How to rank text uniquely in excel
Apr.24, 2009	Create a unique distinct list and sort based on frequency
Apr.23, 2009	How to create an array of uniquely ranked duplicate values in excel
Apr.21, 2009	Search for multiple text strings in multiple cells
Apr.20, 2009	Sum unique values in excel
Apr.19, 2009	How to highlight unique distinct values
Apr.17, 2009	Create and sort distinct list by adjacent cell value size
Apr.16, 2009	Create a unique distinct list based on criteria
Apr.15, 2009	Insert a new row at the top every time a value has been entered
Apr.14, 2009	Create a unique distinct alphabetically sorted list
Apr.13, 2009	How to quickly find the maximum or minimum value [Formula]
Apr.11, 2009	How to automatically fill all blanks with missing data or formula
Apr.10, 2009	Extract unique values from two columns
Apr.08, 2009	Merge two lists
Apr.07, 2009	Sorting date ranges in excel
Apr.06, 2009	Conditional formatting highlights more than 10 if there are duplicates
Apr.05, 2009	Determine the sum between a range of dates for a specific currency
Apr.04, 2009	Sort cell values into categories, part 2
Apr.03, 2009	Sort cell values into categories
Apr.02, 2009	Count records between two dates
Apr.01, 2009	Split first and last names and sort them alphabetically
Mar.31, 2009	How to extract a list of duplicates from a column in excel
Mar.30, 2009	5 easy ways to extract unique distinct values
Mar.29, 2009	Return row reference of largest to smallest
Mar.28, 2009	Next upcoming date from list
Mar.27, 2009	Sort a column alphabetically
Mar.26, 2009	How to sort text cells filtered by two dates, part 2
Mar.25, 2009	Extract all rows that contain a value between this and that
Mar.24, 2009	How to sort cells filtered by two dates
Mar.23, 2009	How to find out if a number is between two dates
Mar.20, 2009	Delete blanks and errors in a list
Mar.19, 2009	Search three columns on three sheets, part 2
Mar.18, 2009	Search three columns on three sheets
Mar.17, 2009	Find missing numbers in a range containing multiple columns
Mar.16, 2009	Extract unique distinct values from a multi-column cell range
Mar.13, 2009	Count how many times a string exists in a cell range (case insensitive)
Mar.12, 2009	A more userfriendly version of: Automatically filter unique row records from multiple columns
Mar.11, 2009	Calculate machine utilization
Mar.10, 2009	Filter a unique distinct list and remove blanks
Mar.09, 2009	Extract records between two dates
Mar.06, 2009	How to count unique distinct records in a date range
Mar.05, 2009	How many common cell values are there in list 1 and 2?
Mar.04, 2009	How to automatically calculate a specific day of a month
Mar.03, 2009	Excel template: School attendance register
Mar.02, 2009	merge two sheets with array formula
Feb.27, 2009	How to remove common values between two columns
Feb.23, 2009	Categorize numbers in excel
Feb.20, 2009	How to identify two consecutive dates in a list
Feb.18, 2009	How to find duplicates in a range spanning multiple columns?
Feb.16, 2009	Finding values in an excel list
Feb.13, 2009	Compare two columns for same values [Excel Formula]
Feb.12, 2009	How to navigate quickly in a complex Excel workbook using hyperlinks
Feb.09, 2009	Coordinates of cells that are not empty in a range
Feb.07, 2009	Get data from same cell references of every sheet in workbook
Feb.05, 2009	Excel 2007: How do i remove errors from a cell formula?
Feb.03, 2009	How to count unique combined column values
Feb.02, 2009	Lookup Unique based on Multiple Conditions
Jan.30, 2009	How to extract email addresses from an Excel sheet
Jan.29, 2009	How to sum different rates with a date criteria
Jan.15, 2009	How to create a useful search formula
Jan.14, 2009	Filter unique distinct records
Jan.13, 2009	What values are missing in List 1 that exists i List 2?
Jan.13, 2009	Multiple cells in a new row
Jan.12, 2009	Extract duplicates and their adjacent values
Dec.19, 2008	Get cell addresses from several cells
Nov.12, 2008	Sum cells with check boxes
May.05, 2008	Excel: How to calculate negative time
Apr.23, 2008	Excel: How to automatically summarize preceding month and year
Apr.08, 2008	How to efficiently summarize data by category and month
Jan.17, 2008	Excel: Efficiently navigate cells and do fast selections
Jan.11, 2008	Excel: Count cells
Dec.11, 2007	Excel: How to evaluate a complex formula
Dec.10, 2007	Excel: Create a random list of specific text values
Dec.10, 2007	Excel: Find the smallest difference between the two closest values
Dec.07, 2007	Excel: Dynamic summation through numeric named sheets
Dec.05, 2007	Find closest value
Dec.04, 2007	Excel: Vlookup with text and date formatting
Dec.04, 2007	AVERAGE ignore 0 (zero)
Dec.03, 2007	Excel: Percentage of total number
Dec.03, 2007	Excel: Using lookup to categorize numbers
Dec.01, 2007	Office: Display all commands in menu
Nov.27, 2007	Excel 2007: Color unique values using conditional formatting
Nov.27, 2007	Excel 2007: Color cells that meet criteria using conditional formatting
Nov.23, 2007	Excel 2007: Create a template and save time
Nov.20, 2007	Excel: Remove rows containing specific dates
Nov.19, 2007	Excel 2007: Delete duplicate cell values
Nov.15, 2007	Dynamic chart with drop list
Nov.14, 2007	Excel: How to rank by two columns
Nov.12, 2007	Excel and Word 2007: Increase workspace by minimizing the ribbon
Nov.09, 2007	Excel 2007: How to freeze first row/column and scroll the others
Nov.09, 2007	Excel: Add screentip to your hyperlink
Nov.08, 2007	Excel: Regional settings
Nov.07, 2007	How to find errors in a worksheet
Nov.07, 2007	Excel 2007: How to not display the formula in the formula bar
Nov.05, 2007	Excel: How to invert a list
Nov.05, 2007	Excel: Dynamically sum a column
Nov.03, 2007	How to create a dynamic chart
Nov.01, 2007	Excel: How to remove spaces
Nov.01, 2007	Excel: Count rows between two values in a list
Oct.30, 2007	Excel: Notify if expired
Oct.28, 2007	Excel: Holidays and networkdays
Oct.26, 2007	Excel 2007: Collect unique values from several columns
Oct.24, 2007	Excel: Upcoming date
Oct.22, 2007	Count the number of a specific weekday in a range
Oct.13, 2007	Excel: How to convert to hexadecimal
Oct.06, 2007	Excel: Count time
Oct.04, 2007	Excel 2007: How to install analysis toolpack
Sep.22, 2007	Excel: Convert word address list to excel
Sep.17, 2007	How to use the OFFSET function
Sep.16, 2007	Remove blank cells
Sep.13, 2007	Calculate last date of a given month
Sep.12, 2007	Count the number of times a specific number exists in a list
Sep.09, 2007	Excel: Convert text to integer in formula
Sep.08, 2007	Excel: Count unique values in a list
Sep.07, 2007	Excel: Count and sum values between specific ranges in a column
Sep.04, 2007	Excel: Autosum when a row is inserted
Sep.01, 2007	Find latest date in a list
Sep.01, 2007	Excel: Interactive summation
Aug.31, 2007	Excel: Sum automatically specific posts in a list
Aug.29, 2007	Find the smallest value in a list but bigger than a number
Aug.29, 2007	Excel: Automatically create a numbered list
Aug.27, 2007	Excel 2007:How to remove empty cells
Aug.20, 2007	Excel:Advanced search between two tables
Aug.19, 2007	List all named ranges and their cell references in a worksheet
Aug.17, 2007	Excel: Refer to the same cell regardless of whether the row above the cell is deleted or the cell is moved
Aug.16, 2007	Excel: Effectively search and replace specific characters
Aug.14, 2007	Print consecutive page numbers based on multiple worksheets
Aug.10, 2007	Sum only visible cells
Aug.08, 2007	Count cells in a specific area
Aug.07, 2007	Excel: Find last input value
Aug.06, 2007	Find largest value in a table and return adjacent cell value
Jul.30, 2007	Repeat headers on every page you print
Jul.10, 2007	Excel:Rotate text to save space
Jul.04, 2007	Get a better overview within word 2007 and excel 2007
Jan.26, 2007	Excel 2003: How to format numbers as text
Jan.01, 2007	Components of a excel chart
Dec.10, 2006	Why use R1C1?
Dec.02, 2006	Creating transparent bars in excel 2003 and excel 2007 charts
Nov.03, 2006	Transpose a column of values to values in a row
Oct.31, 2006	Powerful way to search an excel list automatically
Sep.15, 2006	How to find duplicates in a Microsoft Excel list
Sep.01, 2006	Increase sheet readability in excel
Aug.20, 2006	Learn how to create a stock chart in excel

Formula categories

Count

Dates

Extract

Index and Match

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.
Free Blog Emails

Email
Search website