A macro that selects an Excel table under specified conditions and outputs it to a specified location for counting and marking. "Effective Cell" series Data selection macro
EC Research Institute Co., Ltd.
About This Product
Features
■Complex conditions such as up to 100 condition lines are possible
- Up to 100 condition lines are possible.
・You can use "Target all items every time", "Narrow down", and "Remain".
- Furthermore, up to 50 conditions can be set for each condition row.
- Flexibility in surveying the number of cases and selecting target data.
■Extensive processing content after selection
- You can output marks, change the format, output to a specified location, delete lines, and hide lines.
・Can process both matching data and non-matching data.
- Marks can be output for each condition.
-Furthermore, they can be specified simultaneously and separately.
■Method of setting on sheet
- Settings can be saved and re-executed easily.
・Can be set visually and easily under many conditions.
-Easy to add, change, and delete conditions.
・Easily reuse for other data.
・Automatic judgment can be used for the last row of data, and automatic response is possible even if the number of data items increases or decreases.
■Special values that can be used include , , , , and .
It is possible to select only strings or only numbers.
■Two processing modes are possible: ``Count only'' and ``Start processing'' which also performs update processing.
It can be processed quickly when you only want to know the number of items or check the validity of parameters.
■Others
・At the core is a specially developed high-speed select engine, and by converting macros into DLLs, high-speed processing is possible.
・Since the target data is once imported into the processing area inside the macro and then selectively processed, it can be processed even faster.
■Especially recommended for the following people
・People who are performing selection work with numerous and complex conditions
・Those who perform regular/frequent selection work
・Those who perform selection operations using special values
・Those who perform grouping work based on multiple conditions
・Those who perform work on aggregating judgment results based on a large number of complex conditions
- Persons who perform judgment work on error data (can also output all applicable error codes)
・Those who have created a macro to select
Selecting a large number of books and sheets is easy by incorporating this macro into your user macro.
■In addition, you can also use it as follows.
- Macro to delete specific values and blank lines.
・Specific value or entire data copy macro.
-
Product
A macro that selects an Excel table under specified conditions and outputs it to a specified location for counting and marking. "Effective Cell" series Data selection macro
-
Handling Company
EC Research Institute Co., Ltd.
-
Categories
1 Models of A macro that selects an Excel table under specified conditions and outputs it to a specified location for counting and marking. "Effective Cell" series Data selection macro
| Product Image | Part Number | Price (excluding tax) |
|---|---|---|
|
|
Data selection macro (100 row condition compatible version) for business use |
Available upon quote |
Customers who viewed this product also viewed
Other products of EC Research Institute Co., Ltd.
View more products of EC Research Institute Co., Ltd.
