Date |
Article |
Feb.14, 2021 |
How to use the RANDARRAY function |
Feb.01, 2021 |
How to use the SEQUENCE function |
Jan.11, 2021 |
How to use the SORTBY function |
Dec.27, 2020 |
How to use the SORT function |
Dec.17, 2020 |
How to use the FILTER function |
Dec.09, 2020 |
How to use the UNIQUE function |
Aug.09, 2020 |
How to copy every n-th row from a list |
Jun.22, 2020 |
How to solve simultaneous linear equations in Excel |
May.13, 2019 |
Extract text between words [UDF] |
May.01, 2019 |
How to use the XNPV function |
Apr.15, 2019 |
How to use the RRI function |
Apr.04, 2019 |
How to use the SET statement |
Mar.29, 2019 |
How to do tiered calculations in one formula |
Mar.14, 2019 |
How to use the ROUNDDOWN function |
Mar.13, 2019 |
How to use the ROUNDUP function |
Feb.19, 2019 |
How to add lines between stacked columns/bars [Excel charts] |
Feb.08, 2019 |
How to sum a cell range |
Jan.30, 2019 |
How to ignore error values using the SMALL function |
Jan.22, 2019 |
How to use the VDB function |
Jan.21, 2019 |
How to use the DDB function |
Jan.10, 2019 |
Highlight unique distinct records |
Jan.08, 2019 |
How to use the AMORLINC function |
Dec.17, 2018 |
How to use the AMORDEGRC function |
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 [UDF] |
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 |
Count 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 |
How to use the COUNTIF function to count 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 using formulas |
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 discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses |
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 |
Extract records containing digits [Formula] |
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 |
How to calculate overlapping time 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 |
How to group items by quarter using formulas |
Aug.20, 2014 |
How to copy Excel tables programmatically |
Jul.16, 2014 |
How to highlight row of the selected cell programmatically |
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 |
Working with classic ciphers in Excel |
May.07, 2014 |
Move data to workbooks |
Apr.29, 2014 |
How to use the Subtotal tool |
Apr.18, 2014 |
Sort and return unique distinct single digits from cell range |
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 programmatically in Excel |
Mar.31, 2014 |
Build a maze programmatically in Excel |
Mar.14, 2014 |
How to animate a line chart |
Feb.27, 2014 |
Merge tables based on a condition |
Feb.18, 2014 |
How to animate an Excel Bar Chart |
Feb.11, 2014 |
Lookup value based on two critera – second criteria is the adjacent value and its position in a given list |
Feb.07, 2014 |
Find last matching value in an unsorted list |
Feb.04, 2014 |
Multi-level To-Do list template |
Jan.28, 2014 |
How to animate an Excel chart |
Jan.21, 2014 |
Highlight a group of chart bars |
Jan.14, 2014 |
Sort by multiple columns |
Jan.08, 2014 |
Search all workbooks in a folder |
Dec.20, 2013 |
All you need to know about calculating NAV units for your stock portfolio |
Dec.13, 2013 |
Lookup and return multiple sorted values based on corresponding values in another column |
Dec.03, 2013 |
Customize the ribbon and how to add your macros |
Nov.26, 2013 |
Identify rows of overlapping records |
Nov.22, 2013 |
Remove print preview lines (Page Breaks) |
Nov.12, 2013 |
Compare two columns and extract differences |
Nov.06, 2013 |
How to filter chart data |
Oct.30, 2013 |
Working with TEXT BOXES [Form Controls] |
Oct.25, 2013 |
Show / hide a picture using a button |
Oct.22, 2013 |
Wildcard lookups and include or exclude criteria |
Oct.18, 2013 |
Lookup with any number of criteria |
Oct.15, 2013 |
Hide specific worksheets programmatically |
Oct.11, 2013 |
Click a cell to make a column hidden or visible [VBA] |
Oct.08, 2013 |
How to use the Scroll Bar |
Oct.02, 2013 |
Count Conditionally Formatted cells |
Sep.27, 2013 |
Count cells based on background color |
Sep.23, 2013 |
Min and max date of overlapping date ranges |
Sep.20, 2013 |
How to select and delete blank cells |
Sep.17, 2013 |
Prevent duplicate records in a worksheet |
Sep.14, 2013 |
Color chart columns 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 |
Practice basic arithmetic calculations in Excel |
Aug.20, 2013 |
Which Excel files in folder are password protected? |
Aug.15, 2013 |
Count text string in all formulas in a worksheet [VBA] |
Aug.07, 2013 |
Easily select data using hyperlinks |
Jul.30, 2013 |
Navigate to first empty cell using a hyperlink formula |
Jul.16, 2013 |
How to use the IFERROR function |
Jul.09, 2013 |
Create a hyperlink linked to the result of a two-dimensional lookup |
Jul.05, 2013 |
How to generate random numbers and text |
Jul.03, 2013 |
Compare data in an Excel chart using drop down lists |
Jun.19, 2013 |
Locate a shape in a workbook |
Jun.14, 2013 |
Hover with mouse cursor to change stock in a candlestick chart |
Jun.05, 2013 |
Find all sequences of consecutive dates |
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.14, 2013 |
How to build an interactive map in Excel |
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 records unique random text strings |
Apr.15, 2013 |
How to use the ROW function |
Apr.09, 2013 |
Highlight duplicates in a filtered Excel 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 |
Units 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 |
How to change a picture in a worksheet dynamically [VBA] |
Mar.05, 2013 |
Heat map yearly calendar |
Mar.01, 2013 |
Lookup using multiple conditions |
Feb.27, 2013 |
Substitute multiple text strings [UDF] |
Feb.18, 2013 |
Count multiple text strings in a cell range |
Feb.15, 2013 |
Move a shape [VBA] |
Feb.11, 2013 |
How to sort a data set using three different approaches, built-in tools, array formulas, and VBA |
Feb.04, 2013 |
Convert array formula to a regular formula |
Feb.01, 2013 |
Highlight group of values in an x y scatter chart programmatically |
Jan.29, 2013 |
Highlight a column in a stacked column chart |
Jan.25, 2013 |
Highlight events in a yearly calendar |
Jan.24, 2013 |
Highlight a bar in a chart |
Jan.18, 2013 |
Repeat values across cells |
Jan.15, 2013 |
Merge two relational data sets |
Jan.07, 2013 |
Lookup multiple values in one cell [UDF] |
Jan.03, 2013 |
How to calculate totals of stock transactions based on dates |
Dec.28, 2012 |
Run a Macro from a Drop Down list [VBA] |
Dec.10, 2012 |
How to change cell formatting using a Drop Down list |
Dec.05, 2012 |
Prevent overlapping date and time ranges using data validation |
Nov.30, 2012 |
Group rows based on a condition |
Nov.29, 2012 |
VLOOKUP and return multiple values across columns |
Nov.22, 2012 |
Find date range based on a date |
Nov.20, 2012 |
Find smallest and largest unique number |
Nov.13, 2012 |
Create monthly time sheet using a Pivot Table |
Nov.09, 2012 |
Analyze trends using pivot tables |
Nov.07, 2012 |
Hide specific columns programmatically |
Nov.05, 2012 |
Compare your stock portfolio with S&P500 in Excel |
Oct.31, 2012 |
How to use VLOOKUP with multiple conditions |
Oct.26, 2012 |
Locate lookup values in an Excel table [HYPERLINK] |
Oct.23, 2012 |
Highlight lookups in relational tables |
Oct.19, 2012 |
Working with three relational tables |
Oct.17, 2012 |
Extract unique distinct values from a relational table |
Oct.15, 2012 |
How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas |
Oct.12, 2012 |
Change column/bar color in charts |
Oct.10, 2012 |
Lookups in relational tables |
Oct.02, 2012 |
Copy worksheets in active workbook to new workbooks |
Sep.27, 2012 |
Filter values that exists in all three columns |
Sep.26, 2012 |
Copy Excel Table filter criteria programmatically |
Sep.21, 2012 |
Perform thousands of conditions to a data set |
Sep.17, 2012 |
How to create name initials |
Sep.12, 2012 |
Search related table based on a date and date range |
Sep.10, 2012 |
Use a calendar to filter an Excel defined Table |
Sep.05, 2012 |
Excel calendar [VBA] |
Aug.27, 2012 |
Populate drop down list with filtered Excel Table values |
Aug.22, 2012 |
Use drop down lists and named ranges to filter chart values |
Aug.17, 2012 |
Shift Schedule |
Aug.15, 2012 |
Extract cell references populated with values [VBA] |
Aug.07, 2012 |
How to use mouse hover on a worksheet [VBA] |
Aug.06, 2012 |
Sort values in a cell based on a delimiting character [VBA] |
Jul.27, 2012 |
Plot date ranges in a calendar part 2 |
Jul.25, 2012 |
Macro creates links to all sheets, tables, pivot tables and named ranges |
Jul.23, 2012 |
Count unique distinct values in a filtered Excel defined Table |
Jul.18, 2012 |
Create links to all sheets in a workbook |
Jul.14, 2012 |
Create new worksheets programmatically based on values in a cell range [VBA] |
Jul.13, 2012 |
Change chart axis range programmatically |
Jul.05, 2012 |
List files in folder and create hyperlinks (VBA) |
Jul.02, 2012 |
Extract table headers based on a condition |
Jun.29, 2012 |
Plot buy and sell points in an Excel Chart based on two moving averages |
Jun.27, 2012 |
Add buy and sell points to a stock chart |
Jun.18, 2012 |
How to create an interactive Excel chart [VBA] |
Jun.12, 2012 |
Find numbers in close proximity to a given number |
Jun.06, 2012 |
Sort values in an Excel table programmatically [VBA] |
Jun.04, 2012 |
Prepare data for Pivot Table – How to split concatenated values? |
May.28, 2012 |
Search two related tables [VBA] |
May.23, 2012 |
Create comment if cell value is larger than column |
May.22, 2012 |
Lookup multiple values across columns and return a single value |
May.21, 2012 |
Learn how to return values based on where you enter the UDF |
May.19, 2012 |
Change chart series by clicking on data [VBA] |
May.16, 2012 |
Excel template: Getting Things Done [VBA] |
May.11, 2012 |
Disable autofit column widths for Pivot table |
May.07, 2012 |
Normalize data [VBA] |
May.02, 2012 |
Create date ranges that stay within month |
Apr.30, 2012 |
Add values to worksheets based on a condition [VBA] |
Apr.26, 2012 |
Add values to a two-dimensional table based on conditions [VBA] |
Apr.23, 2012 |
Unique distinct records sorted based on count or frequency |
Apr.21, 2012 |
Count groups of repeated values per row |
Apr.21, 2012 |
Use a drop down list to filter and concatenate unique distinct values |
Apr.18, 2012 |
Add or remove a value in a drop down list programmatically |
Apr.16, 2012 |
Count a specific weekday in a date range |
Apr.10, 2012 |
Open Excel files in a folder [VBA] |
Mar.30, 2012 |
Auto populate a worksheet |
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 |
Schedule project dates based on a finish date |
Mar.19, 2012 |
Use a drop down list to display data in worksheet header [VBA] |
Mar.14, 2012 |
Automate data entry [VBA] |
Mar.12, 2012 |
Apply drop-down lists dynamically |
Mar.09, 2012 |
How to log when a workbook is opened and closed [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 drop-down lists in multiple rows |
Feb.20, 2012 |
Watch schedule that populates vacation time |
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 |
Find entry based on conditions |
Jan.27, 2012 |
Free School Schedule Template |
Jan.24, 2012 |
Copy a dynamic cell range [VBA] |
Jan.20, 2012 |
Label groups of duplicate records |
Jan.17, 2012 |
List all open workbooks and corresponding sheets [VBA] |
Jan.14, 2012 |
Basic data entry [VBA] |
Jan.09, 2012 |
List Excel defined Tables in a workbook [VBA] |
Jan.02, 2012 |
Basic invoice template |
Dec.23, 2011 |
Extract week ranges based on a given date range |
Dec.21, 2011 |
Working with COMBO BOXES [Form Controls] |
Dec.09, 2011 |
Rearrange data source in order to create a dynamic chart |
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 PivotTable data source using a drop-down list |
Nov.24, 2011 |
Count weekday within date range except holidays |
Nov.11, 2011 |
Create permutations [UDF] |
Nov.08, 2011 |
Dynamic Gantt charts |
Nov.04, 2011 |
Filter an Excel defined Table based on selected cell [VBA] |
Nov.02, 2011 |
Extract unique distinct values from a filtered Excel defined Table [UDF and Formula] |
Oct.24, 2011 |
Populate a combobox with values from a pivot table [VBA] |
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 specified values |
Oct.05, 2011 |
Add values to a regular drop-down list programmatically [VBA] |
Sep.29, 2011 |
Use hyperlinks in a pivot table |
Sep.16, 2011 |
Filter an Excel defined Table programmatically [VBA] |
Sep.14, 2011 |
Reorganize data [UDF] |
Sep.12, 2011 |
Populate a list box with unique distinct values from a filtered 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 |
Extract unique distinct values based on a filtered Excel defined Table |
Aug.23, 2011 |
Two-way lookup using multiple tables [UDF] |
Aug.19, 2011 |
Count entries based on date and time |
Aug.18, 2011 |
VLOOKUP in a filtered Excel Table and return multiple values |
Aug.15, 2011 |
Remove common records between two data sets |
Aug.13, 2011 |
How to add a custom-made item to the shortcut menu [VBA] |
Aug.09, 2011 |
SUMIF across multiple sheets [UDF] |
Aug.05, 2011 |
Insert blank rows for missing values |
Aug.03, 2011 |
Select cell A1 on all sheets before you close a workbook [VBA] |
Jul.28, 2011 |
Filter unique distinct values, sorted and blanks removed from a range |
Jul.22, 2011 |
How to sort a data set in a custom order |
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.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 |
How to save custom functions and macros to an Add-In |
Jun.13, 2011 |
Auto refresh a pivot table |
Jun.09, 2011 |
7 days (weekly) date ranges using a formula |
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 |
Count unique distinct records (rows) in a Pivot Table |
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.13, 2011 |
Vlookup – Return multiple unique distinct values |
May.09, 2011 |
Calculate running average of last 10 data with random blank cells |
May.06, 2011 |
Filter unique distinct records (case sensitive) [UDF] |
May.03, 2011 |
Filter unique distinct values (case sensitive) [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 ignore blank cells |
Apr.19, 2011 |
Bill reminder in excel |
Apr.17, 2011 |
Dependent drop down lists – Enable/Disable selection filter |
Apr.12, 2011 |
Running totals based on criteria |
Apr.06, 2011 |
How to highlight differences in price lists |
Apr.05, 2011 |
How to count word frequency in a cell range [UDF] |
Apr.04, 2011 |
Fuzzy lookups [UDF] |
Mar.28, 2011 |
Filter records based on a date range and 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 |
Highlight records containing text strings (AND Logic) |
Mar.16, 2011 |
Filter words containing a given string in a cell 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 |
Concatenate cell values |
Feb.08, 2011 |
Tracking a stock portfolio #2 |
Feb.03, 2011 |
List permutations without repetition [UDF] |
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 tables: Filter records occurring only in one table |
Jan.12, 2011 |
Compare tables: Highlight records not in both tables |
Jan.11, 2011 |
Compare two lists of data: Highlight common records |
Jan.08, 2011 |
Filter shared records from two tables |
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 distinct values [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.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 not shared values out of two cell ranges [UDF] |
Nov.12, 2010 |
Filter values in common between two cell ranges [UDF] |
Nov.09, 2010 |
Filter duplicates in a large dataset [UDF] |
Nov.08, 2010 |
Compare two columns and return differences |
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 |
Sort based on frequency and criteria |
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.26, 2010 |
Sort records based on two columns |
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.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.29, 2010 |
Extract dates from a cell block 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 |
Create numbers based on numerical ranges |
Jul.29, 2010 |
Find empty hours in a weekly schedule |
Jul.26, 2010 |
Count groups in calendar |
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.11, 2010 |
Extract a unique distinct list sorted from A to Z ignore 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 values based on a date |
Apr.13, 2010 |
Remove duplicates within same month or year |
Apr.12, 2010 |
Remove duplicates based on date |
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.15, 2010 |
Sum based on OR – AND logic |
Mar.10, 2010 |
Rearrange values based on category [VBA] |
Mar.07, 2010 |
Count unique distinct numbers across multiple sheets |
Mar.03, 2010 |
Split data across multiple sheets [VBA] |
Feb.28, 2010 |
Merge Ranges Add-In |
Feb.26, 2010 |
Calendar with scheduling [vba] |
Feb.18, 2010 |
Extract unique distinct year and months from dates |
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.02, 2010 |
Extract records containing negative numbers |
Jan.24, 2010 |
Create number series |
Jan.20, 2010 |
Count cells between two values |
Jan.16, 2010 |
Extract unique distinct values if value contains string |
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 values from a range that begins with string |
Dec.14, 2009 |
Extract unique distinct values from cell range that begins with string |
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 unique distinct values A to Z from a range and ignore blanks |
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 cells containing numbers and 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 columns for a string and return 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 multiple 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 |
Row 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 |
Populate drop down list with unique distinct values sorted from A to Z |
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 |
Extract unique distinct values based on a date range |
May.10, 2009 |
Highlight dates in a date range |
May.03, 2009 |
Extract unique distinct values if adjacent cell is text |
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 |
Extract a unique distinct list sorted from A to Z |
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.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 ignore 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 shared values in 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 |