Mahmoud ElMansy: knowledge meant to be free

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


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