Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about how to use one Excel to filter another Excel. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Functions such as vlookup can be used to solve this problem, although the whole process is not too difficult, but as long as the data changes, the process is repeated every time, which is too tedious. You can automate this process with VBA, but the writing is so complex that it is difficult for ordinary people to master.

It's much easier to use esProc, and it takes only a few lines of code to filter:

ABD1=file ("param.xlsx") .xlsimport () = A1. (_ 1) / Open the Excel where the parameters are stored, and take the first column 2=file ("all.xlsx") .xlsimport ()

/ Open the Excel where the complete data is stored. 3=A2.select (B1.contain (_ 2))

/ filter the second column of A2 with B1 and return rows that meet the criteria. 4=file ("result.xlsx") .xlsexport@A3)

/ the result is written to the new Excel

Filtering by multiple columns is also easy. For example, param.xlsx has two columns, the first row of which are named cust and seller. To filter all.xlsx with these two columns, the code should be written:

ABD1=file ("param.xlsx") .xlsimport@t () = A1. ([cust.seller]) / @ t indicates that the first line is the column name 2=file ("all.xlsx") .xlsimport ()

3=A2.select (B1.contain ([_ 2 ~ (3)]))

/ filter the 2nd and 3rd columns 4=file ("result.xlsx") .xlsexport@A3 of A2 with B1)

EsProc has a desktop IDE in web format, which can actually view the calculation results directly or without having to save them.

After reading the above, do you have any further understanding of how to use one Excel to filter another Excel? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.