08/06/2026
Lookup highest number in one column to return value in the cell on that same row in another column.
Tom Urtis / Atlas Programming
Share
Expert consulting, training, project development for Microsoft Excel. Comprehensive skills testing wi
Atlas Programming Management is all about the business of Microsoft Office, particularly Excel. We provide a variety of services and support to business clients & individual Excel users at all skill levels. Our website is also an extensive resource offering expert information, tips and tools
08/06/2026
08/04/2026
Conditional formatting top 5 scores (5 highest numbers) in a list.
08/03/2026
Counting and summing data between dates in Excel.
07/31/2026
Check out What's New in Excel (July 2026) https://techcommunity.microsoft.com/blog/ExcelBlog/whats-new-in-excel-july-2026/4523403
This month, Copilot in Excel adds support for two new frontier models: GPT-5.6 and Opus 5. You'll also find inline citations, synced connectors, Power BI grounding, brand kit and theme design skills, plus support for workbooks with AutoSave turned off.
What's New in Excel (July 2026) | Microsoft Community Hub Welcome to the July 2026 edition of What's New in Excel!
07/29/2026
Showing Excel VBA's UNION method to simultaneously select (or operate upon without selecting) non-contiguous ranges.
07/28/2026
Consolidating a range of data into a single list.
07/24/2026
Using a VBA macro to sum noncontiguous ranges of varying rows in a column.
07/20/2026
Honored to share that I was re-awarded by Microsoft as one of their MVPs for Excel, my 19th year.
07/07/2026
Counting the times that cells in 3 lists on the same row match a single criterion value.
07/02/2026
Showing a VBA InputBox example that limits to 3 attempts an incorrect -- or correct -- password entry.
Want your business to be the top-listed Gym/sports Facility in Lafayette?
Click here to claim your Sponsored Listing.
Click here to claim your Sponsored Listing.
Location
Telephone
Website
Address
Lafayette, CA
94549