Re: $$Excel-Macros$$ how to build a sortinf button

Dear Dhaval, Pl elaborate you queries four sorting is workingwhat u want excatly... Warm Regards, Gawli Anil On Fri, Jan 18, 2013 at 12:40 PM, Dhaval Shah wrote: > Friend i want to make a four different button for sorting data > > here with attach a sample file for reference > > -- >

Re: $$Excel-Macros$$ Extract Price from cell link text

Hi Amar, When we use "*instr*" function it give us the first position of the text we want to search in a string for Example: "Hindustan Times is an India news paper : 123" in above string i want to get any word after the Word "Paper" i have to search word "Paper" first so i will use instr fu

Re: $$Excel-Macros$$ Extract Price from cell link text

Thank u so much...Prince,Ashish, Excel Beginner for your kind help.I teaching some from this formula. Thanks very much friends.But i asked Question Ashish & Prince what is 16 numbers in formula for prince & what is 15 numbers in formula for ashish. On Thu, Jan 17, 2013 at 10:31 PM, >>Excel Beg

Re: $$Excel-Macros$$ Count in cell formula

Dear All My friend, Thanks everybody to solved my problem & spent time for my solution. With the help of expertise, I am very Glad Regards Amar On Fri, Jan 18, 2013 at 10:32 AM, अनिल नारायण गवली wrote: > Hey Our User , > > Yaar don't get personal afterall we have to help others. > >

Re: $$Excel-Macros$$ Count in cell formula

Hey Our User , Yaar don't get personal afterall we have to help others. Warm Regardsm Gawli Anil On Fri, Jan 18, 2013 at 2:46 AM, Excel_Lover wrote: > ha ha!!! > > > > On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner > wrote: > >> @ Noorain Ansari, >> >> Could you ple

$$Excel-Macros$$ VBA code to sort all worksheet tabs alphabetically, except some.

Dear Experts I have a workbook with a no. of worksheets. New worksheets are being added to it regularly. I am using below code to sort the worksheets after the addition of any new sheets. Now I need your help to modify this code so that it will keep some of the sheets (say named "Summary", "Profil

Re: $$Excel-Macros$$ Count in cell formula

ha ha!!! On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner wrote: > @ Noorain Ansari, > > Could you please explain what is the use of *Sumproduct* in your below > formula? > > *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1)* > > Why not it should be *LEN(C5)-LEN(SUBSTITUTE(C5,

Re: $$Excel-Macros$$ Count in cell formula

venus On Jan 17, 2013 3:41 PM, "amar takale" wrote: > Dear champs > Pl suggest simple count formula in cell > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > He

Re: $$Excel-Macros$$ Need formula

Hi Deepak, Below mentioned formula used of worksheet cell "B2" or find the attachment. =ROUNDUP(SUM(IF(Data! B2:B12=Summary!A2,1/COUNTIF(Data!E2:E12,Data!E2:E12),0)),0) -- *Regards,* * * *Excel Beginner* On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote: > HI, > > Could u s

Re: $$Excel-Macros$$ Excel rename file in folder

Do you have a specific question? Or are you asking someone to do it for you? Keep in mind that this is a "help" forum.. not a "free programming" service. although we end up doing that a lot too... If you're asking for help, we need to know what you have so far and what you're having trouble wi

$$Excel-Macros$$ Excel rename file in folder

Hi, I have 150 files in my folder and all my files to be renamed starting with A using VBA macro. Example : if the file name is ABC it is to be replaced with A-ABC similarly if the file name is XYZ and is to be replaced with A-xyz. Thanks, Vishwa. "CONFIDENTIALITY NOTICE: This message and any

Re: $$Excel-Macros$$ Extract Price from cell link text

Hi Amar, Below is the solution to your needs or check the attachment. =--MID($C$2,SEARCH(B6,$C$2)+(LEN(B6))+3,FIND(,$C$2,SEARCH(B6,$C$2)+(LEN(B6)+3))-(SEARCH(B6,$C$2)+(LEN(B6)+3))) -- *Regards,* * * *Excel Beginner* On Thu, Jan 17, 2013 at 7:03 PM, amar takale wrote: > All Dea

$$Excel-Macros$$ Re: Extract Price from cell link text

Hi Amar, PFA Regards Prince On Thursday, January 17, 2013 7:03:14 PM UTC+5:30, amar takale wrote: > > All Dear, > > Can you suggest any formula.Pls suggest > Appreciate the help > > Amar > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Us

Re: $$Excel-Macros$$ Need formula

Deepak Watch this video you will be able to solve your problem on your *OWN* http://www.youtube.com/watch?v=27qh1i_kgCY Regards Ashish Koul On Thu, Jan 17, 2013 at 5:18 PM, Deepak Rawat wrote: > Hi, > thax for reply > but still unsolved in panchayat it should come 2 rather than 5 > > Regards,

Re: FW: $$Excel-Macros$$ need formula Highlight

Hi Manjunath, PFA, Regards Prince On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa wrote: > > Dear all, > > > > Please can I get macro for below requests > > > > Regards > > Manjunath > > > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googleg

Re: FW: $$Excel-Macros$$ need formula Highlight

you can use conditional formatting for this  --- On Thu, 1/17/13, Manjunath Narayanappa wrote: From: Manjunath Narayanappa Subject: FW: $$Excel-Macros$$ need formula Highlight To: "'excel-macros@googlegroups.com'" Date: Thursday, January 17, 2013, 6:41 PM Dear all,   Please can I g

Re: $$Excel-Macros$$ Any one help to solve the Test

Dear Team, Can any one to help to solve the attached test sheet. On Tue, Jan 15, 2013 at 9:50 PM, Pankaj Singh wrote: > Dear Team, > > > Kidly help so sole the test sheet. > > > Thanks > pankaj kumar > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel >

Re: $$Excel-Macros$$ Extract Price from cell link text

see attachment On Thu, Jan 17, 2013 at 7:03 PM, amar takale wrote: > All Dear, > > Can you suggest any formula.Pls suggest > Appreciate the help > > Amar > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thr

Re: $$Excel-Macros$$ Please Try this ,I assure you will be benefited

Hi Aju, Could you please share the coding part also.. so we can learn. On Thu, Jan 17, 2013 at 10:10 AM, Aju Chacko wrote: > Please see the *Reconciliation Tool *attached herewith,Which is an * > EXCEL-ADDIN* created by me.Which very useful for Handling large excel > database. This utility has

$$Excel-Macros$$ Extract Price from cell link text

All Dear, Can you suggest any formula.Pls suggest Appreciate the help Amar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

FW: $$Excel-Macros$$ need formula Highlight

Dear all, Please can I get macro for below requests Regards Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 17 January 2013 08:47 To: 'excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ need formula Highlight

Re: $$Excel-Macros$$ Need formula

Hi, thax for reply but still unsolved in panchayat it should come 2 rather than 5 Regards, Deepak Rawat On Thu, Jan 17, 2013 at 12:27 PM, Amresh Maurya wrote: > On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat > wrote: > > Dear Anoop, > > > > I need as i given table. > > > > regards, > > Deepak

Re: $$Excel-Macros$$ Count in cell formula

Okay i gotbut i have not taken 30 minutes for this solution. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On

Re: $$Excel-Macros$$ Count in cell formula

@ Noorain Ansari, Could you please explain what is the use of /*Sumproduct*/ in your below formula? /*=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1)*/ Why not it should be /*LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1*/? Since both will result the same answer. *My Suggestion Posted HALF AN HOU

Re: $$Excel-Macros$$ Sum based on cell criteria

Pls help me on this topic. On Thu, Jan 17, 2013 at 1:17 PM, amar takale wrote: > Pls suggest formula > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Ur

Re: $$Excel-Macros$$ Count in cell formula

If cell is non-blank you can use. it.. On Thu, Jan 17, 2013 at 4:19 PM, NOORAIN ANSARI wrote: > Dear Amar, > > You can also try... > > *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1) > * > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

Re: $$Excel-Macros$$ Count in cell formula

Dear Amar, You can also try... *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1) * -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com

Re: $$Excel-Macros$$ Count in cell formula

psl find attached herewith Warm Regards, Gawli Anil On Thu, Jan 17, 2013 at 3:48 PM, Ms-Exl-Learner wrote: > =IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1,"") > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook

$$Excel-Macros$$ Re: Count in cell formula

Hi Amar, Here is your formula. =LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1 Regards Prince On Thursday, January 17, 2013 3:40:51 PM UTC+5:30, amar takale wrote: > > Dear champs > Pl suggest simple count formula in cell > -- Join official Facebook page of this forum @ https://www.facebook.com/discu

Re: $$Excel-Macros$$ Count in cell formula

* In D5 cell =IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1,"") Drag it down...* On 17-01-2013 3:40 PM, amar takale wrote: Dear champs Pl suggest simple count formula in cell -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use co

$$Excel-Macros$$ need help : in creating master data

Hi Excel Gurus Kindly Help urgent Please find the attached file, they are standard weight of structural steel sections in ABS sheet of the work book, when i want to work in a new sheet of the work book the standard weight of the section should get automatically uploaded as i enter the name of t

$$Excel-Macros$$ Count in cell formula

Dear champs Pl suggest simple count formula in cell -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ need formula Highlight

Dear Manjunath, Pl find attached herewith. Is it OK? Warm Regards, Gawli Anil On Thu, Jan 17, 2013 at 2:17 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Expert, > > > > Good afternoon have a nice day :) > > > > I have a data in the attached spreadsheet, automatic

$$Excel-Macros$$ need formula Highlight

Dear Expert, Good afternoon have a nice day :) I have a data in the attached spreadsheet, automatically data in B column should get highlighted when there is a duplicate or repeated entry. Please help me on this. Thanks Manjunath PLEASE CONSIDER THE ENVIRONM