comparing ranges

[vikram]

Hi ,

do we have a way or a macro which can compare two ranges which contain
integers and find out missing items....like there are 2 ranges....rang
A and range B,,,after running that macro i can find out what is i
range A but misssing in range B and what is in range B but not in rang
A.


any ideas...i can do with vlook up but looking for an easier way

than

 

[Frank Kabel]

Hi
for a non VBA solution see:
http://cpearson.com/excel/duplicat.htm#InOneNotOther

 

[vikram]

THANK U SIR....THANKS A LOT FOR UR HELP