Removing duplicate from Excel column using formula

HELLO 👋,

Remove duplicate from Excel table using formula.

First sort by column from which u want to remove duplicate.
Than create a new column at the right side of sorted column.
Than use formula kin cell a2=a3
Drag down the formula.
Filter by false.
Now all false values are unique.

Advance Excel In Jaipur

Advance Excel in Jaipur Only in 2500 INR in 20 Hours

• Formuals Designing
• Functions (Lookup Functions, Text Functions, Date and Time Functions, Logical Functions, Mathematical Functions etc.
• AutoFilter
• Data Sorting
• Subtotal
• Data Validations
• Pivot Table
• Text To Column
• Charts
• Group & UnGroup
• ShortCut Keys
• Macro Recording and Desiging (VBA)

Insertion Sorting Using C++

#include<iostream.h>
#include<conio.h>
void main()
{
int arr[10],i,j, temp;
clrscr();
cout<<"Enter 10 values: ";
for(i=0;i<10;i++)
 cin>>arr[i];

//Logic starts from here
for(i=0;i<10;i++)
 for(j=i;j>0;j--)
{
    if(arr[j-1]>arr[j])
    {
       temp=arr[j];
      arr[j]=arr[j-];
      arr[j-1]=temp;
    }
 
}
//Logic End

//printing of sorted array

for(i=0;i<10;i++)
 cout<<endl<<arr[i];

getch();
}

Selection Sort Using C++

#include<iostream.h>
#include<conio.h>
void main()
{
int arr[10],i,j, temp;
clrscr();
cout<<"Enter 10 values: ";
for(i=0;i<10;i++)
 cin>>arr[i];

//Logic starts from here
for(i=0;i<10;i++)
 for(j=i+1;j<10;j++)
{
    if(arr[i]>arr[j])
    {
       temp=arr[i];
      arr[i]=arr[j];
      arr[j]=temp;
    }
 
}
//Logic End

//printing of sorted array

for(i=0;i<10;i++)
 cout<<endl<<arr[i];

getch();
}

Bubble sort using C++

#include<iostream.h>
#include<conio.h>
void main()
{
int arr[10],i,j, temp;
clrscr();
cout<<"Enter 10 values: ";
for(i=0;i<10;i++)
 cin>>arr[i];

//Logic starts from here
for(i=0;i<10;i++)
 for(j=0;j<(10-i);j++)
{
    if(arr[j]>arr[j+1])
    {
       temp=arr[j];
      arr[j]=arr[j+1];
      arr[j+1]=temp;
    }
 
}

for(i=0;i<10;i++)
 cout<<endl<<arr[i];

getch();
}

Program for swap two values in C++

#include<iostream.h>
#include<conio.h>
void main()
{
     int a, b,c;
     clrscr();
     cout<<"Enter first value";
     cin>>a;

     cout<<"Enter second value";
     cin>>b;
     c=a;
     a=b;
     b=c;
     cout<<"first value is: "<<a<<"Second value: "<<b;
     getch();
}

Find out minimum value between three Coding in C++

#include<iostream.h>
#include<conio.h>
void main()
{
       int a,b,c;
       clrscr(); // clear old output
       count<<"Enter first value";
       cin>>a;
       count<<"Enter second value";
       cin>>b;
       count<<"Enter third value";
       cin>>c;
           //Logic starts from here
                if(a<b && a<c)
                   cout<<"Min value is"<<a;
                else
                     if(b<c)
                        cout<<"Min value is"<<b;
                     else
                        cout<<"Min value is"<<c;
 getch(); //stuck screen on output screen
}
                      

Find out max value between three Coding in C++

#include<iostream.h>
#include<conio.h>
void main()
{
       int a,b,c;
       clrscr(); // clear old output
       count<<"Enter first value";
       cin>>a;
       count<<"Enter second value";
       cin>>b;
       count<<"Enter third value";
       cin>>c;
           //Logic starts from here
                if(a>b && a>c)
                   cout<<"Max value is"<<a;
                else
                     if(b>c)
                        cout<<"Max value is"<<b;
                     else
                        cout<<"Max value is"<<c;
 getch(); //stuck screen on output screen
}
                      

Polymorphism

Polymorphism: Its created from two greek words "Poly" & "Morphism", which means "Many forms". Polymorphism is defining a single thing with several forms.

Works in:
Function Overloading (All OOP Languages)
Operator Overloding (Only in C++)

OOPS Characterstics

OOPS Characteristics:

1. Class
2. Object
3. Data Abstraction
4. Data Encapsulation
5. Inheritance
6. Polymorphism

CompuNet Computers: Diwali Offer

CompuNet Computers: Diwali Offer: C & C++ Course in 3000 Rupees only instead of 3500 RS. Discount of 500 Rupees.

Diwali Offer

C & C++ Course in 3000 Rupees only instead of 3500 RS.

Discount of 500 Rupees.

UML: Prototype Approch

In most of the internet site developing project we use this approach.

New Tip For Java

You Cannot create two public classes in same source file.

CompuNet Computers: New Computer with Original Parts on Good Discount

CompuNet Computers: New Computer with Original Parts on Good Discount: Offer for limited time!! VERY LESS AMOUNT!! 5% Discount on computer !! Free Antivirus!! Configuration: Intel Atom Processor & Origin...

CompuNet Computers: PIV New on Very Less prices with discount

CompuNet Computers: PIV New on Very Less prices with discount: Offer for limited time!! VERY LESS AMOUNT!! 2% Discount on computer !! Free Antivirus!! Configuration : PIV Processor Intel Chip...

CompuNet Computers: New PIV with very good discount and free antivirus...

CompuNet Computers: New PIV with very good discount and free antivirus...: Offer for limited time!! VERY LESS AMOUNT!! 2% Discount on computer !! Free Antivirus!!Not CRT with LCD Only. Configuration 1: PIV ...

New Computer with Original Parts on Good Discount

Offer for limited time!! VERY LESS AMOUNT!!
5% Discount on computer !! Free Antivirus!!


Configuration:

• Intel Atom Processor & Original Intel Mother Board (3Years Warranty)
• 2 GB RAM (2 Years Warranty)
• 500 GB Hard disk drive(HDD)(3 Years Warranty)
• DVD Reader and Writer (1 Year Warranty)
• 17 inch CRT (1 Year Warranty)
• Keyboard & Mouse 
• Intex Cabinet & SMPs

FREE ANTIVIRUS AVG INTERNET SECURITY
Price: 12000 Rupees Only


T&C Apply

PIV New on Very Less prices with discount

Offer for limited time!! VERY LESS AMOUNT!!
2% Discount on computer !! Free Antivirus!!


Configuration :

• PIV Processor 
• Intel Chip-set Mother Board (1Years Warranty)
• 1 GB RAM (1 Years Warranty)
• 500 GB Hard disk drive(HDD)(3 Years Warranty)
• DVD Reader and Writer (1 Year Warranty)
• 17 inch CRT (1 Year Warranty)
• Keyboard & Mouse 
• Intex Cabinet & SMPs

FREE ANTIVIRUS AVG INTERNET SECURITY


Price: 9,999 Ruppees only 


T&C Apply

New PIV with very good discount and free antivirus

Offer for limited time!! VERY LESS AMOUNT!!
2% Discount on computer !! Free Antivirus!!Not CRT with LCD Only.


Configuration 1:

• PIV Processor 
• Intel Chip-set Mother Board (1Years Warranty)
• 1 GB RAM (1 Years Warranty)
• 500 GB Hard disk drive(HDD)(3 Years Warranty)
• DVD Reader and Writer (1 Year Warranty)
• 18 inch LCD LG (1 Year Warranty)
• Keyboard & Mouse 
• Intex Cabinet & SMPs

FREE ANTIVIRUS AVG INTERNET SECURITY


Price: 13500 Ruppees only 


T&C Apply