How to count unique values in excel

-
Hi Friends Today we are going to learn about how to count unique value in excel 



# 1 First we need to Catch Unique value in excel
lets see the Excel table below for catch the unique value
Follow the step one by one
First, Select the work area of the column then select Data - >  Advanced -> Select the Step 3-> Then press Unique record Only then press ok

Result Output 

Then count the Unique Value simple Formula =COUNTIF(B2:B30,D2)

Thanks  By

VASU



Comments

Post a Comment

Popular posts from this blog

Easy ways to charge your phone Faster than ever

-
Image
Hi Friends !!! Lets see the way to charge any mobile phone Faster than ever. Listed are few steps which gives you an idea about “How to charge your phone faster”.. Tip 1:   Close all running application . This is the main step as it also closes the apps which is unused yet consumes memory. Tip 2: Switch on  "Flight mode"   It helps in faster charging.  Tip 3: Switch on “ Power Saving Mode”  Tip 4: Finally Switch off your phone and plug it to the charger. Those are the ways to increase the speed of charging. LOVE ALL SERVE ALL https://stamiltechnology.blogspot.in/ Thanks BY  VASU
Read more

How to increase system RAM size using USB

-
Image
Hi Today i tell about how to increase the system RAM size Following steps speed or Boost you Computer Performances  Steps                1.First insert the USB Pen drive                 2.Then Right click the pen drive select Proprieties                     3. Select Ready Boost tab                 4. Select the Radio Button use this Device and click apply and finally ok button                 5. your system prepare to Convert  Pen drive to RAM                 6. Finally Open ur Pen driver you can view Ready Boost Icon https://stamiltechnology.blogspot.in/   Thanks By VASU              
Read more