Look Who it Was Random video

Excel - Audit a Spreadsheet to Look for Double Billing - Episode 1017

916 views · Published 19 May 2009 · 5:46 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel Look for Double Billing with VBA Macro.

Welcome back to the MrExcel netcast!  The question for today's video was sent in by Sean, who wanted to know if there was a way to audit a spreadsheet for any double billing. This is a common issue faced by businesses, where they need to check if any locations were billed twice. I will be using a similar situation from my book, Excel Gurus Gone Wild, to demonstrate how to solve this problem.

Rather than digging out my book and figuring out the formula, I decided to quickly knock out some VBA code to solve this issue. I will be using a loop to go through each row of data and check for any duplicate locations. This method is much simpler and more efficient than using complex formulas.

To make it easier for you to follow along, I have provided the VBA code in the video description. You can also find it in my book, Excel Gurus Gone Wild, or in my Power Macros for Excel class, which is available on DVD-ROM. This class is perfect for those who want to learn VBA and be able to write code like this to solve their Excel problems.

Thank you, Sean, for sending in this question and thank you for watching this netcast from MrExcel. Don't forget to check out our website and Amazon for more Excel resources. And if you ever find yourself in Akron, Ohio, be sure to attend our Power Macros for Excel class at the University of Akron. See you next time for another netcast from MrExcel!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction
(00:14) The Problem
(00:24) Solution with VBA
(03:00) Testing the Code
(04:00) Benefits of Learning VBA
(05:22) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Auditing spreadsheets for double billing
Concatenating keys in Excel using VBA
Creating simple solutions in Excel using VBA
DVD-ROM course on Excel VBA programming
Learning VBA for Excel programming
MrExcel netcast episodes and tutorials
Power macros for Excel class at the University of Akron
Quick and dirty solutions for data analysis in Excel
Sorting and checking for duplicates in Excel
Tips and tricks for Excel data analysis and automation
Using VBA to solve spreadsheet problems
YouTube video on analyzing data using pivot tables

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152424/



Shawn sends in today's question. The spreadsheet has billing data to audit. For each record, there is a location, a start date, and an end date. Shawn wants to find any records where the same date and location is double-billed. A quick two-loop macro solves this problem. Episode 1017 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

More from this channel