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

It is believed that many inexperienced people have no idea about how to realize the dynamic hidden row effect in Exce. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

In business systems, we often encounter such requirements: some data can only be displayed when certain conditions are met, and rows that do not meet the conditions are not needed. At this point, you can use the property of hidden rows to implement this requirement. As shown in the following figure:

In the E6 cell, what we do is the statistics of the total amount of the order with a different product name under the ID of each order, but I only want to show the data that the total amount of the order is greater than 5000. At this time, we can make a judgment on the result value of the E6 cell, select lines 5 and 6, and write the hidden line expression on the right: if (E6).

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.