$$Excel-Macros$$ long opening file on the external server

Hi All,   I need your help on this issue. I have quite big file (21MB) that is doing a lot of calculation between tabs, in order to run this file more efficient I've switch off calculation, and I'm switch it on when needed. When I've done this file on my computer its opening slowly but not so ba

Re: $$Excel-Macros$$ pls help in conditional formating

Dear Ajaz, Please share a sample sheet On Fri, Jul 13, 2012 at 2:24 AM, Mohammed Hamed Ajaz wrote: > Pls help in conditional formatting > > Example > > Column A Column B name Column C due date columne D last due > date > > 5/7/12 colony > > pls provide me a formula so

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Incase of 2003 You can also use.. *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))* On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI wrote: > Hi Sunita, > > Please Try it.. > =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2) > > > > > On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल wrote: > >> Dear

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Hi Sunita, Please Try it.. =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2) On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल wrote: > Dear all, > > however this is not working out , can you please solve this where i went > wrong/ > thnx > > On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल wrote: > >> w

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Dear all, however this is not working out , can you please solve this where i went wrong/ thnx On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल wrote: > wohoo so may options thnx guys ..it really worked out > > thank you so much > > Sunita > > On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI >

Re: $$Excel-Macros$$ Please help me.

Dear Manoj, Calender in excel can be prepared by Array formula too, its purely full array for whole the months and years. =IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(C5),MONTH(C5),1

Re: $$Excel-Macros$$ pls help in conditional formating

Hi Mohammed Please see attached file, I think is what you need Chilexcel 2012/7/12 Mohammed Hamed Ajaz > Pls help in conditional formatting > > Example > > Column A Column B name Column C due date columne D last due > date > > 5/7/12 colony > > pls provide me a fo

$$Excel-Macros$$ pls help in conditional formating

Pls help in conditional formatting Example Column A Column B name Column C due date columne D last due date 5/7/12 colony pls provide me a formula so that column c and column d should turn yellow and red respectively after 20 and 30 days considering Column A Date as

Re: $$Excel-Macros$$ Re: column width - Reg

Are you wanting to do this manually? or with a macro? To do it manually, 1. Select the sheets you want updated. 2. Select Sheet1 3. Right-click on the first column to change 4. Select Column Width from the menu 5. Hit "OK" (or change the ## and hit OK) Repeat steps 3-5 for all columns...

Re: $$Excel-Macros$$ Thousand seperator in Millions

You can get this done by changing language regional settings of your PC. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: Dileep Kumar Sender: excel-macros@googlegroups.com Date: Thu, 12 Jul 2012 19:30:18 To: Reply-To: excel-macros@googlegroups.com Cc: Hase

Re: $$Excel-Macros$$ Re: column width - Reg

Dear Mothi, Please share sample workbook with group On Thu, Jul 12, 2012 at 9:37 PM, Prince Dubey wrote: > Hi Mothi, > > Please attach your workbook, your question is not clear. > > regards > prince > > On Thursday, 12 July 2012 20:48:49 UTC+5:30, mothi wrote: >> >> Dear any one >> >> I am using

Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.

=SUMPRODUCT((TRIM(A2:A22)={"sewage","sweet","garbage"})*(B2:B22)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Thursday, July 12, 2012 6:51 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Sumif / Sumproduct formula

$$Excel-Macros$$ Re: Need formula

hi Prashant, Use this =INDEX(A2:A4,MATCH(TRUE,LEN(A2:A4)<>0,0),1) with Ctrl+shift+enter regards prince dubey On Thursday, 12 July 2012 16:50:22 UTC+5:30, ppawle.excel wrote: > > Dear All, > > Need a formula for getting first text in the Range, in particular cell , > sample file attached > > R

Re: $$Excel-Macros$$ Unique list

Thanks Noorain, Can you give me a formula to retrieve this. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Thu, 12 Jul 2012 11:47:55 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Ex

$$Excel-Macros$$ Re: column width - Reg

Hi Mothi, Please attach your workbook, your question is not clear. regards prince On Thursday, 12 July 2012 20:48:49 UTC+5:30, mothi wrote: > > Dear any one > > I am using sheet1 worksheet column a to n , Column width is differents > based on datas. same data format different places up 20 she

$$Excel-Macros$$ column width - Reg

Dear any one I am using sheet1 worksheet column a to n , Column width is differents based on datas. same data format different places up 20 sheets. i want align sheet 2 to 20 column width based on sheet1. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex

RE: $$Excel-Macros$$ Need formula

Hi, Use this array formula to get 1st filled cell value in a range.hope it will help you =INDEX($A$1:$A$5,LARGE(--(A1:A5<>"")*ROW(A1:A5),SUM(--(A1:A5<>""))),1) Priti verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent:

Re: $$Excel-Macros$$ R1C1

Sunnie, Can you share spreadsheet with group as a sample. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jul 12, 2012 at 7:13 PM, Sunnie wrote: > I received a spreadsheet that is using the R1C1 reference formula. If I > turn turn off the R

Re: $$Excel-Macros$$ R1C1

Try it Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Sunnie Sent: Thursday, July 12, 2012 8:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ R1C1 I received a spreadsheet that is using the R1C1 reference formula. If I turn turn off the

Re: $$Excel-Macros$$ output of maximum number from list of combine text and number

How about a macro Sub GetMaxPerCategory() Columns("e:f").ClearContents For Each c In Range("a2:a8") Name = Split(c, "/")(0) & "/" & Split(c, "/")(1) n = Split(c, "/")(2) Set mf = Columns("e").Find(What:=Name, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xl

Re: $$Excel-Macros$$ Can´t get around a macro

I implemented this now Private Sub corrermac() Sheets("Datas").Select If Range("B1").Value = Range("C1").Value Then Call julho ElseIf Range("B2").Value = Range("C2").Value Then Call agosto End Sub Sub julho() Sheets("Dias acidente").Select Range("B2:B32").Select Selection.ClearContents Sheets("Dia

$$Excel-Macros$$ R1C1

I received a spreadsheet that is using the R1C1 reference formula. If I turn turn off the R1C1 to apply the A1 reference will that then change how the formula works? Thanks ! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread title

Re: $$Excel-Macros$$ output of maximum number from list of combine text and number

What type of solution are you looking for? (VBA macro, Excel function) What is the source of the list? (text file, excel sheet) What do you want to do with the result? (use in macro, output to Excel worksheet)   Paul - “Do all the good you can, By all the me

Re: $$Excel-Macros$$ Time calculation

Hi Noorain, Thanks for resolving the query. Now i got the correct result. Regards Lokesh.M On Thu, Jul 12, 2012 at 9:04 AM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please find the attached sheet, Hope it will help to you. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com >

Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.

So exactly what you are looking for? A drop down list to show the total in adjacent column? I have created a dropdown, if you looking for somthing else, then please explain a bit more On Thu, Jul 12, 2012 at 5:21 PM, Mohammed Muneer wrote: > Thanx *Noor *for this also, > > But I need to c

Re: $$Excel-Macros$$ Add my Outlook id

Dear Nitin, Send a mail to group Manager Mr. Ayush Jain Email ID is :jainayus...@gmail.com nitin.upadh...@in.aegisglobal.com On Thu, Jul 12, 2012 at 5:39 PM, Nitin Updhyay wrote: > Hi, Noorain > > I am not able to do this.. Link not working for new ID.. Please add my > outlook id as well >

Re: $$Excel-Macros$$ Remove 0 from Whole workbook without using Macro.(Interesting)

Why not just elect in advanced options to NOT show zeros for the workbook? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, July 12, 2012 5:55 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Remove 0 from Whole wor

Re: $$Excel-Macros$$ Add my Outlook id

Hi, Noorain I am not able to do this.. Link not working for new ID.. Please add my outlook id as well nitin.upadh...@in.aegisglobal.com On Thu, Jul 12, 2012 at 5:33 PM, NOORAIN ANSARI wrote: > Dear Nitin, > > you can join group through below link... > > http://groups.google.com/group/excel-ma

Re: $$Excel-Macros$$ Remove 0 from Whole workbook without using Macro.(Interesting)

Thanks Guru jee its great! On Thu, Jul 12, 2012 at 4:25 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached screen shot, We can remove 0 from whole workbook > without using any function or any Macro. > > See technique and revert. > > -- > Thanks & regards, > Noorain Ansari > www.noor

Re: $$Excel-Macros$$ count the name in a column

Dear Suman, Please see attached sheet, Cell C2 is criteria Field On Thu, Jul 12, 2012 at 5:30 PM, Suman wrote: > Thanks noorain jee, its working fine! Please make me sure about crireria > field why should we put c2. > > Regards, > @Suman > Send on the move with Galexy y. > On Jul 12, 2012 4:15

Re: $$Excel-Macros$$ Add my Outlook id

Dear Nitin, you can join group through below link... http://groups.google.com/group/excel-macros/subscribe On Thu, Jul 12, 2012 at 5:32 PM, Nitin Updhyay wrote: > Hi, > > Please add my mail id in your group > > nitin.upadh...@in.aegisglobal.com > > -- > FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ count the name in a column

Thanks noorain jee, its working fine! Please make me sure about crireria field why should we put c2. Regards, @Suman Send on the move with Galexy y. On Jul 12, 2012 4:15 PM, "NOORAIN ANSARI" wrote: > Dear Sundar, > > Please use.. > > =*COUNTIF(B:B,"*"&C2&"*")* > > On Thu, Jul 12, 2012 at 4:12 PM

RE: $$Excel-Macros$$ Sumif / Sumproduct formula required.

Thanx Noor for this also, But I need to change the description in same cell to get individual total. Sewage/Sweet/Garbage all this totals from one cell. Hope u understand this time. Regards, Muneer, CC... see attached sheet. On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI wrote: Dear Mune

Re: $$Excel-Macros$$ Need formula

Dear Prashant, You can try.. *=OFFSET($A$1,COUNTIF($A$2:$A$4,"<>"&""),0)* On Thu, Jul 12, 2012 at 5:04 PM, Prashant Pawle wrote: > Dear noor, > > Please let me know the formula if first cell is empty Then it shd take > next cell in array > > Regards, > > Prashant > > > On Thu, Jul 12, 2012 at 3

Re: $$Excel-Macros$$ Need formula

Dear noor, Please let me know the formula if first cell is empty Then it shd take next cell in array Regards, Prashant On Thu, Jul 12, 2012 at 3:23 PM, NOORAIN ANSARI wrote: > Dear Prashant, > > Please use > > =INDEX($A$2:$A$4,1) > > or > > =OFFSET($A$1,1,0) > > see attached sheet. > > > On Th

Re: $$Excel-Macros$$ Need formula

Dear Prashant, Please use =INDEX($A$2:$A$4,1) or =OFFSET($A$1,1,0) see attached sheet. On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle wrote: > Dear All, > > Need a formula for getting first text in the Range, in particular cell , > sample file attached > > Regards, > > Prashant > > > -- >

$$Excel-Macros$$ Need formula

Dear All, Need a formula for getting first text in the Range, in particular cell , sample file attached Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Proble

Re: $$Excel-Macros$$ count the name in a column

Dear Sundar, Please use.. =*COUNTIF(B:B,"*"&C2&"*")* On Thu, Jul 12, 2012 at 4:12 PM, Sundarvelan N wrote: > Hi Friends, > > Could you please help in counting the name in a column. > Thanks > N.Sundarvelan > 9600160150 > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Us

$$Excel-Macros$$ count the name in a column

Hi Friends, Could you please help in counting the name in a column. Thanks N.Sundarvelan 9600160150 -- 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 Nee

Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.

PFA On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI wrote: > see attached sheet. > > > On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI > wrote: > >> Dear Muneer, >> >> Please use below formula >> >> =SUMPRODUCT((A2:A8=D5)*(B2:B8)) >> >> or >> >> =Sumif(A2:A8,d5,B2:B8) >> >> >> On Thu, Jul 12, 20

$$Excel-Macros$$ Sumif / Sumproduct formula required.

Dear friends, I want to call a function/formula here that show me the sum of the each item separately from the given descriptions. Regards, Muneer, CC. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

wohoo so may options thnx guys ..it really worked out thank you so much Sunita On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI wrote: > You Can also use.. > > *=DCOUNTA($E$9:$E$49,E9,G1:G2)* > See attached sheet. > > > On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI > wrote: > >> Hi Sunita

Re: $$Excel-Macros$$ Round The Value as User Defined.

It's only my pleasure, On Thu, Jul 12, 2012 at 3:00 PM, jmothilal wrote: > i learn lot of command, thanks noorainansari > sir. > > > On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI > wrote: > >> Dear Ashish, >> >> You can also use.. >> >> *=ROUND(A2/5,0)*5 >> *

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

You Can also use.. *=DCOUNTA($E$9:$E$49,E9,G1:G2)* See attached sheet. On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI wrote: > Hi Sunita, > > You can also *try.. > > =SUMPRODUCT(--($E$10:E49="GIRL"))* > > On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > >> Dear all, >> >> Can you please

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Hi Sunita, You can also *try.. =SUMPRODUCT(--($E$10:E49="GIRL"))* On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > Dear all, > > Can you please help me to find out the total number of boy and girl ? I > used countif for their grade and it worked. However, for girl and boy > seggregation

RE: $$Excel-Macros$$ Need formula to take out total number of boy and girl

You can use COUNTIFS function. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: kri

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Dear Sunita, Find the attached sheet. Regards, Kuldeep Singh naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Thu, Jul 12, 2012 at 2:59 PM, सुनिता पौडेल wrote: > wow thnx... > is there any way to find ou

Re: $$Excel-Macros$$ Round The Value as User Defined.

i learn lot of command, thanks noorainansari sir. On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI wrote: > Dear Ashish, > > You can also use.. > > *=ROUND(A2/5,0)*5 > * > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspo

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

wow thnx... is there any way to find out like in certain grade how many girl or boy studies?? Thank you On Thu, Jul 12, 2012 at 3:11 PM, Rohan Young wrote: > just correct your answer > > =COUNTIF($E$10:E49,"GIRL") > > On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > > Dear all, > > > > Ca

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

just correct your answer =COUNTIF($E$10:E49,"GIRL") On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > Dear all, > > Can you please help me to find out the total number of boy and girl ? I used > countif for their grade and it worked. However, for girl and boy > seggregation it isnot working

$$Excel-Macros$$ Need formula to take out total number of boy and girl

Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- FORUM RULES (986+ members already BA

$$Excel-Macros$$ currency and currency Symbol

Hi Expert, Can any one provide me currency name with symbol. Divaker -- 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 quick a

Re: $$Excel-Macros$$ Round The Value as User Defined.

Dear Ashish, You can also use.. *=ROUND(A2/5,0)*5 * -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jul 12, 2012 at 9:35 AM, Ashish Bhalara wrote: > Dear experts, > > I want to round the value in following condition. > If the value is 148,149,

Re: $$Excel-Macros$$ switch on anf off calculation

Hi Don,   Thanks a lot for this,   Regards,   Pawel From: dguillett1 To: excel-macros@googlegroups.com Sent: Wednesday, July 11, 2012 1:13 PM Subject: Re: $$Excel-Macros$$ switch on anf off calculation sub yourmacro() Application.Calculation=xlCalculatio