| Date |
Article |
| Dec.13, 2018 |
How to use the YIELD function |
| Dec.12, 2018 |
How to use the SYD function |
| Dec.11, 2018 |
How to use the TBILLEQ function |
| Dec.10, 2018 |
How to use the TBILLPRICE function |
| Dec.07, 2018 |
How to use the TBILLYIELD function |
| Dec.04, 2018 |
How to use the UNICODE function |
| Dec.03, 2018 |
How to use the UNICHAR function |
| Nov.28, 2018 |
How to use the PERCENTRANK.EXC function |
| Nov.26, 2018 |
How to use the PERCENTRANK.INC function |
| Nov.16, 2018 |
Sum unique distinct numbers |
| Nov.16, 2018 |
How to use the PERCENTRANK function |
| Nov.15, 2018 |
Highlight current date |
| Nov.15, 2018 |
How to use the EVALUATE method |
| Nov.14, 2018 |
INDEX MATCH – Last value |
| Nov.14, 2018 |
How to highlight dates based on day of week |
| Nov.14, 2018 |
How to create a combined stacked area and a clustered column chart |
| Nov.13, 2018 |
How to use the QUARTILE.EXC function |
| Nov.13, 2018 |
How to use the QUARTILE function |
| Nov.13, 2018 |
Highlight unique/duplicates [Conditional formatting] |
| Nov.12, 2018 |
How to find the smallest number excluding zeros |
| Nov.09, 2018 |
How to build an arrow chart |
| Nov.07, 2018 |
How to highlight weekends [Conditional Formatting] |
| Nov.07, 2018 |
How to use the LOGNORM.DIST function |
| Nov.06, 2018 |
How to use the GOTO statement [VBA] |
| Nov.06, 2018 |
How to count blank cells |
| Nov.05, 2018 |
How to use the LOGNORMDIST function |
| Nov.05, 2018 |
Highlight cells equal to |
| Nov.05, 2018 |
Use slicers to quickly filter chart data |
| Nov.02, 2018 |
How to use the LOG10 function |
| Nov.02, 2018 |
How to use the WEEKNUM function |
| Oct.30, 2018 |
Highlight a date occuring [Conditional formatting] |
| Oct.30, 2018 |
How to use the LOGEST function |
| Oct.26, 2018 |
How to use the LINEST function |
| Oct.24, 2018 |
Count complete hours between two times |
| Oct.24, 2018 |
How to use the GAMMA.DIST function |
| Oct.24, 2018 |
How to use the ARRAY function [VBA] |
| Oct.24, 2018 |
Highlight above average values |
| Oct.23, 2018 |
How to add a logarithmic trendline in a chart |
| Oct.23, 2018 |
How to calculate the number of weeks between dates |
| Oct.23, 2018 |
How to calculate the number of months between dates |
| Oct.23, 2018 |
How to use the GAMMADIST function |
| Oct.22, 2018 |
How to calculate the number of years between dates |
| Oct.22, 2018 |
Highlight top 10 % values |
| Oct.22, 2018 |
How to add chart gridlines |
| Oct.22, 2018 |
How to use the F.TEST function |
| Oct.22, 2018 |
How to use the FTEST function |
| Oct.22, 2018 |
How to use the LBOUND and UBOUND functions |
| Oct.19, 2018 |
Highlight top 10 values |
| Oct.19, 2018 |
How to add Error Bars in a chart |
| Oct.19, 2018 |
How to use the NETWORKDAYS.INTL function |
| 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 conditions |
| 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 numbers 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 column/bar color in charts |
| 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 |
How to 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 |
Create 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 project dates 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.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.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.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.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 |
| Mar.03, 2011 |
Filter duplicate records |
| Mar.02, 2011 |
Highlight closest number |
| Feb.27, 2011 |
Merge matching rows |
| 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 |
| 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 |
| 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 |
| Jan.26, 2011 |
Weekly appointment calendar |
| Jan.24, 2011 |
Monthly calendar template #2 |
| 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 |
| 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) |
| 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.18, 2010 |
List people with the highest scores based on criteria |
| 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 |
| Oct.09, 2010 |
Highlight records based on overlapping date ranges and a condition |
| Oct.07, 2010 |
Dynamic team generator |
| Oct.05, 2010 |
Create a random playlist |
| Sep.30, 2010 |
Team Generator |
| Sep.28, 2010 |
Count records between two dates with multiple parameters |
| Sep.26, 2010 |
Sort values in parallel in excel, part 2 |
| 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 |
Extract dates from overlapping date ranges |
| Jul.04, 2010 |
Highlight specific time ranges in a weekly schedule |
| Jul.01, 2010 |
Weekly schedule template |
| 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 |
| 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.18, 2010 |
Merge two columns with possible blank cells |
| May.05, 2010 |
List all unique events in a month |
| May.02, 2010 |
Sort numeric values based on 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 |
| 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 |
Smallest greater than condition |
| 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.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 |
| Jan.13, 2010 |
How to return a value if lookup value is in a range |
| Jan.12, 2010 |
Sort two columns |
| 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 |
| 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 |
| Dec.21, 2009 |
Extract unique distinct text values containing string in a range |
| Dec.17, 2009 |
Filter duplicate text values in a range using “begins with” criterion |
| Dec.14, 2009 |
Extract unique distinct values that begins with a given string from a cell range |
| Dec.13, 2009 |
Formula for matching a date within a date range |
| Dec.05, 2009 |
Find latest date based on a condition |
| Dec.04, 2009 |
Filter unique distinct values where adjacent cells contain search string |
| Nov.23, 2009 |
Highlight odd/even months |
| Nov.22, 2009 |
Search values distributed horizontally and return corresponding value |
| Nov.16, 2009 |
Sum values between two dates and based on a condition |
| Nov.14, 2009 |
Most frequent value between two dates |
| Nov.11, 2009 |
Lookup min max values within a date range |
| Nov.07, 2009 |
Lookup two index columns |
| Nov.02, 2009 |
Create a quartely date range |
| Nov.01, 2009 |
Create a monthly date range |
| Oct.25, 2009 |
5 easy ways to VLOOKUP and return multiple values |
| Oct.17, 2009 |
Extract unique distinct values sorted based on sum of adjacent values |
| Oct.15, 2009 |
Filter unique values from a cell range |
| Oct.13, 2009 |
Filter unique values sorted from A to Z |
| Oct.07, 2009 |
Create a list with most recent data available |
| Oct.01, 2009 |
Extract records where all criteria match if not empty |
| Sep.28, 2009 |
Extract all rows from a range that meet criteria in one column |
| Sep.27, 2009 |
Sort text values by length |
| Sep.26, 2009 |
Create unique distinct list sorted based on text length |
| Sep.24, 2009 |
Unique distinct values sorted based on frequency |
| Sep.22, 2009 |
Unique distinct list from a column sorted A to Z |
| Sep.20, 2009 |
Identify missing numbers in a range |
| Sep.18, 2009 |
Extract numbers from a column |
| Sep.16, 2009 |
Extract a unique distinct list sorted alphabetically and ignore blanks from a range |
| Sep.14, 2009 |
Create a list of dates with blanks between quarters |
| 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 |
| Aug.31, 2009 |
Find min and max unique and duplicate numerical values |
| Aug.29, 2009 |
Reverse a list ignoring blanks |
| Aug.26, 2009 |
List values with past date |
| Aug.24, 2009 |
Search and display all cells that contain multiple search strings |
| 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.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 separate columns |
| Aug.06, 2009 |
Filter duplicate values and sort by corresponding date |
| 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.28, 2009 |
Extract a unique distinct list sorted from A-Z from range |
| 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.13, 2009 |
Extract duplicates from a range |
| 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.06, 2009 |
Count specific text string in a cell |
| 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 |
| Jun.27, 2009 |
How to create a unique distinct list based on two conditions |
| Jun.25, 2009 |
Sum number based on corresponding unique value |
| Jun.24, 2009 |
How to perform a two-dimensional lookup |
| Jun.23, 2009 |
Extract a list of duplicates from three columns combined |
| 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.10, 2009 |
Count unique distinct values in two columns |
| Jun.09, 2009 |
Count unique distinct values |
| 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.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.12, 2009 |
Create a unique distinct list from a date range |
| May.10, 2009 |
Highlight dates in a date range |
| May.03, 2009 |
Create a unique distinct list where a corresponding column has text cell values |
| May.01, 2009 |
Create a list of duplicates where adjacent cell value meets a condition |
| Apr.26, 2009 |
How to rank uniquely based on a condition |
| Apr.25, 2009 |
How to rank text uniquely without duplicates |
| Apr.24, 2009 |
Sort column based on frequency |
| Apr.21, 2009 |
Search for multiple text strings in column – AND logic |
| Apr.20, 2009 |
Sum unique numbers |
| Apr.19, 2009 |
How to highlight unique distinct values |
| Apr.16, 2009 |
Create a unique distinct list based on criteria |
| Apr.14, 2009 |
Create a unique distinct alphabetically sorted list |
| Apr.13, 2009 |
How to quickly find the maximum or minimum value [Formula] |
| Apr.10, 2009 |
Extract unique values from two columns |
| Apr.02, 2009 |
Count dates inside a date range |
| 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.25, 2009 |
Extract all rows that contain a value between this and that |
| Mar.20, 2009 |
Delete blanks and errors in a list |
| 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.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 column |
| 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.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 ignoring blank cells |
| 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 |
| Sep.01, 2006 |
Improve worksheet readability |
| Aug.20, 2006 |
How to create a stock chart |
