Excel Magic Trick # 272: Count Unique Or Duplicate Records

[agermoune]

You have no idea how much the new column for uniq number was helpful to me.

Thank you so much for taking time to post this videa!

[ExcelIsFun]

You are welcome!

[jinu502]

Dear Excelisfun, I am your fan and a regular follower of your videos. Your videos have done wonders in my work life. Now I am teaching excel in my office and I have been recognized as Excel Guru means Mater of excel. You are the true reason for my success. I thank you very very much and wish you all the great things in your life. May God bless you with wealth, health and keep you safe and sound. May almighty fulfill your desires and keep you and your family very happy and prosperous forever.TC

[ExcelIsFun]

I am glad that the videos help and you have become the Excel Master!! That is why I put the videos out there! You can help the cause by buying my new book: "Slaying Excel Dragons" - only $20 at most online stores!! The DVD that goes with the book should be out in about 1 week available at mrexcel[dot]com

Thanks for your support, jinu502 !!

[m5kaminsky]

As someone trying to learn excel, I've tried watching your tutorials just to get the information that I need to get my work tasks done. I find your videos hard to follow and too fast for a beginner. Using too many shortcuts makes it hard for me to process what happened and what you're doing.

[mmesde]

hi there mr awesome dude..ever since you've been a great help to me..i have boasted all my formulas in my work and its all because of you..i hope to learn more..by the way, here in this video, what formula should i use in order to count the unique value and then reflect their corresponding value..

clmn1 clmn2

3  25

3 25

3 25

i need to reflect this.... (clmn1)1 and (clmn2) 25

thanks a lot!!!

[ExcelIsFun]

I have a video that shows how to do formula (very complex):

Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)

or the super easy way:

Excel Magic Trick 660: Advanced Filter Unique Records Only

The formula is when you need the process to dynamic.

The Advanced Filter method is for when you do it just once.

This video has even more detail about the formula (if you are interested):

Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)

[theyangist]

Thanks for this one and your many others. For those who might have difficulties with the first trick on OpenOffice Calc, the only difference is that the Countif(Array;Array&"") goes Countif(Array;""&Array) to avoid the division by zero error.

[ExcelIsFun]

Wow! That is a hot tip! I do not know OpenOffice Calc too well and so I appreciate the hot tip!

[zway3]

hi excellsfun!!

you are so awesome for uploading all the videos!

wt a smart way to teach!

i had no idea wt excel is 1 week ago, but after watching so many videos i feel like i have learnt so much in the past week!

I will start a new job on monday, the job title is a business analyst,wt do u think the most common functions and formulas to be used for this job?

[ExcelIsFun]

Dear zway3,

I am glad that the videos are useful!

If you are new to Excel, watch the Basics and Lookup Series. That will help with your job.

Some common business Excel features are: VLOOKUP and IF functions, Pivot Tables, Text To Column, Budget and Projection Formula Tables with Formula Inputs in Assumption area. You can search the excelisfun site to find all these topics.

Watch this video 1st:

Search For Excel Videos Download Excel Workbooks excelisfun

--excelisfun

[PrincessWithSkills]

Hi Mike Gel -

YOU ARE SO EXCEL AWESOME! I am expert certified and I have notebooks to take notes on all your videos. I have a ways to go to get through them all! Why is it that I cannot comment on your videos, only the most recent ones that you upload?

I REALLY APPRECIATE what you are doing - by the time this depression is over I will be a POWER USER of Excel.

[ExcelIsFun]

Dear PrincessWithSkills,

It is not so much as I am excel awesome, but instead I am just a guy having fun with Excel!! Taking notes is good, writing down helps to get it into the brain. If some of the videos don't allow comments, just send me an e-mail from my channel. Good for you for not sitting around during the depression, plus, any extra time is always well spent studying Excel!

--excelisfun