comparision of two column

[nimrah_khan]

Mere pas excel ki do files hay ,

1)excel A me ik column hay ABC, is column me policy number hay
2)excel B me ik column hay XYZ, is column me b policy number hay

Muje in dono excel file ko compare karna hay aur koi aisa trariqa bataye ke ye muje bata de in dono column me kon konsi policy number same hay?How will i compare?

[syar]

Mere pas excel ki do files hay ,

1)excel A me ik column hay ABC, is column me policy number hay
2)excel B me ik column hay XYZ, is column me b policy number hay

Muje in dono excel file ko compare karna hay aur koi aisa trariqa bataye ke ye muje bata de in dono column me kon konsi policy number same hay?How will i compare?

There are multiple fomulas for comparision.
Assume your data start from a2, a1 is your heading row
insert a blank colum in ABC sheet. and write this formula in a2

=MATCH(B2,[xyz]Sheet1!$B$2:$B$14,0)

adjust ranges references accordingly. agar aap ko smj na aae tu apni sheet attached kr dain.

ya is mere profile m ja kar aap Miss Sitarah k question search karain. aap ko apne problem ki detail solution mil jae gi.

regards,

[miileeuko]

=cell addres = cell addres