| Date |
Article |
| Oct.29, 2021 |
How to use the STOCKHISTORY function |
| Aug.27, 2021 |
How to use the XMATCH function |
| Aug.26, 2021 |
How to use the LET function |
| Aug.12, 2021 |
How to use the XLOOKUP function |
| Jul.08, 2021 |
How to use the FILTERXML function |
| May.28, 2021 |
How to use the ROUND function |
| May.04, 2021 |
How to use the PV function |
| 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 sum 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 values in a cell range to a single column |
| 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 ignore 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 |
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 evaluate multiple conditions |
| Nov.23, 2017 |
IF function with AND function – multiple conditions |
| Nov.22, 2017 |
How to simplify 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 |
Distribute values across numerical ranges |
| Oct.25, 2017 |
How to create 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 based on a date range and a condition 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 criteria |
| 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 |
Lookup and match last value – reverse lookup |
| 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 |
Partial match values and return value with highest level |
| Jul.06, 2017 |
Highlight cells based on ranges |
| 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 programmatically |
| Mar.30, 2017 |
Count cells based on background color programmatically |
| Mar.16, 2017 |
How to use Excel 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 |
How to extract rows containing digits [Formula] |
| Dec.02, 2016 |
How to use the LIKE OPERATOR |
| Nov.16, 2016 |
Build a stock chart with two series |
| Nov.10, 2016 |
Calendar – monthly view |
| Oct.24, 2016 |
How to generate a 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 |
How to use 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 (VBA) |
| Apr.21, 2016 |
How to calculate and plot pivots on an Excel chart |
| Apr.12, 2016 |
Count identical values if they are on the same row |
| Mar.22, 2016 |
Compare two columns in different worksheets |
| Mar.16, 2016 |
Sort values by corresponding text arranged in a column |
| Feb.15, 2016 |
Sort items by adjacent number in every other value |
| Feb.03, 2016 |
Multiply numbers in each row with remaining rows in cell range (UDF) |
| Jan.26, 2016 |
Resize a range of values (UDF) |
| 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 and return the highest number and corresponding date based on a condition |
| Sep.22, 2015 |
How to add horizontal line to chart |
| Sep.18, 2015 |
Excel chart problem: Hard to read series values |
| Sep.07, 2015 |
A beginners guide to Excel array formulas |
| Aug.24, 2015 |
Highlight a column in a stacked column chart |
| Aug.14, 2015 |
How to color chart bars based on their values |
| Aug.12, 2015 |
Count overlapping days across multiple date ranges |
| Aug.06, 2015 |
Calculate date given weekday and week number |
| 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 strings in file names, folder name and subfolders |
| Jun.04, 2015 |
Sum numerical ranges between two numbers |
| 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 empty 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 |
How to build a Team Generator – different number of people per team |
| Apr.16, 2015 |
Working with LIST BOXES (Form Controls) |
| Apr.10, 2015 |
Split expenses calculator |
| Mar.31, 2015 |
How to count repeating values |
| Mar.25, 2015 |
List all hyperlinks in worksheet programmatically |
| Mar.19, 2015 |
How to automatically add new items to a drop down list |
| Mar.10, 2015 |
How to use the 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 subfolders |
| Feb.06, 2015 |
Compare file names in two different folder locations and their sub folders |
| Jan.27, 2015 |
How to save specific multiple worksheets to a pdf file programmatically |
| Jan.19, 2015 |
Find cells containing formulas with literal (hardcoded) 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 most/least consecutive repeated value [VBA] |
| Dec.02, 2014 |
How to use the TEXTTOCOLUMNS method |
| Nov.18, 2014 |
Count comma separated values |
| Nov.11, 2014 |
Extract the most repeated adjacent values in a column |
| Nov.04, 2014 |
Search for a sequence of cells based on wildcard search |
| Oct.28, 2014 |
Search for a sequence of values |
| Oct.23, 2014 |
Search all workbooks in a folder and sub folders |
| Oct.14, 2014 |
How to create a list of comments from a worksheet programmatically |
| Oct.08, 2014 |
How to replace columns with pictures in a column chart |
| Sep.30, 2014 |
Build a comparison table/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 |
Find earliest and latest overlapping dates in a set of date ranges based on a condition |
| 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 |
| 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 programmatically |
| 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 |
Partial match 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 |
| 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 no 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 distinct rows in a given 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 |
Get the smallest number larger than a given number |
| 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 |
Perform multiple partial matches 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 |
Partial match based on two conditions |
| 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 |
Partial match with two conditions and return multiple results |
| May.12, 2009 |
Filter 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 |
Partial match for multiple strings – 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.31, 2009 |
Improve your VLOOKUP formula and return multiple values |
| 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 |
