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, सुनिता पौडेल
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, सुनिता पौडेल
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
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
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:
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
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
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:
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
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
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
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
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..
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
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
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
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 !
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
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:
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
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
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
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
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
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
*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
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
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:
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
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
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
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
32 matches
Mail list logo