Data Mining in Excel
Having information is one thing, finding it is another. This chapter is dedicated to helping developers create tools that allow users to rapidly find the information they need. Having a Worksheet that contains all the data related to a particular project, experiment, or method is only the first step toward useful utilization of that information. It can be a daunting task to manually look through a large Worksheet and extricate entries of data whose parameters fall within a certain set of rules.