RE: $$Excel-Macros$$ Required Unique Words.

ros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Fri/2012 03:39 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Unique Words. Dear Raghu, I hope your requirement is this one.. =(LEN(A1)-LEN(SUBSTITUTE(A1,"gole","")))/LEN(B2) See atta

RE: $$Excel-Macros$$ Required Unique Words.

Hi Noorain.. Its not static .. text can be change.. need a dynamic solution Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Fri/2012 03:39 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required

Re: $$Excel-Macros$$ Required Unique Words.

Dear Raghu, I hope your requirement is this one..* =(LEN(A1)-LEN(SUBSTITUTE(A1,"gole","")))/LEN(B2)* See attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*