Shulou(Shulou.com)11/24 Report--

The original title: "Don't blink!" Quickly find repeated values, this trick will be learned as soon as it is learned. "

This is repeated with this, and so is this.

Oh, my God, little E's eyes are going to be dazzled!

What shall I do?

The boss asked Xiao E to mark the repeatedly entered information in a large amount of data, and then count the number of repetitions.

Finally, we have to delete all these duplicate values. It is very difficult to find them one by one. Can Xiao E still get off work today?

Anyway, in order to get off work on time, I have to. Go hug your thighs.

Little E: cousin, can you teach me how to handle the repetition value?

Cousin: it's not easy. Watch me!

Tag duplicate values are general, and we will quickly mark duplicate values with the help of the conditional format function.

The method of operation is also simple:

First, we need to find conditional formatting-highlight cell rules in the start tab.

Then, select [repeat value] to ok ~

How is it? is it very simple?

Of course, this method is also flawed.

For example:

❶ cannot find duplicate values of multiple columns at the same time

❷ cannot find duplicate values of multiple worksheets at the same time

.

Next, let's learn how to count the number of repetitions.

To count the number of repeats here, we need to use the COUNTIF function, which can be done in a simple 4 steps.

❶ selects the cell next to the second row of data and enters the function

❷ chooses the statistical range, remember to add the dollar sign fixed

❸ Statistical conditions Click the first cell of the line, and press enter

❹ double-click the fill.

Got it!

The repetition count is complete, and the boss asks us to delete all duplicate values.

How do I do that? Look down there.

Delete duplicate values We can delete duplicate values by making use of the features that come with Excel.

Select the data, click "data Tab"-"data tools"-"Delete duplicate values", and do it in one go!

But be careful!

When you use [duplicate values] in [conditional format] to find out whether there are duplicate values, it is not valid for numbers with more than 15 digits.

After watching my cousin's divine operation, Xiao E has learned!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: witty Qiu Xiao E

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.