Tom Urtis
@tomurtis.bsky.social
Microsoft Excel MVP, Excel skills testing, project developer, trainer, author. Stanford & Michigan State athletics. My website: tomurtis.com #Excel
Tom’s Tutorials For Excel: Showing a double XLOOKUP (XLOOKUP with nested XLOOKUP) for an intersecting horizontal with vertical lookup. Download this free, safe, interactive workbook.
October 21, 2025 at 2:16 PM
Tom’s Tutorials For Excel: Showing a double XLOOKUP (XLOOKUP with nested XLOOKUP) for an intersecting horizontal with vertical lookup. Download this free, safe, interactive workbook.
SUMPRODUCT instead of VLOOKUP, XLOOKUP or INDEX MATCH
October 15, 2025 at 5:07 PM
SUMPRODUCT instead of VLOOKUP, XLOOKUP or INDEX MATCH
Creating new worksheets from a list of names, and hyperlinking the text items in that list to their respective new worksheets.
October 7, 2025 at 2:51 PM
Creating new worksheets from a list of names, and hyperlinking the text items in that list to their respective new worksheets.
Formulas to create a unique, and a unique sorted list.
September 25, 2025 at 5:57 PM
Formulas to create a unique, and a unique sorted list.
Case-sensitive Lookup.
September 17, 2025 at 4:58 PM
Case-sensitive Lookup.
Lookup at intersect of row and column.
September 16, 2025 at 4:56 PM
Lookup at intersect of row and column.
Selecting all worksheets as a group that have (optionally case-insensitive) "budget" in their tab names.
September 11, 2025 at 5:04 PM
Selecting all worksheets as a group that have (optionally case-insensitive) "budget" in their tab names.
Using a formula to transpose a horizontal range vertically.
September 10, 2025 at 7:22 PM
Using a formula to transpose a horizontal range vertically.
Disabling the pop-up menu when right-clicking onto a worksheet tab.
August 14, 2025 at 1:39 PM
Disabling the pop-up menu when right-clicking onto a worksheet tab.
Showing how to stop seeing those annoying menu floaties!
August 13, 2025 at 1:43 PM
Showing how to stop seeing those annoying menu floaties!
SUMPRODUCT instead of VLOOKUP, XLOOKUP or INDEX MATCH.
July 31, 2025 at 2:43 PM
SUMPRODUCT instead of VLOOKUP, XLOOKUP or INDEX MATCH.
Populating a text box and a worksheet cell with a single delimited string of several selected checkbox items.
July 29, 2025 at 3:11 AM
Populating a text box and a worksheet cell with a single delimited string of several selected checkbox items.
Automating your SpinButton to revert to its next valid value within a min and max numerical range.
July 22, 2025 at 4:51 PM
Automating your SpinButton to revert to its next valid value within a min and max numerical range.
This macro moves a worksheet’s embedded charts to their own chart sheet.
July 18, 2025 at 1:53 PM
This macro moves a worksheet’s embedded charts to their own chart sheet.
I am honored to share that today I was re-awarded by Microsoft as an Excel MVP for my 16th year!
July 10, 2025 at 5:06 PM
I am honored to share that today I was re-awarded by Microsoft as an Excel MVP for my 16th year!
Showing Excel VBA's UNION method to simultaneously select (or operate upon without selecting) non-contiguous ranges.
July 9, 2025 at 4:07 PM
Showing Excel VBA's UNION method to simultaneously select (or operate upon without selecting) non-contiguous ranges.
Showing the INDIRECT function maintaining a formula's intended range reference when inserting new rows inside the calculation range.
June 23, 2025 at 1:07 PM
Showing the INDIRECT function maintaining a formula's intended range reference when inserting new rows inside the calculation range.
Showing the keyboard shortcut Ctrl+Shift+F that opens the Format Cells dialog box with the Font tab selected.
June 18, 2025 at 3:10 AM
Showing the keyboard shortcut Ctrl+Shift+F that opens the Format Cells dialog box with the Font tab selected.
Showing examples to list random unique numbers between a low and high range, using formulas without VBA.
May 12, 2025 at 5:35 PM
Showing examples to list random unique numbers between a low and high range, using formulas without VBA.
April 18, 2025 at 3:50 PM
Calculating the maximum difference between two lists of numbers, and finding its row.
April 8, 2025 at 6:42 PM
Calculating the maximum difference between two lists of numbers, and finding its row.
Showing a double XLOOKUP (XLOOKUP with nested XLOOKUP) for an intersecting horizontal with vertical lookup.
#MSExcel #ExcelTips
#MSExcel #ExcelTips
March 18, 2025 at 1:03 AM
Showing a double XLOOKUP (XLOOKUP with nested XLOOKUP) for an intersecting horizontal with vertical lookup.
#MSExcel #ExcelTips
#MSExcel #ExcelTips
Using XLOOKUP with the asterisk "*" wildcard character for reverse (right-to-left) and forward (left-to-right) lookups. #MSExcel #ExcelTips #MSExcelMVP
March 11, 2025 at 9:47 PM
Using XLOOKUP with the asterisk "*" wildcard character for reverse (right-to-left) and forward (left-to-right) lookups. #MSExcel #ExcelTips #MSExcelMVP
Getting the height of a single row, or a sum of the combined heights of many rows.
March 7, 2025 at 3:03 PM
Getting the height of a single row, or a sum of the combined heights of many rows.
Conditionally operating on numbers within minimum and maximum boundaries. #ExcelTips #MSExcel
March 6, 2025 at 9:33 PM
Conditionally operating on numbers within minimum and maximum boundaries. #ExcelTips #MSExcel