データ抽出システム付きシート

摘要

PROBLEM TO BE SOLVED: To provide a sheet with a data extraction system that can be applied to all item names in a database that can be calculated.;SOLUTION: The sheet with a data extraction system acquires values of a position of the start row, a position of the end row, and a position of the final row of a database by a data range and item name storage means A1, determines the range of extraction, and stores all item names for the position of the start row. Using an extraction condition setting and extraction means A2, an extraction item name is set, and an extraction condition expression and an extraction condition value are input so that an extraction condition expression function is prepared and data extraction is executed. Updating the extraction condition value alone allows data extraction to be continued.;SELECTED DRAWING: Figure 1;COPYRIGHT: (C)2019,JPO&INPIT