Get Digital Help
  • Home
  • Functions
  • Formulas
  • Charts
  • CF
  • Pivot tables
  • VBA
  • Archive
  • Contact

All articles sorted by date


Date Article
Oct.18, 2018 How to count workdays between two dates
Oct.18, 2018 How to use the JOIN function [VBA]
Oct.18, 2018 Highlight cells containing string [Conditional formatting]
Oct.18, 2018 How to add a moving average to a chart
Oct.16, 2018 How to use the FORECAST function
Oct.16, 2018 How to insert icons representing cell values [Conditional formatting]
Oct.16, 2018 How to use the INTERCEPT function
Oct.16, 2018 How to add a linear trendline to a chart
Oct.15, 2018 How to customize the chart legend
Oct.15, 2018 How to create a combined chart – Column and Line on secondary axis
Oct.15, 2018 How to create color scales [Conditional Formatting]
Oct.15, 2018 How to use the F.DIST.RT function
Oct.12, 2018 How to use the F.DIST function
Oct.12, 2018 How to add Data Bars to your worksheet
Oct.10, 2018 How to use the FDIST function
Oct.10, 2018 Two y-axes in one chart
Oct.10, 2018 Highlight text values
Oct.09, 2018 How to use the EXPONDIST function
Oct.09, 2018 How to add and customize chart data labels
Oct.08, 2018 How to customize chart tick marks
Oct.08, 2018 How to use the BINOM.INV function
Oct.08, 2018 How to use the CRITBINOM function
Oct.06, 2018 How to customize a chart data series
Oct.05, 2018 How to use the CHISQ.TEST function
Oct.05, 2018 How to use the CHITEST function
Oct.04, 2018 How to use the COVAR function
Oct.04, 2018 How to use the COVARIANCE.S function
Oct.04, 2018 How to use the COVARIANCE.P function
Oct.04, 2018 How to create a sparkline – Win/Loss
Oct.02, 2018 How to use the COTH function
Oct.02, 2018 How to use the XOR function
Oct.02, 2018 How to customize chart axis titles
Oct.01, 2018 How to customize the plot area
Oct.01, 2018 How to customize the chart title
Sep.29, 2018 How to customize the chart area
Sep.28, 2018 How to use the CHISQ.INV.RT function
Sep.28, 2018 How to create a sparkline – Column
Sep.28, 2018 How to use the CHISQ.INV function
Sep.27, 2018 How to create a sparkline – Line
Sep.27, 2018 How to use the CHIINV function
Sep.26, 2018 How to use the CHISQ.DIST.RT function
Sep.26, 2018 How to create a candlestick chart
Sep.26, 2018 How to use the CHISQ.DIST function
Sep.26, 2018 How to create a surface chart
Sep.26, 2018 How to use the CHIDIST function
Sep.25, 2018 How to use the BINOM.DIST function
Sep.25, 2018 How to create a funnel chart
Sep.25, 2018 How to use the BINOMDIST function
Sep.24, 2018 How to use the BETA.INV function
Sep.24, 2018 How to create a Box and Whisker chart
Sep.24, 2018 How to use the BETAINV function
Sep.22, 2018 How to use the BETA.DIST function
Sep.21, 2018 How to use the BETADIST function
Sep.21, 2018 How to create a Pareto chart
Sep.21, 2018 How to use the RANK.EQ function
Sep.20, 2018 How to use the CONFIDENCE.T function
Sep.20, 2018 How to create a histogram chart
Sep.20, 2018 How to use the CONFIDENCE.NORM function
Sep.19, 2018 How to create a combined Column and Line chart
Sep.19, 2018 How to use the MODE.SNGL function
Sep.19, 2018 How to use the FLOOR.PRECISE function
Sep.14, 2018 How to use the DELTA function
Sep.13, 2018 How to create a waterfall chart
Sep.13, 2018 How to use the DOLLARFR function
Sep.12, 2018 How to create a doughnut chart
Sep.12, 2018 How to use the CSC function
Sep.12, 2018 How to create a radar chart
Sep.11, 2018 How to use the CUMIPMT function
Sep.11, 2018 How to use the CUMPRINC function
Sep.11, 2018 How to create a treemap chart
Sep.11, 2018 How to use the IPMT function
Sep.10, 2018 How to create a sunburst chart
Sep.10, 2018 How to use the GROWTH function
Sep.06, 2018 How to use the PPMT function
Sep.06, 2018 How to create an area chart
Sep.04, 2018 How to use the DB function
Sep.04, 2018 How to use the ERROR.TYPE function
Sep.04, 2018 How to use the GCD function
Sep.03, 2018 How to create a bubble chart
Sep.03, 2018 How to use the GEOMEAN function
Sep.03, 2018 How to use the GAMMA function
Sep.03, 2018 Label line chart series
Aug.31, 2018 How to use the RANGE.OFFSET property
Aug.30, 2018 How to use the SGN function [VBA]
Aug.30, 2018 How to create a scatter chart
Aug.30, 2018 How to use the WORKDAY function
Aug.29, 2018 How to use the YEARFRAC function
Aug.29, 2018 Group chart categories
Aug.29, 2018 How to use the FIX function [VBA]
Aug.29, 2018 How to use the INT function [VBA]
Aug.28, 2018 How to create a pie chart
Aug.28, 2018 How to use the SLOPE function
Aug.28, 2018 How to use the RANGE.FIND method
Aug.27, 2018 How to use the SKEW function
Aug.27, 2018 How to create a line chart
Aug.24, 2018 How to use the PROB function
Aug.24, 2018 How to create a bar chart
Aug.22, 2018 How to use the PRICEMAT function
Aug.21, 2018 How to create a 100% stacked column chart
Aug.18, 2018 How to use the PMT function
Aug.06, 2018 How to use the PHI function
Jul.31, 2018 How to use the PDURATION function
Jul.23, 2018 How to use the CONCATENATE function
Jul.13, 2018 Convert column number to column letter
Jul.03, 2018 Get date ranges from a schedule
Jun.25, 2018 How to replace part of formula in all cells
Jun.18, 2018 Copy data from workbooks in folder and subfolders
Jun.11, 2018 Extract unique distinct records from two data sets
Jun.05, 2018 How to position month and year between chart tick marks
May.29, 2018 How to copy non contiguous cell ranges
May.16, 2018 Search for a file in folder and subfolders (VBA)
May.09, 2018 How to use the NOMINAL function
May.03, 2018 How to use the MUNIT function
Apr.24, 2018 How to use the RAND function
Apr.23, 2018 How to use the MULTINOMIAL function
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 chart with 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 MODE.MULT 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 Calculate specific 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 How to create a 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 add horizontal line to chart
Sep.18, 2015 Primary data is hidden behind secondary data
Sep.07, 2015 How to enter an array formula
Aug.24, 2015 Highlight a column in a stacked column chart
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 Sort based on frequency row-wise
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 comma separated values [UDF]
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 How to animate 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 column 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 rows of 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 [Form Controls]
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]
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 cells and formulas that return nothing
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 generate random numbers and text
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 Working with 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 yearly 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.04, 2013 Convert array formula to a regular formula
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 Plot 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 groups 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 Expanding 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
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 cells between a given value
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 Filter unique distinct records using criteria
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 records
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
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 (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.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.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
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
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 Extract unique distinct values 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
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 True round-robin tournament in Excel
Oct.09, 2010 Highlight records based on overlapping date ranges and a condition
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.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 Sort numbers inside (and outside) number ranges
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 Plot 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.12, 2010 Extracting unique distinct text values from a closed workbook in excel (formula)
May.05, 2010 List all unique events in a month
May.02, 2010 Sort numeric values by proximity to a given number
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 based on week
Apr.12, 2010 Remove duplicates based on date
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 Extract unique and duplicate numbers from multiple sheets
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
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
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 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 a 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
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 containing string in a range
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 that begins with criterion
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
Nov.30, 2009 Validate unique distinct list
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
Nov.14, 2009 Most frequent value between two dates
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
Nov.07, 2009 Lookup two index columns
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
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
Aug.31, 2009 Find min and max unique and duplicate numerical values
Aug.29, 2009 Reverse a list ignoring blanks
Aug.26, 2009 List names whos date has past in excel
Aug.26, 2009 Count past 90 days based on a condition
Aug.24, 2009 Search and display all cells that contain all search strings in excel
Aug.23, 2009 Sum values containing text based on a condition
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
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.01, 2009 Sort a range from A to Z [Array formula]
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 numbers in a multi-column 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.01, 2009 Sort text cells alphabetically from two columns
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
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 numbers in two columns based on a numerical range
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.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.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.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.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.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.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.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.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.07, 2009 Sorting date ranges in excel
Apr.06, 2009 Conditional formatting highlights more than 10 if there are duplicates
Apr.03, 2009 Sort cell values into categories
Apr.02, 2009 Count dates inside a date range
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.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.20, 2009 Delete blanks and errors in a list
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.11, 2009 Calculate machine utilization
Mar.10, 2009 Extract 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 calculate a date based on specific weekday in a month
Feb.27, 2009 How to extract not common values between two columns
Feb.20, 2009 How to identify two consecutive dates in a list
Feb.13, 2009 Extract shared values between two columns
Feb.12, 2009 How to navigate quickly in a complex workbook using hyperlinks
Feb.02, 2009 Extract unique distinct records based on a criterion
Jan.30, 2009 How to extract email addresses from an Excel sheet
Jan.15, 2009 How to search for a string in a cell range
Jan.14, 2009 Filter unique distinct records
Jan.13, 2009 What values are missing in List 1 that exists i List 2?
Nov.12, 2008 Sum cells with check boxes
Dec.05, 2007 Find closest value
Dec.04, 2007 AVERAGE ignore 0 (zero)
Nov.15, 2007 Dynamic chart with drop list
Nov.07, 2007 How to find errors in a worksheet
Nov.03, 2007 How to create a dynamic chart
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.01, 2007 Find latest date in a list
Aug.29, 2007 Find the smallest value in a list that is larger than a number
Aug.29, 2007 Create a numbered list
Aug.20, 2007 Choose between two data sets to VLOOKUP
Aug.19, 2007 List all named ranges and their cell references
Aug.14, 2007 Print consecutive page numbers across multiple worksheets
Aug.10, 2007 Sum only visible cells
Jul.30, 2007 Repeat headers on every page you print
Jul.10, 2007 Rotate text to save space
Jan.26, 2007 How to format numbers as text
Jan.01, 2007 Excel chart components
Dec.10, 2006 Why use R1C1 reference style?
Sep.01, 2006 Improve worksheet readability
Aug.20, 2006 How to create a stock chart