Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hi Hari, U can use this simple UDF. Public Function CommonNumbers(Rng1 As Range, Rng2 As Range) Fc = "" For x = 1 To Len(Rng1.Value) src = Mid(Rng1.Value, x, 1) If InStr(Fc, src) = 0 Then Fc = Fc & src End If Next x For x = 1 To Len(Rng2.Value) src = Mid(Rng2.Value,

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hi Hari, Please find the attached file. Thanks & Regards Anil Kumar 113784 On Sun, Jun 19, 2011 at 10:33 PM, HARI NAIR wrote: > I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP > THANKS IN ADVANCE.. > > HARI > > -- > > -

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hi Try =IF(COUNTIF(B:B,A2)>0,A2,"") Thanks Mahesh On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR wrote: > I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP > THANKS IN ADVANCE.. > > HARI > > -- > > --

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hari, Find attached *Best Regards,* *Venkat* * * *Join My Group: http://groups.google.com/group/excel-miracle * On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR wrote: > I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE

$$Excel-Macros$$ HELP NEEDED FOR FORMULA

I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP THANKS IN ADVANCE.. HARI -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/