Try Sumif
Kantilal Badale
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.47 0.40 0.26 1.05 0.21 2.50 0.0
Hi Arpita,
You can also use..
SUMPRODUCT((A1:A16>0)*(A1:A16))
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.
Hi,
Try below formula with Ctrl+Shift+Enter.
=SUM(IF(A1:A16>0,A1:A16,0))
Find the attached file.
Regards,
MARIES.
On Mon, Feb 27, 2012 at 4:32 PM, Arpita kapoor wrote:
> =><
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titl
Can you please provide code for that?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sunil jagtap
Sent: 14 December 2011 18:05
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel
gt; Regards,
> Amit Desai
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Kiran Kancherla
> Sent: 14 December 2011 13:57
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
&
half Of Kiran Kancherla
Sent: 14 December 2011 13:57
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
Hi Amit,
I have copy the data and pasted the data in a new excel sheet.
It was working fine for me.
Please try.
Regards,
Kiran.
Sent o
.com
Date: Wed, 14 Dec 2011 00:25:49
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
The link did not help
Dear Masters, please help me to improve performance of this sheet.
From: excel-macros@googlegroups.com [mailt
Dear Noorain,
Thanks.
Regards
Jitendra Singh
On Tue, Dec 13, 2011 at 11:01 PM, NOORAIN ANSARI
wrote:
> Dear Jitender,
>
> I would suggest you to go ahead and record macro and then watch and
> relate these codes by your steps, which you had taken and start
> understanding VBA.
Dear Jitender,
I would suggest you to go ahead and record macro and then watch and
relate these codes by your steps, which you had taken and start
understanding VBA. You can also refer to the Group's learning
material and find below excel macro ebook..
http://www.4shared.com/document/
dear all,
how can i learn macro.
please suggest me.
Thanks & Regards
Jitendra Singh
On Tue, Dec 13, 2011 at 10:04 PM, dguillett1 wrote:
> *http://tinyurl.com/7yt37xy*
>
>
>
> https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&
http://tinyurl.com/7yt37xy
https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&wlcxt=msdn%24msdn%24msdn&wreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspx&lc=1033&id=254354&mkt=en-US
http://tinyu
Did you try my solution??
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Anil Bhange
Sent: Thursday, October 27, 2011 11:49 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent help needed
Hi Noorain,
Thanks for the help, but it is not working at my end due
t;> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>> --
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed
Seconding Don and Paul on that. Another point that comes to the table is the
lack of proper Subject Titles that clearly and concisely describes the
problem/objective. I know that this is hinted in the forum rules, but do we not
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed
Dear Anil,
Please try through below code and see attached sheet.
Sub Consodilated_sheet_withsheetname()
Dim i, j, k, s As Long
Dim x, y, z As Long
Application.ScreenUpdating = False
x = Sheet1.Cells(1, Columns.Count
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *------
you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Thu, October 27, 2011 9:56:09 AM
Subject: Re: $$Excel-Macros$$ Urgent help needed
Anil, Pl
Anil, Please do NOT use urgent in your request as most who would help may even
put that request last on their list or ignore the request.
Try this code, assuming Master Sheet does NOT exist.
===
Option Explicit
Sub ConsodilateSheetsSAS()
Dim dlr As Long
Dim i As Long
Application.ScreenUpdati
This helps . Thank you much.
On Sun, Jul 31, 2011 at 1:18 AM, ashish koul wrote:
> Try this see if it helps
>
>
> On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee wrote:
>
>> hello
>>
>> i need to combine multiple excel files(15) into one excel file. Each file
>> has 2 sheets... R and S and data fro
Try this see if it helps
On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee wrote:
> hello
>
> i need to combine multiple excel files(15) into one excel file. Each file
> has 2 sheets... R and S and data from both needs to consolidated into
> respective sheets. .. so i need a macro which can give one f
Hi Avinash,
Try below Links,
http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/
http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/
http://www.contextures.com/excel-dashboards.html
http://www.mrdashboard.com/download.html
--
*Best Regards,*
*Venkat*
*
*
On Thu,
Hi Avinash,
Try this:
http://www.freeexceldashboards.com/exceldashboardtemplates.html
Cheers,
Andy
On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:
> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like dro
open this link
http://chandoo.org/wp/excel-dashboards/
On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:
> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like drop downs , charts, graphs
> "a dashboard with fu
Thanx Aindril,
I appreciate.
Only that it's doing the reverse, it's finding sum for those who attempted
less than 8 subjects.
What I wanted is it finding sum if only one atempted either 8 or more
subjects
the sum found should be for the least 8 subjects of all the attempted
e.g 1) If some one attem
the columns in total are over 15 so if more than 8 columns have data in them
I want to get a sum of th least 8, but if only 7 columns have data then the
sum shoulld not be put in.
coz what might happen is if some one attempted only 3 subjects it might
compute his sum which i don't want.
On 2 Novem
Hi,
It looks like your calculations are not working as you are Displaying the
numbers as text. For Example:
The following Formula:
=
IF(sheet1!Q2>74,"1",IF(sheet1!Q2>69,"2",IF(sheet1!Q2>64,"3",IF(sheet1!Q2>59,"4",IF(sheet1!Q2>49,"5",IF(sheet1!Q2>44,"6",IF(sheet1!Q2>39,"7",IF(sheet1!Q2>29,"8",IF(sh
Hi Ayoub,
Can you please explain this:
Of these columns some lack data if less than 8 of the above columns lack
data word "missed" should appear
Regards,
Andy
On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande wrote:
> Good afternoon
> I need some help on a project that is buzzing ma head
> attach
derstand it. Can you
>> > explain it.
>> >
>> > Regards,
>> >
>> > Swapnil.
>> >
>> > On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey
>> wrote:
>> >
>> >> Thanks Dave...!!!
>> >>
>> >> --
>&
it.
> >
> > Regards,
> >
> > Swapnil.
> >
> > On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey
> wrote:
> >
> >> Thanks Dave...!!!
> >>
> >> --
> >> Thanks & Regards,
> >>
> >> DILIP KUMAR PANDEY
> >>
>>
>> On 6/26/10, Dave Bonallack wrote:
>> >
>> > Hi Dilip,Excellent solution!Regards - Dave
>> >
>> > Date: Fri, 25 Jun 2010 16:48:57 +0530
>> > Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
>> > From: dilipan...@g
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>
> On 6/26/10, Dave Bonallack wrote:
> >
> > Hi Dilip,Excellent solution!Regards - Dave
> >
> > Date: Fri, 25 Jun 2010 16:48:57 +0530
> > Subject: Re:
0 16:48:57 +0530
> Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
> From: dilipan...@gmail.com
> To: excel-macros@googlegroups.com
> CC: mathan4s...@gmail.com
>
> Hi Mathan,
>
> Attached file has been solved per your requirements. Please let me know i
Hi Dilip,Excellent solution!Regards - Dave
Date: Fri, 25 Jun 2010 16:48:57 +0530
Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
CC: mathan4s...@gmail.com
Hi Mathan,
Attached file has been solved per your
You are welcome Mathan...!! :)
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Jun 25, 2010 at 6:44 PM, Mathan wrote:
> Thanks a lotSimply great!!!
>
>
> On Fri, Jun 25, 2010 at
Thanks a lotSimply great!!!
On Fri, Jun 25, 2010 at 6:12 PM, Dilip Pandey wrote:
> Hey Aindril thanks for your encouraging words... :)
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New
Hey Aindril thanks for your encouraging words... :)
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Jun 25, 2010 at 5:38 PM, Aindril De wrote:
> Hi Dilip,
>
> This is an excelle
Hi Dilip,
This is an excellent solution you have provided.. Hats off to you for
keeping it so simple..
Cheers,
Andy
On Fri, Jun 25, 2010 at 4:48 PM, Dilip Pandey wrote:
> Hi Mathan,
>
> Attached file has been solved per your requirements. Please let me know if
> it solves your problem else ge
Thanks Vinod and Dave for ur help. I appreciate all ur
effortshowever...this still does not allow me to write new macro
or make changes in the macros in this excel file. it still asks for a
VBA password for same. Plz see if u guys can crack that password for
me or let me knw how to do this.
On
hi sheetal!
why dont u copy the entire sheet.. and paste it on another (unprotected
sheet)..
a bit silly suggestion.. just chk if it works for u..
u wont atleast loose the working..
Regards,
Anubhav
On Sat, Nov 21, 2009 at 7:15 AM, sheetal lakhotia wrote:
> Hi Friends,
>
> Is there anyway to
send file
On Sat, Nov 21, 2009 at 7:29 AM, sheetallakho...@gmail.com <
sheetallakho...@gmail.com> wrote:
> Hi Friends,
>
> Is there anyway to remove or crack the VBA password from the an excel
> file. As soon as u double click to open the file. It gives a message
> that Enter password for write a
Hi, If you can open the file in Read-only mode, then do so, make the changes
you want, then Save As whatever name you want. Then just delete the original.
Regards - Dave
> Date: Fri, 20 Nov 2009 17:59:46 -0800
> Subject: $$Excel-Macros$$ Urgent Help Needed
> From: sheetallakho...@gmail.com
> To:
41 matches
Mail list logo
