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