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.
About This Product
You can use a mask list (=an ordered list that supports mask characters), which improves the match rate and allows complex sorting (list sort).You can sort in a variety of formats that support more than 10 types. (Format sort)
■Processing overview
・List sorting Set up a list that you want arranged like this, and sort the target data in that order.
- Format sort Sort by format regardless of value - cell color, font color, etc.
・Normal sort Of course OK. Up to 100 keys For working with multiple data.
・For "sorting that you often do on a daily basis but cannot do with the EXCEL standard," such as by position or organization.
・Easy to use with samples such as position order, organization order, prefecture order, address order such as nationwide city/ward/town/village order, list order, etc.
・Format sorting makes it possible to understand data visually.
・Suitable for people who sort on a regular basis or those who sort by many keys.
■Features
Sorts the EXCEL data according to the specified parameters and outputs it to the specified location.
■Especially recommended for the following people
・People who perform common sorting operations that cannot be done using the EXCEL standard, such as by position, organization, or prefecture.
・Organizational order: In the order of the organizational chart.
・Order of position: Higher ranking positions are on top.
・Address order: Hokkaido is on top.
・Product name order: Frequently used products are on top, and other products are listed in descending order.
・Project order: Major projects at the top, other projects in descending order.
- For schools, sort by class, subject, homeroom teacher, list of schools within the district, etc.
・Person who performs regular work related to sorting.
・Those who sort by many keys.
- Those who want to easily incorporate sorting using user-created macros.
・Those who visually organize, group, and mark data.
-
Product
A macro that sorts Excel data according to specified parameters and outputs it to a specified location "Effective Cell" series sort macro
-
Handling Company
EC Research Institute Co., Ltd.
-
Categories
1 Models of A macro that sorts Excel data according to specified parameters and outputs it to a specified location "Effective Cell" series sort macro
| Product Image | Part Number | Price (excluding tax) |
|---|---|---|
|
|
Sort macro (mask list 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.
