How to find and filter out the first and last non-null value in a sequence in Excel

How to find and filter out the first and last valid values ​​of a sequence in excel

In this example, the Chinese scores above 120 points will be highlighted with a red circle. On-screen operation steps:

Step 1: Open the score table → select the Chinese score → click the "Data" button on the menu bar → select "Validity".

Step 2: Open the "Data Validity" dialog box and select "Integer" as the allowed data type. Select "Between" below the data box, set the minimum value to 0 and the maximum value to 120, and finally click OK.

Step 3: Click the "Tools" button on the menu bar → select "Formula Review" → select to display the "Formula Review" toolbar.

Step 4: Click the "Circle Invalid Data" button.

In this way, those whose Chinese scores are above 120 points will be circled with a red circle, which plays a role of highlighting.

But these circles can only be displayed on the computer and cannot be printed. Some teachers want to print it out. After exploration, the author found a feasible method. I will explain this method below.

Print operation steps:

Step 1: Select the table → Hold down the Shift key and click the "Edit" button on the menu bar → Select "Copy Picture" → OK.

Step 2: Click the "Edit" button on the menu bar → choose to paste the image → delete the original data table → adjust the position of the copied data table.

Note: Always hold down the Shift key during the first and second steps, otherwise the operation will not be successful.

How to filter data in excel

Excel provides two data filtering operations, namely "Automatic Filtering" and "Advanced Filtering".

"Auto filter" is generally used for simple condition filtering. When filtering, data that does not meet the conditions will be temporarily hidden and only data that meets the conditions will be displayed.

"Advanced filtering" is generally used for filtering operations with more complex conditions. The filtered results can be displayed in the original data table, and records that do not meet the conditions are hidden; the filtered results can also be displayed in a new location, and the records that do not meet the conditions can also be displayed in a new location. The records of the conditions are retained in the data table at the same time without being hidden, which makes data comparison easier.

, "Auto Filter" is generally used for filtering operations with simple conditions. Records that meet the conditions are displayed in the original data table. The operation is relatively simple, and beginners are also familiar with "Auto Filter". If you want to filter multiple conditions in an "OR" relationship, or you need to display the filtered results in a new location, you can only use "Advanced Filtering" to achieve this. Under normal circumstances, the operations that can be completed by "Auto Filter" can be completely achieved by using "Advanced Filter", but some operations are not suitable for "Advanced Filter", which will make the problem more complicated, such as filtering the largest or smallest filter. Several records.

When solving problems such as data screening in actual operations, as long as we grasp the key to the problem and choose simple and correct operating methods, the problem can be easily solved.

The above is the detailed content of How to find and filter out the first and last non-null value in a sequence in Excel. For more information, please follow other related articles on the PHP Chinese website!