Most repeating values considering Other column

[ismailzkhan]

Dear Excel Experts,

Please help in getting this resolved. I need to enter most repeating value from B:B considering A:A. Attached example and desired result

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[p45cal]

Another..

 

[ismailzkhan]

Dear Narayan & p45cal,

Both works like charm. You Guyz rocks... Thanks a ton!!

Regards,
I Khan