Welcome to the archive

No Article
1 Extract values between two given delimiting strings
2 How to use the LAMBDA function
3 How to use the REPLACE function
4 How to use the NPER function
5 Extract a unique distinct list across multiple columns and rows sorted based on frequency
6 How to use the EXPAND function
7 How to use the CHOOSECOLS function
8 How to use the CHOOSEROWS function
9 How to use the DROP function
10 How to use the TAKE function
11 How to use the WRAPCOLS function
12 How to use the WRAPROWS function
13 How to use the TOROW function
14 How to use the TOCOL function
15 How to use the HSTACK function
16 How to use the VSTACK function
17 How to use the TEXTSPLIT function
18 How to use the TEXTAFTER function
19 How to use the TEXTBEFORE function
20 How to use the STOCKHISTORY function
21 How to use the XMATCH function
22 How to use the LET function
23 How to use the XLOOKUP function
24 How to use the FILTERXML function
25 How to use the ROUND function
26 How to use the PV function
27 How to use the RANDARRAY function
28 How to use the SEQUENCE function
29 How to use the SORTBY function
30 How to use the SORT function
31 How to use the FILTER function
32 How to use the UNIQUE function
33 How to copy every n-th row from a list
34 How to solve simultaneous linear equations in Excel
35 Extract text between words [UDF]
36 How to use the XNPV function
37 How to use the RRI function
38 How to use the SET statement
39 How to do tiered calculations in one formula
40 How to use the ROUNDDOWN function
41 How to use the ROUNDUP function
42 How to add lines between stacked columns/bars [Excel charts]
43 How to sum a cell range
44 How to ignore error values using the SMALL function
45 How to use the VDB function
46 How to use the DDB function
47 Highlight unique distinct records
48 How to use the AMORLINC function
49 How to use the AMORDEGRC function
50 How to use the YIELD function
51 How to use the SYD function
52 How to use the TBILLEQ function
53 How to use the TBILLPRICE function
54 How to use the TBILLYIELD function
55 How to use the UNICODE function
56 How to use the UNICHAR function
57 How to use the PERCENTRANK.EXC function
58 How to use the PERCENTRANK.INC function
59 Sum unique distinct numbers
60 How to use the PERCENTRANK function
61 Highlight current date
62 How to use the EVALUATE method
63 INDEX MATCH – Last value
64 How to highlight dates based on day of week
65 How to create a combined stacked area and a clustered column chart
66 How to use the QUARTILE.EXC function
67 How to use the QUARTILE function
68 Highlight unique/duplicates [Conditional formatting]
69 How to find the smallest number excluding zeros
70 How to build an arrow chart
71 How to highlight weekends [Conditional Formatting]
72 How to use the LOGNORM.DIST function
73 How to use the GOTO statement [VBA]
74 How to count blank cells
75 How to use the LOGNORMDIST function
76 Highlight cells equal to
77 Use slicers to quickly filter chart data
78 How to use the LOG10 function
79 How to use the WEEKNUM function
80 Highlight a date occuring [Conditional formatting]
81 How to use the LOGEST function
82 How to use the LINEST function
83 Count complete hours between two times
84 How to use the GAMMA.DIST function
85 How to use the ARRAY function [VBA]
86 Highlight above average values
87 How to add a logarithmic trendline in a chart
88 Calculate the number of weeks between given dates
89 How to calculate the number of months between dates
90 How to use the GAMMADIST function
91 How to calculate the number of years between dates
92 Highlight top 10 % values
93 How to add chart gridlines
94 How to use the F.TEST function
95 How to use the FTEST function
96 How to use the LBOUND and UBOUND functions
97 Highlight top 10 values
98 How to add Error Bars in a chart
99 How to use the NETWORKDAYS.INTL function
100 How to count workdays between two dates
101 How to use the JOIN function [VBA]
102 Highlight cells containing string [Conditional formatting]
103 How to add a moving average to a chart
104 How to use the FORECAST function
105 How to insert icons representing cell values [Conditional formatting]
106 How to use the INTERCEPT function
107 How to add a linear trendline to a chart
108 How to customize the chart legend
109 How to create a combined chart – Column and Line on secondary axis
110 How to create color scales [Conditional Formatting]
111 How to use the F.DIST.RT function
112 How to use the F.DIST function
113 How to add Data Bars to your worksheet
114 How to use the FDIST function
115 Two y-axes in one chart
116 Highlight text values
117 How to use the EXPONDIST function
118 How to add and customize chart data labels
119 How to customize chart tick marks
120 How to use the BINOM.INV function
121 How to use the CRITBINOM function
122 How to customize a chart data series
123 How to use the CHISQ.TEST function
124 How to use the CHITEST function
125 How to use the COVAR function
126 How to use the COVARIANCE.S function
127 How to use the COVARIANCE.P function
128 How to create a sparkline – Win/Loss
129 How to use the COTH function
130 How to use the XOR function
131 How to customize chart axis titles
132 How to customize the plot area
133 How to customize the chart title
134 How to customize the chart area
135 How to use the CHISQ.INV.RT function
136 How to create a sparkline – Column
137 How to use the CHISQ.INV function
138 How to create a sparkline – Line
139 How to use the CHIINV function
140 How to use the CHISQ.DIST.RT function
141 How to create a candlestick chart
142 How to use the CHISQ.DIST function
143 How to create a surface chart
144 How to use the CHIDIST function
145 How to use the BINOM.DIST function
146 How to create a funnel chart
147 How to use the BINOMDIST function
148 How to use the BETA.INV function
149 How to create a Box and Whisker chart
150 How to use the BETAINV function
151 How to use the BETA.DIST function
152 How to use the BETADIST function
153 How to create a Pareto chart
154 How to use the RANK.EQ function
155 How to use the CONFIDENCE.T function
156 How to create a histogram chart
157 How to use the CONFIDENCE.NORM function
158 How to create a combined Column and Line chart
159 How to use the MODE.SNGL function
160 How to use the FLOOR.PRECISE function
161 How to use the DELTA function
162 How to create a waterfall chart
163 How to use the DOLLARFR function
164 How to create a doughnut chart
165 How to use the CSC function
166 How to create a radar chart
167 How to use the CUMIPMT function
168 How to use the CUMPRINC function
169 How to create a treemap chart
170 How to use the IPMT function
171 How to create a sunburst chart
172 How to use the GROWTH function
173 How to use the PPMT function
174 How to create an area chart
175 How to use the DB function
176 How to use the ERROR.TYPE function
177 How to use the GCD function
178 How to create a bubble chart
179 How to use the GEOMEAN function
180 How to use the GAMMA function
181 Label line chart series
182 How to use the RANGE.OFFSET property
183 How to use the SGN function [VBA]
184 How to create a scatter chart
185 How to use the WORKDAY function
186 How to use the YEARFRAC function
187 Group chart categories
188 How to use the FIX function [VBA]
189 How to use the INT function [VBA]
190 How to create a pie chart
191 How to use the SLOPE function
192 How to use the RANGE.FIND method
193 How to use the SKEW function
194 How to create a line chart
195 How to use the PROB function
196 How to create a bar chart
197 How to use the PRICEMAT function
198 How to create a 100% stacked column chart
199 How to use the PMT function
200 How to use the PHI function
201 How to use the PDURATION function
202 How to use the CONCATENATE function
203 Convert column number to column letter
204 Get date ranges from a schedule
205 How to replace part of formula in all cells
206 Copy data from workbooks in folder and subfolders
207 Extract unique distinct records from two data sets
208 How to position month and year between chart tick marks
209 How to copy non contiguous cell ranges
210 Search for a file in folder and subfolders [UDF]
211 How to use the NOMINAL function
212 How to use the MUNIT function
213 How to use the RAND function
214 How to use the MULTINOMIAL function
215 How to use the MINIFS function
216 How to use the MINA function
217 If cell has value
218 How to use the MINVERSE function
219 Count a given pattern in a cell value
220 How to create a stacked column chart
221 Four ways to resize a chart
222 How to use the NORM.INV function
223 How to use the SPLIT function [VBA]
224 How to customize chart axis
225 How to graph a Normal Distribution
226 How to use the NORM.DIST function
227 How to use the WEBSERVICE function
228 Extract n-th word in cell value
229 How to create a column chart
230 How to align chart with cell grid
231 If cell contains any text
232 How to delete empty rows
233 How to use the VAR.S function
234 How to select cells with data
235 How to use the VAR.P function
236 How to find blank cells
237 How to use the DVARP function
238 How to quickly select blank cells
239 How to add a macro to your Excel Quick Access Toolbar
240 How to quickly select a cell range
241 Highlight cells based on coordinates
242 How to use the DSUM function
243 How to use the DSTDEVP function
244 How to use the DSTDEV function
245 How to use the DPRODUCT function
246 How to use the DMIN function
247 How to use the DMAX function
248 How to use the DGET function
249 How to use the DCOUNTA function
250 How to use the DCOUNT function
251 How to use the DAVERAGE function
252 How to use the FORECAST.LINEAR function
253 Count cells with text
254 Count rows with data
255 How to use the BITXOR function
256 How to use the BITRSHIFT function
257 How to use the BITOR function
258 Count cells equal to any value in a list
259 How to use the BITLSHIFT function
260 How to use the BITAND function
261 How to use the BIN2OCT function
262 How to use the BIN2HEX function
263 How to use the BIN2DEC function
264 How to use the BASE function
265 How to use the AVEDEV function
266 How to use the ATANH function
267 How to use the ATAN2 function
268 How to use the ATAN function
269 How to use the ASINH function
270 How to convert radians to fractions of pi
271 How to use the ASIN function
272 How to use the ASC function
273 How to use the ACCRINTM function
274 How to use the ACCRINT function
275 How to use the ACOTH function
276 How to use the ACOT function
277 How to use the ACOSH function
278 How to use the ACOS function
279 How to use the NA function
280 How to use the TYPE function
281 How to use the TRUNC function
282 How to use the TRIMMEAN function
283 How to use the TREND function
284 How to use the SERIESSUM function
285 How to use the SECH function
286 How to use the COT function
287 How to use the COSH function
288 How to use the SINH function
289 How to use the TANH function
290 How to use the SUMXMY2 function
291 How to use the SUMX2PY2 function
292 How to use the SUMX2MY2 function
293 How to use the SUMSQ function
294 How to use the STDEVPA function
295 How to use the STANDARDIZE function
296 How to use the STDEV.S function
297 How to use the STDEV.P function
298 How to use the SEC function
299 How to use the RANK.AVG function
300 How to use the QUARTILE.INC function
301 How to use the FLOOR.MATH function
302 How to sum overlapping time
303 How to use the FIXED function
304 How to use the FACTDOUBLE function
305 How to use the EXPON.DIST function
306 How to use the EOMONTH function
307 How to use the ENCODEURL function
308 How to use the EFFECT function
309 How to use the EDATE function
310 How to use the DEC2OCT function
311 How to use the DEC2HEX function
312 How to use the DEC2BIN function
313 How to use the DECIMAL function
314 How to use the DAYS function
315 How to use the CONVERT function
316 DATEVALUE function not working
317 How to use the CONFIDENCE function
318 How to use the CORREL function
319 How to use the CONCAT function
320 How to use the COMPLEX function
321 How to use the CEILING function
322 How to use the AVERAGEA function
323 How to use the AREAS function
324 How to use the LCM function
325 How to use the ISPMT function
326 How to use the NOW function
327 How to use the TIMEVALUE function
328 Match a range value containing both text and numerical characters
329 How to use the SWITCH function
330 How to use the STDEVA function
331 How to use the STDEV function
332 How to use the SHEETS function
333 How to use the SHEET function
334 How to use the RATE function
335 How to use the MROUND function
336 How to use the NOT function
337 SMALL function with multiple cell ranges
338 How to use the SQRT function
339 How to use the SIGN function
340 How to use the T function
341 How to use the N function
342 How to use the MODE.MULT function
343 How to use the MODE function
344 How to use the MEDIAN function
345 How to use the LOG function
346 How to use the LN function
347 How to use the INFO function
348 How to use the FV function
349 How to use the PERMUTATIONA function
350 How to use the COMBINA function
351 How to filter using OR logic between columns [Formula]
352 How to filter using OR logic between columns [Advanced Filter]
353 How to use the PRODUCT function
354 Rearrange values in a cell range to a single column
355 Get the latest revision
356 How to use the TRUE function
357 How to use the DEGREES function
358 How to use the RANK function
359 How to use the RADIANS function
360 How to use the PI function
361 How to use the FORMULATEXT function
362 How to use the ISFORMULA function
363 How to use the ISODD function
364 How to use the ISERR function
365 How to use the FIND function
366 How to use the ISNA function
367 How to use the ISREF function
368 How to use the ISNONTEXT function
369 How to use the ISLOGICAL function
370 How to use the ISTEXT function
371 How to use the ISERROR function
372 How to use the ISBLANK function
373 How to use the POWER function
374 How to graph an equation
375 How to extract numbers from a cell value
376 How to use the VALUE function
377 How to use the TODAY function
378 How to use the DATEVALUE function
379 How to use the WITH … END WITH statement
380 How to use the DATEDIF function
381 How to use the DO LOOP statement
382 How to use the TAN function
383 How to use the COS function
384 How to use the SIN function
385 How to use the EVEN function
386 Highlight opposite numbers
387 How to use the MINUTE function
388 How to use the EXP function
389 How to use the RANDBETWEEN function
390 How to use the SECOND function
391 How to use the HOUR function
392 How to use the FLOOR function
393 How to use the FALSE function
394 How to use the FACT function
395 How to use the IFNA function
396 How to use the IFS function
397 How to use the INT function
398 How to use the CLEAN function
399 How to use the COMBIN function
400 How to use the PERMUT function
401 How to remove unwanted characters in a cell
402 How to use the LEN function
403 Identify all characters in a cell value
404 How to use the COUNTBLANK function
405 How to use the COUNTA function
406 How to use the COLUMNS function
407 How to use the ROWS function
408 How to use SELECT CASE statement
409 How to use the MAX function
410 How to use the MAXIFS function
411 How to use the LARGE function
412 How to use the CELL function
413 How to use the COUNT function
414 How to use the CHAR function
415 How to use the CODE function
416 How to use the COLUMN function
417 How to use the FOR NEXT statement
418 How to use the AVERAGEIFS function
419 How to use the AVERAGEIF function
420 How to use the AGGREGATE function
421 How to use the NETWORKDAYS function
422 How to use the ADDRESS function
423 How to use the TIME function
424 How to use the ISNUMBER function
425 Count specific WEEKDAYS between two dates
426 How to use the WEEKDAY function
427 How to use the DAY function
428 How to use the MONTH function
429 How to use the LOWER function
430 How to use the REPT function
431 How to use the SUBSTITUTE function
432 How to use the UPPER function
433 How to use the EXACT function
434 How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
435 How to use the TRIM function
436 Extract last word in cell
437 How to remove numbers from a cell value
438 How to use the ABS function
439 Extract first word in cell
440 LEFT function for numbers
441 CHOOSE function from list
442 How to use the RIGHT function
443 How to use the LEFT function
444 How to use the MID function
445 How to use the MIN function
446 How to use the SUMIFS function
447 How to use the CHOOSE function
448 Highlight empty cells
449 INDEX and MATCH – multiple criteria and multiple results
450 Count cells containing text from list
451 AVERAGE based on criteria
452 If cell contains multiple values
453 Days between two dates
454 SMALL function – INDEX MATCH
455 How to ignore zeros using the SMALL function
456 SMALL function – multiple conditions
457 SMALL function for text
458 AVERAGE ignore NA()
459 How to AVERAGE time
460 AVERAGE ignore blanks
461 How to use the AVERAGE function
462 SMALL function ignore duplicates
463 SUMPRODUCT and nested IF functions
464 SUMPRODUCT if not blank
465 SUMPRODUCT and IF function
466 SUMPRODUCT – multiple criteria
467 INDEX MATCH – Case sensitive
468 Excel formula not working
469 INDEX MATCH – multiple results
470 Compare two columns and highlight differences
471 Match two columns
472 If cell equals value from list
473 Sum by group
474 How to use the SUBTOTAL function
475 If cell contains text from list
476 IF with OR function
477 INDEX MATCH with multiple criteria
478 Sum numbers between two dates
479 How to use the COUNTIF function to count not blank cells
480 If cell contains text
481 How to use the OR function
482 How to use the AND function
483 Use IF + COUNTIF to evaluate multiple conditions
484 IF function with AND function – multiple conditions
485 How to simplify nested IF functions
486 How to use the YEAR function
487 How to use the HYPERLINK function
488 Two-dimensional lookup using two tables
489 How to use the DATE function
490 How to use the TEXT function
491 How to use the SUMIF function
492 Distribute values across numerical ranges
493 How to create running totals
494 Find empty cells and sum cells above
495 Rearrange values using formulas
496 Opening a workbook runs a macro automatically
497 How to extract a case sensitive unique list from a column
498 Count unique distinct values based on a condition
499 Lookup based on a date range and a condition return multiple values
500 Extract a list of alphabetically sorted duplicates based on a condition
501 Extract duplicate values with exceptions
502 Filter duplicate values using criteria
503 Concatenate cell values based on a condition [No VBA]
504 Find last value in a column
505 Unique distinct list sorted alphabetically based on a condition
506 Lookup and match last value – reverse lookup
507 Use VLOOKUP and return multiple values sorted from A to Z
508 Concatenate unique distinct values
509 How to use the SUM function
510 How to use the HLOOKUP function
511 How to use the VLOOKUP function
512 Partial match values and return value with highest level
513 Highlight cells based on ranges
514 Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses
515 Count matching strings using regular expressions
516 Reverse two-way lookups
517 How to create a map chart
518 Split search value using a delimiter and search for each substring
519 Fetching values from ThingSpeak programmatically
520 Count cells based on background color programmatically
521 How to use Excel Tables
522 Rotating unique groups with no repeat
523 Time sheet for work
524 Extract cell references from a formula
525 How to extract rows containing digits [Formula]
526 How to use the LIKE OPERATOR
527 Build a stock chart with two series
528 Calendar – monthly view
529 How to generate a round-robin tournament
530 List permutations with repetition and how many to choose from
531 How to use DIALOG BOXES
532 List all permutations with a condition
533 How to use Pivot Tables – Excel’s most powerful feature and also least known
534 How to use the TEXTJOIN function
535 Working with ARRAY VARIABLES (VBA)
536 How to calculate and plot pivots on an Excel chart
537 Count identical values if they are on the same row
538 Compare two columns in different worksheets
539 Sort values by corresponding text arranged in a column
540 Sort items by adjacent number in every other value
541 Multiply numbers in each row with remaining rows in cell range (UDF)
542 Resize a range of values (UDF)
543 Follow stock market trends – trailing stop
544 Follow stock market trends – Moving Average
545 Dynamic stock chart
546 Find and return the highest number and corresponding date based on a condition
547 How to add horizontal line to chart
548 Excel chart problem: Hard to read series values
549 A beginners guide to Excel array formulas
550 Highlight a column in a stacked column chart
551 How to color chart bars based on their values
552 Count overlapping days across multiple date ranges
553 Calculate date given weekday and week number
554 Improve your X Y Scatter Chart with custom data labels
555 How to use the TRANSPOSE function
556 Calculate time between time zones
557 Find and replace strings in file names, folder name and subfolders
558 Sum numerical ranges between two numbers
559 Unzip files in folder and subfolders
560 Sort based on frequency row-wise
561 Frequency bug?
562 Count overlapping days in multiple date ranges, part 2
563 Count overlapping days in multiple date ranges
564 Find empty dates in a set of date ranges
565 Dynamic scoreboard
566 Working with overlapping date ranges
567 How to calculate overlapping time ranges
568 How to build a Team Generator – different number of people per team
569 Working with LIST BOXES (Form Controls)
570 Split expenses calculator
571 How to count repeating values
572 List all hyperlinks in worksheet programmatically
573 How to automatically add new items to a drop down list
574 How to use the QUOTIENT function
575 Permutations with and without repetition
576 Return all combinations
577 Find numbers closest to sum
578 Filter duplicate files in a folder and subfolders
579 Compare file names in two different folder locations and their sub folders
580 How to save specific multiple worksheets to a pdf file programmatically
581 Find cells containing formulas with literal (hardcoded) values
582 How to use the LOOKUP function
583 How to enter array formulas in merged cells
584 How to use the INDIRECT function
585 Find the most/least consecutive repeated value [VBA]
586 How to use the TEXTTOCOLUMNS method
587 Count comma separated values
588 Extract the most repeated adjacent values in a column
589 Search for a sequence of cells based on wildcard search
590 Search for a sequence of values
591 Search all workbooks in a folder and sub folders
592 How to create a list of comments from a worksheet programmatically
593 How to replace columns with pictures in a column chart
594 Build a comparison table/chart
595 Add pictures to a chart axis
596 How to group items by quarter using formulas
597 How to copy Excel tables programmatically
598 How to highlight row of the selected cell programmatically
599 Optimize pick path in a warehouse
600 Compare two lists and filter unique values where the sum in one column doesn’t match the other column
601 A quicker A * pathfinding algorithm
602 How to use the MOD function
603 Finding the shortest path – A * pathfinding
604 Working with classic ciphers in Excel
605 Move data to workbooks
606 How to use the Subtotal tool
607 Sort and return unique distinct single digits from cell range
608 Print screen the entire worksheet
609 Highlight unique values in a filtered Excel table
610 Customize Excel maze
611 Solve a maze programmatically in Excel
612 Build a maze programmatically in Excel
613 How to animate a line chart
614 Merge tables based on a condition
615 How to animate an Excel Bar Chart
616 Lookup value based on two critera – second criteria is the adjacent value and its position in a given list
617 Find last matching value in an unsorted list
618 Multi-level To-Do list template
619 How to animate an Excel chart
620 Highlight a group of chart bars
621 Sort by multiple columns
622 Search all workbooks in a folder
623 All you need to know about calculating NAV units for your stock portfolio
624 Lookup and return multiple sorted values based on corresponding values in another column
625 Customize the ribbon and how to add your macros
626 Identify rows of overlapping records
627 Remove print preview lines (Page Breaks)
628 Compare two columns and extract differences
629 How to filter chart data
630 Working with TEXT BOXES [Form Controls]
631 Show / hide a picture using a button
632 Wildcard lookups and include or exclude criteria
633 Lookup with any number of criteria
634 Hide specific worksheets programmatically
635 Click a cell to make a column hidden or visible [VBA]
636 How to use the Scroll Bar
637 Count Conditionally Formatted cells
638 Count cells based on background color
639 Find earliest and latest overlapping dates in a set of date ranges based on a condition
640 How to select and delete blank cells
641 Prevent duplicate records in a worksheet
642 Color chart columns based on cell color
643 Count unique distinct values by cell color
644 Pivot Table calendar
645 Highlight date ranges overlapping selected record [VBA]
646 Practice basic arithmetic calculations in Excel
647 Which Excel files in folder are password protected?
648 Count text string in all formulas in a worksheet [VBA]
649 Easily select data using hyperlinks
650 Navigate to first empty cell using a hyperlink formula
651 How to use the IFERROR function
652 Create a hyperlink linked to the result of a two-dimensional lookup
653 How to generate random numbers and text
654 Compare data in an Excel chart using drop down lists
655 Locate a shape in a workbook
656 Hover with mouse cursor to change stock in a candlestick chart
657 Find all sequences of consecutive dates
658 How to use the FREQUENCY function
659 Highlight a data series in a line chart
660 Heat map using pictures
661 How to use the SUMPRODUCT function
662 How to build an interactive map in Excel
663 How to use the SEARCH function
664 Yet another Excel Calendar
665 How to use the MMULT function
666 How to use the SMALL function
667 Working with FILES
668 Assign records unique random text strings
669 How to use the ROW function
670 Highlight duplicates in a filtered Excel Table
671 How to use the COUNTIFS function
672 How to use the IF function
673 How to use the COUNTIF function
674 Units contained in a range that overlap another range
675 How to use the MATCH function
676 How to use the INDEX function
677 Custom data labels in a chart
678 How to change a picture in a worksheet dynamically [VBA]
679 Heat map yearly calendar
680 Lookup using multiple conditions
681 Substitute multiple text strings [UDF]
682 Count specific multiple text strings in a given cell range
683 Move a shape [VBA]
684 How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
685 Convert array formula to a regular formula
686 Highlight group of values in an x y scatter chart programmatically
687 Highlight a column in a stacked column chart
688 Highlight events in a yearly calendar
689 Highlight a bar in a chart
690 Repeat values across cells
691 Merge two relational data sets
692 Lookup multiple values in one cell [UDF]
693 How to calculate totals of stock transactions based on dates
694 Run a Macro from a Drop Down list [VBA]
695 How to change cell formatting using a Drop Down list
696 Prevent overlapping date and time ranges using data validation
697 Group rows based on a condition
698 VLOOKUP and return multiple values across columns
699 Find date range based on a date
700 Find smallest and largest unique number
701 Create monthly time sheet using a Pivot Table
702 Analyze trends using pivot tables
703 Hide specific columns programmatically
704 Compare your stock portfolio with S&P500 in Excel
705 How to use VLOOKUP/XLOOKUP with multiple conditions
706 Locate lookup values in an Excel table [HYPERLINK]
707 Highlight lookups in relational tables
708 Working with three relational tables
709 Extract unique distinct values from a relational table
710 How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
711 Change column/bar color in charts
712 Lookups in relational tables
713 Copy worksheets in active workbook to new workbooks
714 Filter values that exists in all three columns
715 Copy Excel Table filter criteria programmatically
716 Perform thousands of conditions to a data set
717 How to create name initials
718 Search related table based on a date and date range
719 Use a calendar to filter an Excel defined Table
720 Excel calendar [VBA]
721 Populate drop down list with filtered Excel Table values
722 Use drop down lists and named ranges to filter chart values
723 Shift Schedule
724 Extract cell references populated with values [VBA]
725 How to use mouse hover on a worksheet [VBA]
726 Sort values in a cell based on a delimiting character
727 Plot date ranges in a calendar part 2
728 Macro creates links to all sheets, tables, pivot tables and named ranges
729 Count unique distinct values in a filtered Excel defined Table
730 Create links to all sheets in a workbook programmatically
731 Create new worksheets programmatically based on values in a cell range [VBA]
732 Change chart axis range programmatically
733 List files in folder and create hyperlinks (VBA)
734 Extract table headers based on a condition
735 Plot buy and sell points in an Excel Chart based on two moving averages
736 Add buy and sell points to a stock chart
737 How to create an interactive Excel chart [VBA]
738 Find numbers in close proximity to a given number
739 Sort values in an Excel table programmatically [VBA]
740 Prepare data for Pivot Table – How to split concatenated values?
741 Search two related tables [VBA]
742 Create comment if cell value is larger than column
743 Lookup multiple values across columns and return a single value
744 Learn how to return values based on where you enter the UDF
745 Change chart series by clicking on data [VBA]
746 Excel template: Getting Things Done [VBA]
747 Disable autofit column widths for Pivot table
748 Normalize data [VBA]
749 Create date ranges that stay within month
750 Add values to worksheets based on a condition [VBA]
751 Add values to a two-dimensional table based on conditions [VBA]
752 Unique distinct records sorted based on count or frequency
753 Count groups of repeated values per row
754 Use a drop down list to filter and concatenate unique distinct values
755 Add or remove a value in a drop down list programmatically
756 Count a specific weekday in a date range
757 Open Excel files in a folder [VBA]
758 Auto populate a worksheet
759 Partial match and return multiple adjacent values
760 Toggle a macro on/off using a button
761 Schedule project dates based on a finish date
762 Use a drop down list to display data in worksheet header [VBA]
763 Automate data entry [VBA]
764 Apply drop-down lists dynamically
765 How to log when a workbook is opened and closed [VBA]
766 Working with Conditional Formatting formulas
767 How to create random numbers, text strings, dates and time values
768 Dependent drop-down lists in multiple rows
769 Watch schedule that populates vacation time
770 Advanced Gantt Chart Template
771 Auto resize columns as you type
772 Highlight lookup values
773 Find entry based on conditions
774 Free School Schedule Template
775 Copy a dynamic cell range [VBA]
776 Label groups of duplicate records
777 List all open workbooks and corresponding sheets [VBA]
778 Basic data entry [VBA]
779 List Excel defined Tables in a workbook [VBA]
780 Basic invoice template
781 Extract week ranges based on a given date range
782 Working with COMBO BOXES [Form Controls]
783 Rearrange data source in order to create a dynamic chart
784 Use a drop down list to search and return multiple values
785 Change chart data range using a Drop Down List [VBA]
786 Change PivotTable data source using a drop-down list
787 Count weekday within date range except holidays
788 Create permutations [UDF]
789 Dynamic Gantt charts
790 Filter an Excel defined Table based on selected cell [VBA]
791 Extract unique distinct values from a filtered Excel defined Table [UDF and Formula]
792 Populate a combobox with values from a pivot table [VBA]
793 Copy selected rows (checkboxes) (2/2)
794 Add checkboxes to a sheet (1/2) [VBA]
795 Count cells between specified values
796 Add values to a regular drop-down list programmatically [VBA]
797 Use hyperlinks in a pivot table
798 Filter an Excel defined Table programmatically [VBA]
799 Reorganize data [UDF]
800 Populate a list box with unique distinct values from a filtered Excel table [VBA]
801 Populate a combo box (form control) [VBA]
802 Filter unique distinct records using criteria
803 Extract unique distinct values based on a filtered Excel defined Table
804 Two-way lookup using multiple tables [UDF]
805 Count entries based on date and time
806 VLOOKUP in a filtered Excel Table and return multiple values
807 Remove common records between two data sets
808 How to add a custom-made item to the shortcut menu [VBA]
809 SUMIF across multiple sheets [UDF]
810 Insert blank rows for missing values
811 Select cell A1 on all sheets before you close a workbook [VBA]
812 Filter unique distinct values, sorted and blanks removed from a range
813 How to sort a data set in a custom order
814 Vlookup across multiple sheets
815 Count unique distinct values that meet multiple criteria
816 Sum cells based on criteria
817 List files in a folder and subfolders [UDF]
818 Vlookup a cell range and return multiple values
819 Count unique distinct values in an Excel Pivot Table
820 How to save custom functions and macros to an Add-In
821 Auto refresh a pivot table
822 7 days (weekly) date ranges using a formula
823 Search each column for a string each and return multiple records – OR logic
824 How to compare two data sets
825 Count unique distinct records (rows) in a Pivot Table
826 Sum unique distinct invoices
827 Count unique distinct records with a date and column criteria
828 Filter unique distinct records with a condition
829 Vlookup – Return multiple unique distinct values
830 Calculate running average of last 10 data with random blank cells
831 Filter unique distinct records (case sensitive) [UDF]
832 Filter unique distinct values (case sensitive) [UDF]
833 Create a dynamic named range
834 How to create a dynamic pivot table and refresh automatically
835 Combine cell ranges ignore blank cells
836 Bill reminder in excel
837 Dependent drop down lists – Enable/Disable selection filter
838 Running totals based on criteria
839 How to highlight differences in price lists
840 How to count word frequency in a cell range [UDF]
841 Fuzzy lookups [UDF]
842 Filter records based on a date range and a text string
843 Fuzzy vlookup [Array formula]
844 Text to columns: Split words in a cell
845 Highlight records containing text strings (AND Logic)
846 Filter words containing a given string in a cell range [UDF]
847 Highlight records [AND logic]
848 Highlight records – multiple criteria [OR logic]
849 Cash drawer bill extractor
850 Filter duplicate records
851 Highlight closest number
852 Merge matching rows
853 Find positive and negative amounts that net to zero [UDF]
854 Find numbers in sum [UDF]
855 Filter overlapping date ranges
856 Count digits and ignore duplicates
857 Concatenate cell values
858 Tracking a stock portfolio #2
859 List permutations no repetition [UDF]
860 Tracking a stock portfolio in excel (auto update)
861 Create a drop down calendar
862 Weekly appointment calendar
863 Monthly calendar template #2
864 Monthly calendar template
865 Count unique distinct records
866 Compare tables: Filter records occurring only in one table
867 Compare tables: Highlight records not in both tables
868 Compare two lists of data: Highlight common records
869 Filter shared records from two tables
870 Highlight duplicate columns
871 Extract duplicate records
872 Highlight duplicate records
873 List permutations with repetition [UDF]
874 Count cells based on a condition and month
875 Lookup and return multiple values concatenated into one cell
876 Automate Excel: Update list with new values
877 Use text qualifiers to make text to columns conversion easier [VBA]
878 Create a Print button [VBA]
879 Select and view invoice [VBA]
880 Populate listbox with unique distinct values [VBA]
881 Edit invoice data [VBA]
882 Save invoice data [VBA]
883 Invoice template with dependent drop down lists
884 Return multiple matches with wildcard vlookup
885 Create dependent drop down lists containing unique distinct values in multiple rows
886 Filter not shared values out of two cell ranges [UDF]
887 Filter values in common between two cell ranges [UDF]
888 Filter duplicates in a large dataset [UDF]
889 Compare two columns and return differences
890 Extract unique distinct values based on the 4 last characters
891 Apply dependent combo box selections to a filter
892 Create a drop down list containing alphabetically sorted values
893 Count unique distinct values in a large dataset [UDF]
894 Sort based on frequency and criteria
895 Sort a list in random order in excel
896 True round-robin tournament
897 Highlight records based on overlapping date ranges and a condition
898 Dynamic team generator
899 Create a random playlist
900 Team Generator
901 Sort records based on two columns
902 Case sensitive lookup and return multiple values
903 Filter unique strings from a cell range
904 Vlookup with multiple matches returns a different value
905 Filter unique distinct words from a cell range [UDF]
906 Filter duplicate words from a cell range [UDF]
907 Split words in a cell range into a cell each [UDF]
908 Extract a unique distinct list based on a condition [Pivot Table]
909 Extract a unique distinct list and sum amounts based on a condition
910 Extract dates from a cell block schedule
911 Setting up your work hours in a weekly schedule
912 Populate cells dynamically in a weekly schedule
913 Create numbers based on numerical ranges
914 Find empty hours in a weekly schedule
915 Count groups in calendar
916 Schedule recurring expenses in a calendar in excel (Personal Finance)
917 Create dependent drop down lists containing unique distinct values
918 Extract a unique distinct list sorted from A to Z ignore blanks
919 Extract dates from overlapping date ranges
920 Highlight specific time ranges in a weekly schedule
921 Weekly schedule template
922 Convert date ranges into dates
923 Convert dates into date ranges
924 List dates outside specified date ranges
925 Plot date ranges in a calendar
926 How to use absolute and relative references
927 Highlight overlapping date ranges using conditional formatting
928 Identify overlapping date ranges
929 Merge two columns with possible blank cells
930 List all unique distinct rows in a given month
931 Sort numeric values based on proximity to a given number
932 How to quickly select a non contiguous range
933 Highlight duplicates with same date, week or month
934 Filter duplicates within same date, week or month
935 Count unique distinct values within same week, month or year
936 How to count unique distinct values based on a date
937 Remove duplicates within same month or year
938 Remove duplicates based on date
939 Calculate your stock portfolio performance with Net Asset Value based on units in excel
940 Consolidate sheets [vba]
941 Get the smallest number larger than a given number
942 Automate net asset value (NAV) calculation on your stock portfolio
943 Sum based on ORAND logic
944 Rearrange values based on category [VBA]
945 Count unique distinct numbers across multiple sheets
946 Split data across multiple sheets [VBA]
947 Merge Ranges Add-In
948 Calendar with scheduling [vba]
949 Extract unique distinct year and months from dates
950 Match two criteria and return multiple records
951 Create a unique distinct list using Advanced Filter in a macro [VBA]
952 Extract records containing negative numbers
953 Create number series
954 Count cells between two values
955 Extract unique distinct values if value contains string
956 Return multiple values if in range
957 How to return a value if lookup value is in a range
958 Sort two columns
959 VLOOKUP/XLOOKUP of three columns to pull a single record
960 Using Excel Solver to schedule employees
961 Find positive and negative amounts that net to zero
962 Identify numbers in sum using Excel solver
963 Vlookup with 2 or more lookup criteria and return multiple matches
964 Filter duplicate values in a range using “contain” condition
965 Extract unique distinct text values containing string in a range
966 Filter duplicate values from a range that begins with string
967 Extract unique distinct values from cell range that begins with string
968 Formula for matching a date within a date range
969 Find latest date based on a condition
970 Filter unique distinct values where adjacent cells contain search string
971 Highlight odd/even months
972 Search values distributed horizontally and return corresponding value
973 Sum values between two dates and based on a condition
974 Most frequent value between two dates
975 Lookup min max values within a date range
976 Lookup two index columns
977 Create a quartely date range
978 Create a monthly date range
979 5 easy ways to VLOOKUP and return multiple values
980 Extract unique distinct values sorted based on sum of adjacent values
981 Filter unique values from a cell range
982 Filter unique values sorted from A to Z
983 Create a list with most recent data available
984 Extract records where all criteria match if not empty
985 Extract all rows from a range that meet criteria in one column
986 Sort text values by length
987 Create unique distinct list sorted based on text length
988 Unique distinct values sorted based on frequency
989 Unique distinct list from a column sorted A to Z
990 Identify missing numbers in a range
991 Extract numbers from a column
992 Extract unique distinct values A to Z from a range and ignore blanks
993 Create a list of dates with blanks between quarters
994 How to highlight MAX and MIN value based on month
995 Count unique distinct months
996 Identify missing three character alpha code numbers
997 Find min and max unique and duplicate numerical values
998 Reverse a list ignoring blanks
999 List values with past date
1000 Search and display all cells that contain multiple search strings
1001 Sum cells containing numbers and text based on a condition
1002 Highlight more than once taken course in any given day
1003 Sort a range based on value frequency
1004 Perform multiple partial matches and return records – AND logic
1005 Filter common values between two ranges
1006 Filter values occurring in range 1 but not in range 2
1007 Filter common values from three separate columns
1008 Filter duplicate values and sort by corresponding date
1009 Filter unique values and sort based on adjacent date
1010 Advanced custom date filter
1011 Sort a range from A to Z [Array formula]
1012 Extract a unique distinct list sorted from A-Z from range
1013 Exact word in string
1014 Highlight smallest duplicate number
1015 Extract a list of alphabetically sorted duplicates from a column
1016 Highlight duplicate values in a cell range
1017 Highlight unique values and unique distinct values in a cell range
1018 Extract duplicates from a multi-column cell range
1019 Count text string in a range (case sensitive)
1020 Search for a text string in a data set and return multiple records
1021 Search for a cell value in a dataset
1022 Count a specific text string in a cell
1023 How to create a list of random unique numbers
1024 Sort text cells alphabetically from two columns
1025 Merge two columns
1026 Merge three columns into one list
1027 How to create a unique distinct list based on two conditions
1028 Sum number based on corresponding unique value
1029 How to perform a two-dimensional lookup
1030 Extract a list of duplicates from three columns combined
1031 Extract a list of duplicates from a column
1032 Extract a list of duplicates from two columns combined
1033 Partial match based on two conditions
1034 Extract a unique distinct list from three columns
1035 Extract a unique distinct list from two columns
1036 Create a date range [Formula]
1037 Identify missing numbers in two columns based on a numerical range
1038 Identify missing numbers in a column
1039 Count unique distinct values in two columns
1040 Count unique distinct values
1041 Highlight duplicates in two columns
1042 Compare two columns and highlight values in common
1043 Sort dates within a date range
1044 Dynamic formatting
1045 Split values equally into groups
1046 Populate drop down list with unique distinct values sorted from A to Z
1047 Highlight missing values between to columns
1048 How to highlight duplicate values
1049 Lookup the nearest date
1050 Highlight every other row
1051 Partial match with two conditions and return multiple results
1052 Filter unique distinct values based on a date range
1053 Highlight dates in a date range
1054 Extract unique distinct values if adjacent cell is text
1055 Create a list of duplicates where adjacent cell value meets a condition
1056 How to rank uniquely based on a condition
1057 How to rank text uniquely without duplicates
1058 Sort column based on frequency
1059 Partial match for multiple strings – AND logic
1060 Sum unique numbers
1061 How to highlight unique distinct values
1062 Create a unique distinct list based on criteria
1063 Extract a unique distinct list sorted from A to Z
1064 How to quickly find the maximum or minimum value [Formula]
1065 Extract unique values from two columns
1066 Count dates inside a date range
1067 5 easy ways to extract Unique Distinct Values
1068 Sort a column alphabetically
1069 Extract all rows that contain a value between this and that
1070 Delete blanks and errors in a list
1071 Extract unique distinct values from a multi-column cell range
1072 Count how many times a string exists in a cell range (case insensitive)
1073 Calculate machine utilization
1074 Extract a unique distinct list and ignore blanks
1075 Extract records between two dates
1076 How to calculate a date based on specific weekday in a month
1077 How to extract not shared values in two columns
1078 How to identify two consecutive dates in a list
1079 Extract shared values between two columns
1080 How to navigate quickly in a complex workbook using hyperlinks
1081 Extract unique distinct records based on a criterion
1082 Improve your VLOOKUP formula and return multiple values
1083 How to extract email addresses from an Excel sheet
1084 How to search for a string in a column
1085 Filter unique distinct records
1086 What values are missing in List 1 that exists i List 2?
1087 Sum cells with check boxes
1088 Find closest value
1089 AVERAGE ignore 0 (zero)
1090 How to find errors in a worksheet
1091 How to create a dynamic chart
1092 How to use the OFFSET function
1093 Remove blank cells
1094 Calculate last date of a given month
1095 Find latest date in a list
1096 Find the smallest value in a list that is larger than a number
1097 Create a numbered list ignoring blank cells
1098 Choose between two data sets to VLOOKUP
1099 List all named ranges and their cell references
1100 Print consecutive page numbers across multiple worksheets
1101 Sum only visible cells
1102 Repeat headers on every page you print
1103 Rotate text to save space
1104 How to format numbers as text
1105 Excel chart components
1106 Improve worksheet readability
1107 How to create a stock chart