These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Saturday, April 16, 2011

Approximate Find - Jason Whiting

Executive Summary

Approximate Find is an Excel Add-in that allows for specialized numerical searches. I originally conceived approximate find when trying to help a friend, a fellow PwC associate, work through cooperate and individual tax workbooks. You can search for specific values in Excel but this only allows for string comparison searches. Many times when working with different accounts and ledgers you want to find a number near a certain value. You may also come across a line item that is the aggregate of other cells and want to find which cells add up to that amount. Approximate Find allows you to give a numeric value, different tolerances (percentage, fixed range), and the number of numeric values you would like to find that add up to your target value; these features greatly extending the search capabilities of Excel

Linked Files:

Write up: http://files.gove.net/shares/files/11w/jpw2001/Approximate_Find.pdf
Project file (Excel Add-in): http://files.gove.net/shares/files/11w/jpw2001/WhitingJ_Approx_Find_Final_Plugin.xlam
Test Workbook: http://files.gove.net/shares/files/11w/jpw2001/WhitingJ_Approx_Find.xlsm

No comments:

Post a Comment

Blog Archive