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

2012-07-13 Thread NOORAIN ANSARI
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, सुनिता पौडेल tosune...@gmail.com 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, सुनिता पौडेल

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

2012-07-13 Thread NOORAIN ANSARI
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 noorain.ans...@gmail.comwrote: 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, सुनिता पौडेल

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

2012-07-13 Thread NOORAIN ANSARI
Dear Ajaz, Please share a sample sheet On Fri, Jul 13, 2012 at 2:24 AM, Mohammed Hamed Ajaz mhameda...@gmail.comwrote: 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

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

2012-07-13 Thread pawel lupinski
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

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

2012-07-13 Thread सुनिता पौडेल
Hi, Still not working :( its 2010 On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: 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 noorain.ans...@gmail.com wrote:

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

2012-07-13 Thread सुनिता पौडेल
Thank you so muck Krishnaraddi ji. Still wondering where it went wrong. Anyway thanks heaps. Sunita On Fri, Jul 13, 2012 at 1:53 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also

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

2012-07-13 Thread Divaker Pandey
try to calculate required calculation with the help of macros. Divaker On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski lupins...@yahoo.comwrote: 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

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

2012-07-13 Thread pawel lupinski
I'd like to do this but my knowladge is still not there, sad but true. Maybe some other solution, please.   Regards,   Pawel From: Divaker Pandey divake...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, July 13, 2012 9:40 AM Subject: Re:

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

2012-07-13 Thread NOORAIN ANSARI
Hi Sunita, Please confirm.. Is it not working.. paste in Cell *E2* *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))* On Fri, Jul 13, 2012 at 1:22 PM, सुनिता पौडेल tosune...@gmail.com wrote: Hi, Still not working :( its 2010 On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI

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

2012-07-13 Thread Iqbal Merchant
Please share the code. Regards Iqbal M On Fri, Jul 13, 2012 at 5:15 AM, ChilExcel chilexcel...@gmail.com wrote: Hi Mohammed Please see attached file, I think is what you need Chilexcel 2012/7/12 Mohammed Hamed Ajaz mhameda...@gmail.com Pls help in conditional formatting Example

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

2012-07-13 Thread NOORAIN ANSARI
Hi lupinski, Please try it once again.. Option Explicit Sub SHRINK_EXCEL_FILE_SIZE() Dim WSheet As Worksheet Dim CSheet As String 'New Worksheet Dim OSheet As String 'Old WorkSheet Dim Col As Long Dim ECol As Long 'Last Column Dim lRow As Long Dim BRow As Long 'Last

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

2012-07-13 Thread Divaker Pandey
if you can do then. 1. Clear all formatting you have done, and reformat all same(as was initial) cell in just one step. 2. try to avoid array formula 3. Before open file set calculation mode manual Divaker On Fri, Jul 13, 2012 at 2:26 PM, pawel lupinski lupins...@yahoo.com wrote: I'd like

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

2012-07-13 Thread सुनिता पौडेल
Hi Noorain, Its working perfectly. I have tried this formulae for other sheets too. Thanx alot...I need it for my report... Have a wonderful weekend. Sunita On Fri, Jul 13, 2012 at 3:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sunita, Please confirm.. Is it not working..

Re: $$Excel-Macros$$ Unique list

2012-07-13 Thread NOORAIN ANSARI
Dear Joseph, Please try through Excel.. =IFERROR(INDEX(Lists1,MATCH(0,COUNTIF($F$1:F1,Lists1),0)),IFERROR(INDEX(List2,MATCH(0,COUNTIF($F$1:F1,List2),0)),IFERROR(INDEX(Lists2,MATCH(0,COUNTIF($F$1:F1,Lists2),0)),IFERROR(INDEX(List3,MATCH(0,COUNTIF($F$1:F1,List3),0)), Press

$$Excel-Macros$$ Query- Global Variable

2012-07-13 Thread Excel Vba
Hi Group, How can i declare a global variable for below mentioned. Private sub abc() dim sh as worksheet dim rng as range set sh = Thisworkbook.Sheets(Sheet1) set rng = sh.range(a1:csh.range(crows.count).end(xlup).row) End sub In my module i have 20 procedure and in future comes many

Re: $$Excel-Macros$$ R1C1

2012-07-13 Thread Anil Gawli
Dear Sunnie Uncheck R1c1 check box from file-Options-Formula. Hope it should work Regards, Gawli Anil On Fri, Jul 13, 2012 at 8:20 AM, Susan 1 wrote: Attached are the two spreadsheets. The one titled Aug2012 has the R1C1 formula, the file ETS2011, is the data template for this year's

Re: $$Excel-Macros$$ R1C1

2012-07-13 Thread Excel Vba
Hi Sunnie, Goto File Menu Bar, Click to options On Thu, Jul 12, 2012 at 7:13 PM, Sunnie sunni...@gmail.com wrote: 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 !

$$Excel-Macros$$ Re: Query- Global Variable

2012-07-13 Thread Excel Vba
Hi Group, Is it good practise to declare a global variable. But, when i use global variable in loop it performs better. Regards, excelvba.lear...@gmail.com

Re: $$Excel-Macros$$ Re: Query- Global Variable

2012-07-13 Thread noorain . ansari
Dear Hemant, Pls declear variable as Public and it will declear out of pocedure Like Public abc as string Sub A() Abc=ram Msg abc End sub Sub B() Abc=rahim Msg abc End sub Sent from BlackBerry® on Airtel -Original Message- From: Excel Vba excelvba.lear...@gmail.com Sender:

$$Excel-Macros$$ Search for keyword, and move all rows above found keyword to specific sheet

2012-07-13 Thread JsinSk
Hello Group, I'm attempting to automatically format a report that has several parts and break it down to what I need. The report comes in plain text and has three parts that all in with the phrase total : in the last part of that section. I'd like to see about having it break down each

$$Excel-Macros$$ File opens read only on same excel instance

2012-07-13 Thread Divaker Pandey
Hi Expert, I am facing one issue with excel. I open a excel workbook xyz.xlsm, it opens without any problem. But when I closed only xyz.xlsm, and try to reopen it, i am getting message that file is in read only mode. I tried all option. but still no clue What problem may be. can you experts

Re: $$Excel-Macros$$ Search for keyword, and move all rows above found keyword to specific sheet

2012-07-13 Thread Paul Schreiner
I think I'd skip the part about reading the raw data into the Paste Sheet. Instead, I'd read from the text file and place it in the appropriate sheet. A simple method would be like this: Option Explicit Sub ReadData()     Dim TDataFile, TextLine, TxtArray     Dim Sht, oRow, inx         TDataFile

$$Excel-Macros$$ VBA to copy the entire data without the button in the sheet

2012-07-13 Thread t vinay
Hi Team, Can any one help me with a vba code to copy the entire sheet into a new one without the button in that sheet. thanks for your help!! -- Regards, Vinay. T -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ VBA to copy the entire data without the button in the sheet

2012-07-13 Thread dguillett1
and then activesheet.shapes.cut Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Friday, July 13, 2012 1:47 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA to copy the entire data without the button in the sheet

$$Excel-Macros$$ Error--Cant Exit Design Mode

2012-07-13 Thread hanumant shinde
Hi friends. there is huge macro file which throws an error as Cant exit design Mode for few users at few occasions. we don't know when and why this error comes but it was told us that this error comes when we open Office 2003 file which has ActiveX control buttons in office 2007 version. can

$$Excel-Macros$$ Sherry's HotList

2012-07-13 Thread sherry ..
*Hi,* *Hope you are doing great today..* *Please find the updated hotlist of my consultants..* *Please send the requirements to she...@nityainc.com or feel free to call me at 801-833-0416* * * *Consultant* *Technology* *Location* *Relocation* *Karthik* *Oracle apps Finance functional

$$Excel-Macros$$ Re: Error Cleaning

2012-07-13 Thread bpascal123
Hi, You say: I need your help again.We extract the data from database each user got some errors on different projects.I need to clean the error data to get the count of errors.For this,i do text to column on error column What settings do you apply for text to columns? If you first

RE: $$Excel-Macros$$ Error Cleaning

2012-07-13 Thread Asa Rossoff
Hi SG, Please provide also a sample of the result you want. If your spreadsheet has rows that do NOT have errors, include some of those in your sample as well. If there are additional columns from the ones you included in the file you already sent, please include them. :) Asa From:

Re: $$Excel-Macros$$ Query- Global Variable

2012-07-13 Thread ╰» ℓαℓιт мσαнη
Dear If you want a variabler such that it will works for all the procedure in a module use below. dim sh as worksheet dim rng as range Private sub abc() set sh = Thisworkbook.Sheets(Sheet1) set rng = sh.range(a1:csh.range(crows.count).end(xlup).row) End sub or else If you want it access

Re: $$Excel-Macros$$ Error--Cant Exit Design Mode

2012-07-13 Thread ╰» ℓαℓιт мσαнη
Hi, Can u provide the file to make it more clear. Regards, Lalit Mohan On Sat, Jul 14, 2012 at 1:36 AM, hanumant shinde arsfan2...@yahoo.co.in wrote: Hi friends. there is huge macro file which throws an error as Cant exit design Mode for few users at few occasions. we don't know when and

Re: $$Excel-Macros$$ Re: Error Cleaning

2012-07-13 Thread ╰» ℓαℓιт мσαнη
Hi, Please attach file with sample data to make it more clear. Regards, Lalit Mohan On Sat, Jul 14, 2012 at 3:11 AM, bpascal123 bpascal...@gmail.com wrote: Hi, You say: I need your help again.We extract the data from database each user got some errors on different projects.I need to

Re: $$Excel-Macros$$ VBA to copy the entire data without the button in the sheet

2012-07-13 Thread ╰» ℓαℓιт мσαнη
Hi Give this also a try. sheet2.resize(sheet1.usedrange.rows.count, sheet1.usedrange.columns.count).value = sheet1.usedrange.value Regards, Lalit Mohan On Sat, Jul 14, 2012 at 1:12 AM, dguillett1 dguille...@gmail.com wrote: and then activesheet.shapes.cut Don Guillett Microsoft Excel