Using a few tricks when working with data can greatly improve your productivity. Several one-click operations are described below.
EXCEL2007 or later
This page is taken from experience without authorization
We select the data area and click "Advanced Filtering" under the Data toolbar. Then operate in the Advanced Filtering dialog box, check "Select unduplicated records" and OK. You can then see in column B that the non-duplicate values have been filtered out.
In the following picture, we need to delete the empty cell in the data area, because it is a column separation operation, it is troublesome to repeat the selection.
We can select the data area. Then use the combination of CTL and G keys to open the positioning conditions dialog box and click "Positioning Conditions", in which select "null value".
After clicking OK, you can see that all empty columns are selected. Right-click any position in the selection to select Delete, and select Delete the whole column.
First we select the data area, then use the CTRL/T shortcut to bring up the Create Table dialog and click OK.
Then you can see that the data has generated the interlaced fill color effect, which is very convenient and fast.
As shown in the figure below, column E is obtained by adding the data from the previous columns. We need to look at the specific formula. Simply place the mouse over any cell and use the CTRL and ~ shortcuts to display the formula details.
If this experience helped you, please upvote and retweet to help more people.
