Joyce wants to look at some specific information in a very large spreadsheet. What would be the most efficient way for her to do this?
Currently, Microsoft Excel, along with Lotus 1-2-3, commands most of the market for spreadsheet applications. Tools have evolved tremendously since that first Visi-Calc program. Now users have help available at a click of their mouse along with tools such as complex formula support, formula and function builders, sorting and filtering, scenario managers (for "What-if" analysis), charts and graphs, and extended data formatting tool
Most, if not all, spreadsheet apps will have a Find or Search function. That seems to be your best option.
if it is in a spreadsheet you can export to a CSV and write/run something like a perl script to grab only the data she is interested in and write that to a new CSV she can load in her spreadsheet program.
Join our real-time social learning platform and learn together with your friends!