Excel MATCH Function (Compare two array of Data)
Match Function
Is a very handy Excel Function
It can be used if you have to lest of data and you want to compaire them.
Meanes if you have common data in the two list and you want to fiend the
Similara data and the position and fiend the order index of it And to know the data that is unique.
For all that we can use MATCH Function
Useage
First copy you data to excel sheet
And write in an empty column =MATCH(,,,)
It takes 3 Parameters
First Select The Hole first column
Second Select The Hole Second Column
Third is an Option For Comparison
0 Exact Match
1 Less Than
-1 Greater Than
And Highlight the column and Get The difference