Tom Urtis

Ranking With Conditional Omission.

Using the DATEDIF function for elapsed time in years, months, and/or days.

Comparing 2 ranges to verify same sizes and same contents even if appearing in different order.

Showing a macro that inserts a picture onto your worksheet, positioned at the top left corner of a cell you specify.

Showing a two-column list as a single column list by its columns or rows, or as a two-row list of paired items.

Showing the DATEVALUE function to convert dates stored as text to actual dates.

Using the YEARFRAC function for differences between dates as percentage of a year.

Showing a conditional example of custom formatting numbers depending on being above or below a threshold you define.

Here is Microsoft’s What’s New in Excel blog for October 2026, for naming Tables at creation in XL for Windows, and Copilot can-do’s for data skills. techcommunity.microsoft.com/…

Showing formula syntaxes that return the count of days between today and a future date.

Using a keyboard shortcut to quickly paste special for values a range of formulas into a range of static constants.

Keyboard shortcut to select the next or previous worksheet.

Identifying the source row and listing a selected record's contents of a ListBox having vertical field dividers.

Showing a vertical divider between ListBox fields without affecting the worksheet or source data range.

Parsing a string at the position of the first numeric character.

Reordering field locations in a VBA array.

Selecting all worksheets as a group, or deselecting all but one worksheet.

Selecting more than one worksheet as a group.

Showing your active window's named ranges by setting its Zoom property to 39% or less.

Reordering field locations in a VBA array.