All Categories

History

  1. Metoree
  2. Business Efficiency Systems / Software
  3. Document Management Software
  4. 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.)
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-Data selection macro (100 row condition compatible version) for business use
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.

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.

EC Research Institute Co., Ltd.'s Response Status

Response Rate

100.0%

Response Time

0.3hours

Very Fast Response

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 <blank>, <number>, <character string>, <error value>, and <logical value>.

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

Share this product


80+ people viewing

Free
Get started with our free quotation service - no cost, no obligation.

No Phone Required
We respect your privacy. You can receive quotes without sharing your phone number.

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

Image Part Number Price (excluding tax)
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-Part Number-Data selection macro (100 row condition compatible version) for business use

Data selection macro (100 row condition compatible version) for business use

Available upon quote

Customers who viewed this product also viewed

Reviews shown here are reviews of companies.

Business software that allows you to easily send emails all at once from Excel Efficient cell series Email bulk sending macro (flow compatible version) for business-EC Research Institute Co., Ltd.

Business software that allows you to easily send emails all at once from Excel Efficient cell series Email bulk sending macro (flow compatible version) for business

EC Research Institute Co., Ltd.

200+ people viewing

Last viewed: 15 hours ago

Response time: 0.33 hours

Document Management Software

3 models listed

Macro that matches two Excel data and transfers data from one to the other "Effective Cell" series Matching macro (high speed version) for business use-EC Research Institute Co., Ltd.

Macro that matches two Excel data and transfers data from one to the other "Effective Cell" series Matching macro (high speed version) for business use

EC Research Institute Co., Ltd.

120+ people viewing

Response time: 0.33 hours

Document Management Software

3 models listed

A macro that searches for a specified string and replaces it based on instructions. Can also search text boxes and folders. ``Effective Cells'' series bulk search and replace macros for business use.-EC Research Institute Co., Ltd.

A macro that searches for a specified string and replaces it based on instructions. Can also search text boxes and folders. ``Effective Cells'' series bulk search and replace macros for business use.

EC Research Institute Co., Ltd.

80+ people viewing

Last viewed: 16 hours ago

Response time: 0.33 hours

Document Management Software

3 models listed

e. Document Sorter document classification Software E.DS-NTT DATA NJK

e. Document Sorter document classification Software E.DS

NTT DATA NJK

$1,300.00

540+ people viewing

Last viewed: 6 hours ago

Response time: 69.64 hours

Document Management Software
Filing system linked to RPA-Accel View Technology Co., Ltd.

Filing system linked to RPA

Accel View Technology Co., Ltd.

130+ people viewing

Last viewed: 15 hours ago

Document Management Software

3 models listed

A macro that determines the duplicate status of target data according to a specified key, marks it, outputs it, etc. "Effective Cell" series Duplicate data macro (high speed version) For business use-EC Research Institute Co., Ltd.

A macro that determines the duplicate status of target data according to a specified key, marks it, outputs it, etc. "Effective Cell" series Duplicate data macro (high speed version) For business use

EC Research Institute Co., Ltd.

80+ people viewing

Last viewed: 13 hours ago

Response time: 0.33 hours

Document Management Software

3 models listed

Cloud type site search MARS FINDER-Mars Flag Co., Ltd.

Cloud type site search MARS FINDER

Mars Flag Co., Ltd.

$81.25

50+ people viewing

Document Management Software

2 models listed

Workflow management software Easy approval-Nippon Eye Building Soft Co., Ltd.

Workflow management software Easy approval

Nippon Eye Building Soft Co., Ltd.

70+ people viewing

Document Management Software

2 models listed

JAMA Jama Connect-Accelerated Software Engineering Co., Ltd.

JAMA Jama Connect

Accelerated Software Engineering Co., Ltd.

80+ people viewing

Document Management Software

3 models listed

Medical paper document filing system-Accel View Technology Co., Ltd.

Medical paper document filing system

Accel View Technology Co., Ltd.

110+ people viewing

Last viewed: 5 hours ago

Document Management Software

3 models listed

A macro that expands and outputs a horizontal table into a vertical table based on the specifications "Effective Cell" series Vertical expansion macro (multi-classification hierarchy compatible version) For business use-EC Research Institute Co., Ltd.

A macro that expands and outputs a horizontal table into a vertical table based on the specifications "Effective Cell" series Vertical expansion macro (multi-classification hierarchy compatible version) For business use

EC Research Institute Co., Ltd.

90+ people viewing

Response time: 0.33 hours

Document Management Software

3 models listed

Cloud-type multidimensional narrowing search service MARS SCREEN-Mars Flag Co., Ltd.

Cloud-type multidimensional narrowing search service MARS SCREEN

Mars Flag Co., Ltd.

40+ people viewing

Last viewed: 2 hours ago

Document Management Software

2 models listed

See More Document Management Software Products

Other products of EC Research Institute Co., Ltd.

Reviews shown here are reviews of companies.

Business software that allows you to easily send emails all at once from Excel Efficient cell series Email bulk sending macro (flow compatible version) for business-EC Research Institute Co., Ltd.

Business software that allows you to easily send emails all at once from Excel Efficient cell series Email bulk sending macro (flow compatible version) for business

EC Research Institute Co., Ltd.

200+ people viewing

Last viewed: 15 hours ago

Response time: 0.33 hours

Document Management Software

3 models listed

Macro that matches two Excel data and transfers data from one to the other "Effective Cell" series Matching macro (high speed version) for business use-EC Research Institute Co., Ltd.

Macro that matches two Excel data and transfers data from one to the other "Effective Cell" series Matching macro (high speed version) for business use

EC Research Institute Co., Ltd.

120+ people viewing

Response time: 0.33 hours

Document Management Software

3 models listed

A macro that searches for a specified string and replaces it based on instructions. Can also search text boxes and folders. ``Effective Cells'' series bulk search and replace macros for business use.-EC Research Institute Co., Ltd.

A macro that searches for a specified string and replaces it based on instructions. Can also search text boxes and folders. ``Effective Cells'' series bulk search and replace macros for business use.

EC Research Institute Co., Ltd.

80+ people viewing

Last viewed: 16 hours ago

Response time: 0.33 hours

Document Management Software

3 models listed

A macro that determines the duplicate status of target data according to a specified key, marks it, outputs it, etc. "Effective Cell" series Duplicate data macro (high speed version) For business use-EC Research Institute Co., Ltd.

A macro that determines the duplicate status of target data according to a specified key, marks it, outputs it, etc. "Effective Cell" series Duplicate data macro (high speed version) For business use

EC Research Institute Co., Ltd.

80+ people viewing

Last viewed: 13 hours ago

Response time: 0.33 hours

Document Management Software

3 models listed

A macro that expands and outputs a horizontal table into a vertical table based on the specifications "Effective Cell" series Vertical expansion macro (multi-classification hierarchy compatible version) For business use-EC Research Institute Co., Ltd.

A macro that expands and outputs a horizontal table into a vertical table based on the specifications "Effective Cell" series Vertical expansion macro (multi-classification hierarchy compatible version) For business use

EC Research Institute Co., Ltd.

90+ people viewing

Response time: 0.33 hours

Document Management Software

3 models listed

Macros that make tables with the same values ​​or tables that use merged cells easier to see and use "Effective Cells" series Equivalent and merged cell macros (version with font transparency)-EC Research Institute Co., Ltd.

Macros that make tables with the same values ​​or tables that use merged cells easier to see and use "Effective Cells" series Equivalent and merged cell macros (version with font transparency)

EC Research Institute Co., Ltd.

90+ people viewing

Response time: 0.33 hours

Document Management Software

3 models listed

Macro that outputs a list of files, sheets, and folders on a sheet "Effective Cell" series File sheet list macro (with ST function) For business use-EC Research Institute Co., Ltd.

Macro that outputs a list of files, sheets, and folders on a sheet "Effective Cell" series File sheet list macro (with ST function) For business use

EC Research Institute Co., Ltd.

80+ people viewing

Last viewed: 8 hours ago

Response time: 0.33 hours

Document Management Software

3 models listed

A macro that sorts Excel data according to specified parameters and outputs it to a specified location "Effective Cell" series sort macro-EC Research Institute Co., Ltd.

A macro that sorts Excel data according to specified parameters and outputs it to a specified location "Effective Cell" series sort macro

EC Research Institute Co., Ltd.

70+ people viewing

Last viewed: 39 seconds ago

Response time: 0.33 hours

Document Management Software

3 models listed

A macro that converts 7 types of right-click menus such as cells, rows, and columns into highly functional versions "Effective Cell" series Right-click conversion macro (version that supports easy batch settings)-EC Research Institute Co., Ltd.

A macro that converts 7 types of right-click menus such as cells, rows, and columns into highly functional versions "Effective Cell" series Right-click conversion macro (version that supports easy batch settings)

EC Research Institute Co., Ltd.

100+ people viewing

Last viewed: 13 hours ago

Response time: 0.33 hours

Document Management Software

3 models listed

Exceeding Excel, truly professional Excel “Effective Cell” pack product Effective Cell ALL-EC Research Institute Co., Ltd.

Exceeding Excel, truly professional Excel “Effective Cell” pack product Effective Cell ALL

EC Research Institute Co., Ltd.

70+ people viewing

Response time: 0.33 hours

Document Management Software

3 models listed


View more products of EC Research Institute Co., Ltd.

About Company Handling This Product

EC Research Institute Co., Ltd.

Response Rate

100.0%

Response Time

0.3hrs

  • Japan

Related search keywords

Document Management Software
Document Management Software　EC Research Institute Co., Ltd.
EC Research Institute Co., Ltd.

This is the version of our website addressed to speakers of English in the United States. If you are a resident of another country, please select the appropriate version of Metoree for your country in the drop-down menu.

Copyright © 2024 Metoree