Re: $$Excel-Macros$$ plz check and help on the attached sheet the Call Macro to combine the macros is not working...

Hi You need to make the names of the macros in the call routine the same as the name in the Tools/Macro list. That is Fill1, Fill2 etc and not Macro1, Macro2 etc On Sat, Feb 25, 2012 at 8:00 PM, Mohammed Muneer wrote: > ** > > -- > FORUM RULES (986+ members already BANNED for violation) >

Re: $$Excel-Macros$$ how can i convert nomber to test

On Thu, Feb 23, 2012 at 9:06 AM, wrote: > Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees > > > Mail sent via way2sms. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Formula for bucket

Hi, Try it.. *=VLOOKUP(A1,{0,"0-2";3,"2-4";5,"4-6";7,"6+"},2,TRUE)* ** *=LOOKUP(A1,{0;3;5;7},{"0-2";"2-4";"4-6";"6+"})* Regards, MARIES. On Fri, Feb 24, 2012 at 11:31 PM, xlstime wrote: > Hi Pankaj, > > You can use Lookup function. > > please find the example sheet. > > > On Sat, Feb 25, 2012

Re: $$Excel-Macros$$ Time capture (NOW)

Sorry to come back on this I cannot use a macro for this one I need a formula Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: "dguillett1" Sender: excel-macros@googlegroups.com Date: Fri, 24 Feb 2012 14:25:31 To: Reply-To: excel-macros@googlegroups.c

$$Excel-Macros$$ Toolbar

Hi Xl2000 I want to add some macros to the existing'Tools' toolbar. Have looked at several on the net. JKP, Contextures, Vbax, etc. They seem to use mainly a floating toolbar. I just want to run a macro that says - Add this macro (from a list showing in current workbook) onto the 'Tool

RE: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

Hi Johann, That is another example usage of a boolean expression as a criterion. In your example you could actually omit the -- since you are multiplying the expression already. The multiplication will also coerce the boolean to 0 or 1: { =LARGE(($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G

Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

what about : {=LARGE(- -($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1))} ? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

Re: $$Excel-Macros$$ Time capture (NOW)

Or, you could use a double click event macro to do a time stamp target=time Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: krishnanm2...@gmail.com Sent: Friday, February 24, 2012 12:15 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Time

Re: $$Excel-Macros$$ If data is on list sheet move row to correct zone

You mention “paste” sheet which indicates that this is something you copy and paste from ?, it may be better to have an additional column with the zone there and simply filter. More explanation___? What you want can be done using FINDNEXT. Don Guillett SalesAid Software dguill

Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users

Excellent! I was looking into the belly of the beast to see if I could do that. Another lesson learned. Thank you Don. John On Fri, Feb 24, 2012 at 2:53 PM, dguillett1 wrote: > Thanks for the kind words. I made a bit of improvement to not show a > quarter if no values. > > > > Don Guillett

Re: $$Excel-Macros$$ Formula for bucket

Hi Pankaj, You can use Lookup function. please find the example sheet. On Sat, Feb 25, 2012 at 12:57 AM, Secret Shot wrote: > Dear group, > > I want to make bucket of age like 0-2,2-4,4-6 etc. > However I can do this by if formula. > But that is very lanthy formula and also excel 2003 dose not

$$Excel-Macros$$ Formula for bucket

Dear group, I want to make bucket of age like 0-2,2-4,4-6 etc. However I can do this by if formula. But that is very lanthy formula and also excel 2003 dose not support nested if greater then 7. So can anyone pls help me with any shortest way to do it pls. Regards Pankaj k pandey -- FORUM RULES

Re: $$Excel-Macros$$ count group wise

you can use pivot table. On Fri, Feb 24, 2012 at 4:58 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > Sir, > I mean, its a group wise, counting from FRA+STN wise ,, like in sql > (SELECT FRA,STN,COUNT(1) FROM COUNT GROUP BY FRA,STN > THANKS > WITH REGARDS. > RRN > > > O

Re: $$Excel-Macros$$ Dialing a Phone Number in Excel??

Hi Joy, please check below link.. http://www.mrexcel.com/archive/VBA/28261.html On Fri, Feb 24, 2012 at 10:38 PM, Ms. Joy wrote: > Someone asked me if I knew how to make Excel dial a phone number??? > Has anyone ever heard of this? How would I make this happen? Can > someone explain the logic

Re: $$Excel-Macros$$ how can i convert nomber to test

Hi Jitendraky, Please find the below link for number to text convert macro coding http://www.ozgrid.com/VBA/ValueToWords.htm *Hi Group, it is my suggestion that, before sending any query request you to kindly try to Google it self. * On Thu, Feb 23, 2012 at 9:06 AM, wrote: > Hi Team, pl

Re: $$Excel-Macros$$ Time capture (NOW)

Change sheet calculation to manual! Sam Mathai Chacko On Fri, Feb 24, 2012 at 11:45 PM, wrote: > Dear Excel Gurus, > > I need help with a formula.. All I need is to do I capture current time, > and freeze the same... For eg: if I need to enter the time as 10.01 am > using 'NOW' Excel shoul

$$Excel-Macros$$ Time capture (NOW)

Dear Excel Gurus, I need help with a formula.. All I need is to do I capture current time, and freeze the same... For eg: if I need to enter the time as 10.01 am using 'NOW' Excel should capture the time as 10.01 and not refresh it, as soon as the system time changes... I know there are a

Re: $$Excel-Macros$$ water fall chart

Dear Noorain This chart is very helpful but i am not yet sure how to make this chart. If you can help with the steps it will be of great help. Thanks in advance Sumit kumar On Fri, Feb 24, 2012 at 11:09 AM, NOORAIN ANSARI wrote: > Dear Mansoor, > > Please find Example of Water Fall Chart as at

Re: $$Excel-Macros$$ remove a certain text from every sentence

Using: [image: image.png] would be a great and dynamic way. Shekhar Sharma 9910010060 On Thu, Nov 10, 2011 at 8:45 PM, Mukesh Kumar Jha wrote: > ** > Hi Smitha, > > Try below formula > > =RIGHT(A1,LEN(A1)-FIND(":",A1)) > > Thanks > Mukesh > > - Original Message - > *From:* smitha.kumar

$$Excel-Macros$$ Let me know the idea

Good challenge to every one. I have one file that contain more then 25 column with 1 column is unique values. In that file have more then 1000 of record, i have to split that file to 6 file as *.csv format. In each file have some selected number of column likewise 7, 7, 2, 5, 2 and 2. The questi

RE: $$Excel-Macros$$ search via macro like excel

-Original message- From: Prajakt Pande Sent: 23/02/2012, 10:30 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ search via macro like excel Dear MARIES, Thank you very much. On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote: > Hi Prajakt, > > Please find the attached file.I

RE: $$Excel-Macros$$ search via macro like excel

-Original message- From: Prajakt Pande Sent: 23/02/2012, 10:30 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ search via macro like excel Dear MARIES, Thank you very much. On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote: > Hi Prajakt, > > Please find the attached file.I

$$Excel-Macros$$ Dialing a Phone Number in Excel??

Someone asked me if I knew how to make Excel dial a phone number??? Has anyone ever heard of this? How would I make this happen? Can someone explain the logic and functionality? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

RE: $$Excel-Macros$$ search via macro like excel

-Original message- From: Prajakt Pande Sent: 23/02/2012, 10:30 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ search via macro like excel Dear MARIES, Thank you very much. On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote: > Hi Prajakt, > > Please find the attached file.I

$$Excel-Macros$$ how can i convert nomber to test

Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees Mail sent via way2sms. -- FORUM RULES (986+ members already BANNED for violation)   1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will

Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

Asa, Thank you very much for taking sometime and explaining the concept for us. Skanda. On Fri, Feb 24, 2012 at 3:00 AM, Asa Rossoff wrote: > Hi Skanda, > > I don't know much about SAS, but here is an example of a common use of --* > *** > > =SUMPRODUCT(--(Customer[City]="Paris"),--(Custome

Re: $$Excel-Macros$$ Re: Required Name

2012/2/23 Kris > Hi > > In C16 and copied down, > > =INDEX($A$2:$A$12,MATCH(B16,INDEX($B$2:$F$12,,MATCH(A16,$B$1:$F$1,0)),0)) > > Kris > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need

Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

If you insist on using your original formula, try a more lengthier *=QUOTIENT(G91,1)*1440+HOUR(**G9**1)*60+MINUTE(**G9**1)+SECOND(**G9**1)/60* But *=G91*1440 will give the same answer* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 10:19 PM, Sam Mathai Chacko wrote: > *=G91*1440* > > Regar

Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

*=G91*1440* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 4:53 PM, satish wrote: > Hi all, > > I have the data in below format, I try to convert the date format in > to decimal Minutes. It comes well when the data below 24 Hrs, as soon > as it exceed 24 Hrs, it gives a wrong fig. > > I u

Re: $$Excel-Macros$$ instead of formula need macros

No helper =SUMPRODUCT((WEEKDAY($G$2:$G$17)>1)*(WEEKDAY($G$2:$G$17)<7)*($H$2:$H$17=B3)) Don Guillett SalesAid Software dguille...@gmail.com From: Lokesh Loki Sent: Friday, February 24, 2012 9:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ instead of formula need macros Hi

Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users

Don, I spent hours going through that spreadsheet and learned a lot. Thank you for your help and teaching. John On Thu, Feb 23, 2012 at 12:16 PM, dguillett1 wrote: > That’s because the defined name was not referenced in the chart > sources. > series=smith.xls!definedname > > Don Guillett >

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please see attached sheet as per ur requirement. Thanks & regards, Noorain Ansari ** *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Fri, Feb 24, 2012 at 8:45 PM, Lokesh Loki wrote: >

Re: $$Excel-Macros$$ instead of formula need macros

Hi Noorain, In the excel file i have re corrected the dates, like this i want working days for the mentioned name in macros. please see the excel file attached. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please see attached sheet with solution. >

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please use it without using Helping Column. =SUMPRODUCT(--($H$2:$H$51=B3)*(TEXT($G$2:$G$51,"ddd")<>"Sat")*(TEXT($G$2:$G$51,"ddd")<>"Sun")) On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please see attached sheet with solution. > > Hope it help to you. > >

$$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping

Dear Sir, Pl explain questions in a small para. I am enclosing a file this has col. on which I need separate XL files/sheets made. COLM D Thru F are say dummy.cud be more also. i) Separate files as per month[ col b ] ii) Separate sheets as per subjects[ col c ] Sheet names I got fro

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please see attached sheet with solution. Hope it help to you. On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki wrote: > Hi Noorain, > > Please find the attached sample excel file for your reference. > > Regards > Lokesh.M > > > On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI > wrote:

Re: $$Excel-Macros$$ instead of formula need macros

Just i want to count the working days based on names in the listed file through macros. (except Saturday and Sunday) regards Lokesh.M On Fri, Feb 24, 2012 at 8:13 PM, dguillett1 wrote: > send a file with a complete explanation. > > Don Guillett > SalesAid Software > dguille...@gmail.com > >

Re: $$Excel-Macros$$ Custom Format Examples

Gud1 Noorain Bhai - carry on On Fri, Feb 24, 2012 at 6:09 PM, Shaik Waheed wrote: > Hi Noorain, > One small question how can I set this formats as default in my excel. > > Thanks > Waheed > On Fri, Feb 24, 2012 at 5:30 PM, Kal xcel wrote: >> >> NOORAIN ROCKS ONCE AGAIN >> >> >> >> R

Re: $$Excel-Macros$$ instead of formula need macros

send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.com From: lokesh Sent: Friday, February 24, 2012 7:20 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ instead of formula need macros Hi All, I am using this formula to extract the workin

Re: $$Excel-Macros$$ instead of formula need macros

Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Can you share a sample sheet..What is your adject requirement. > > On Fri, Feb 24, 2012 at 6:50 PM, lokesh wrote: > >> Hi All,*

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh wrote: > Hi All, > > ** ** > > I am using this formula to extract the working days in a month, but this > formula is very big and while pulling the report it takes too much t

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

see attached link, please http://www.youtube.com/watch?v=B1qUrTKsnGo&context=C383e65fADOEgsToPDskKiaWsIL-0TfBoVlGZ-qD8u Insertar Imagenes Excel (Chilexcel) Directo y desde Hyperlink Chilexcel 2012/2/23 Veeru TOC > > ??...need images save in sheet wise and summary sheet > > > On Th

$$Excel-Macros$$ instead of formula need macros

Hi All, I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. So I need a macros instead of this formula. Could you please solve this query to me. Formula is = Selection.Fo

Re: $$Excel-Macros$$ Custom Format Examples

Hi Noorain, One small question how can I set this formats as default in my excel. Thanks Waheed On Fri, Feb 24, 2012 at 5:30 PM, Kal xcel wrote: > NOORAIN ROCKS ONCE AGAIN > > > > Really helpful attachment for excel user from one of the most helpful > member of the group > > Thanks

Re: $$Excel-Macros$$ Custom Format Examples

NOORAIN ROCKS ONCE AGAIN Really helpful attachment for excel user from one of the most helpful member of the group Thanks a lot brother *Kalyan Chattopadhyay* ** *Executive Sales Coordinator* *R. S. H. Pvt. Ltd.* -- FORUM RULES (986+ members already BANNED for violation) 1) Use c

Re: $$Excel-Macros$$ count group wise

Sir, I mean, its a group wise, counting from FRA+STN wise ,, like in sql (SELECT FRA,STN,COUNT(1) FROM COUNT GROUP BY FRA,STN THANKS WITH REGARDS. RRN On Fri, Feb 24, 2012 at 2:13 PM, Maries wrote: > *Explain More... > * > > On Fri, Feb 24, 2012 at 12:15 PM, raghunandan rallapalli < > raghunanda

$$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

Hi all, I have the data in below format, I try to convert the date format in to decimal Minutes. It comes well when the data below 24 Hrs, as soon as it exceed 24 Hrs, it gives a wrong fig. I used the below formula to get answers =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60 gprs - national -

Re: $$Excel-Macros$$ please help

Dear Anil, Please see attached sheet, Maries solution is good but You can do it without using helping column On Fri, Feb 24, 2012 at 3:41 PM, anil panchal wrote: > Hi, > > Please help me how to show percentage in bar chart like value > > > > > -- > > > > Thanks & Regards > Anil Kumar > > --

Re: $$Excel-Macros$$ please help

Hi, Find the attached file. On Fri, Feb 24, 2012 at 2:11 PM, anil panchal wrote: > Hi, > > Please help me how to show percentage in bar chart like value > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ please help

Hi, Please help me how to show percentage in bar chart like value -- Thanks & Regards Anil Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, an

Re: $$Excel-Macros$$ Custom Format Examples

Its really a gud one, thanks noorain On Thu, Feb 23, 2012 at 10:08 PM, chandra sekaran wrote: > thanks Noorain, its helpful for excel users lke me , > > > > On Thu, Feb 23, 2012 at 8:17 PM, xlstime wrote: > >> very useful >> >> On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI < >> noorain.ans..

Re: $$Excel-Macros$$ count group wise

*Explain More... * On Fri, Feb 24, 2012 at 12:15 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > Hello Sir, > please give me a formula for the attached sheet, FRA AND STN WISE > > THANKS > WITH REGARDS. > > RAGHU NANDAN R > > > -- > FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ count group wise

Can you elaborate a bit, based on wht u want the count On Fri, Feb 24, 2012 at 1:45 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > Hello Sir, > please give me a formula for the attached sheet, FRA AND STN WISE > > THANKS > WITH REGARDS. > > RAGHU NANDAN R > > > -- > FORUM