Easy Excel 🔰 Duplicate Aggregation Techniques

← Easy Excel time saving technique (@ oharu _ work)

Thank you for watching 😊

🎙️ Sound Ali Recommended

How many of these do you have? Do you filter and count them one by one? 💦

Let's graduate that way today! 🎓

Eliminate duplicates with the 'UNIQUE function' and count numbers with the 'COUNTIF function'.

If you remember this strongest combination, troublesome counting work will end in an instant ⚡

[Review of the formula to enter]

📍 Column D: = UNIQUE (C7: C26)

📍 Column E: = COUNTIF (C: C, F7)

💡 One Point

This time I explained with 20 rows of data, but if you want to increase the data steadily in the future in practice, it is recommended to select the entire table and use the same function after [tabulating] it with Ctrl + T!

Even if the data increases, the formula will automatically follow the specification ✨

[⚠️ Supplement: About range specification]

In this video, we explain how to specify the entire column (C: C) so that even beginners can easily and reliably imitate without using the $mark (absolute reference) 💡

If you want to put another data under the table, enter "= COUNTIF ($C $7: $C $26, F7)" with a fixed range instead of the entire column! Try using it according to your business data 🙌

So that you can look back at any time later, it is convenient to [Save] from the "ribbon mark" in the lower right 🔖

* It may not work depending on the version or specification

Next time, we will make your daily life easier.

i will deliver it, so please save it and look back

*********************************************

Make some free time /

Mac 17 years | Windows 3 years

We are sending the struggle story of Excel de beginner 🔰.

Please like and follow me if you like

▶️ _ work

Please feel free to DM and comment

********************************************* "

Excel Time Shortening Easy Excel Excel beginner # excel _ beginner