Re: $$Excel-Macros$$ calculate previous month dates using the given date

2014-02-11 Thread DILIPandey
Hi Kathirvelan,

You need dates between 2Jan to 1 Feb
or, 2 Jan to 3 Feb ?



On Tue, Feb 11, 2014 at 12:44 PM, KATHIRVELAN N nkathirv1...@gmail.comwrote:

 Dear Friends,

 I need to calculate previous month dates using the given date

 Given Date : 03-Feb-2014

 From Date Should Be : 02-Jan-2014

 To Date : 01-Feb-2014

 Thanks,
 Kathirvelan

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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 attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Thanks  Regards,

DILIP KUMAR PANDEY,
mvphttps://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851
   MBA,BCA,B.Com(Hons)
UAE +971 528225509 India +91 9810929744
dilipan...@gmail.com, dilipan...@yahoo.com

Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Re: $$Excel-Macros$$ Complex formula....

2014-01-16 Thread DILIPandey
Can you share your expected output as well - manually entered ?



Regards,
DILIPandey


On Thu, Jan 16, 2014 at 5:22 PM, amar takale amartak...@gmail.com wrote:

  Dear expert team,

 PFA with detailed in sheet.


 I know this is a very big stuff, hoping that someone helps me to get it
 done.

 Please do the needful.  Thank you,


 Regards,

 Amar T



  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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 attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Thanks  Regards,

DILIP KUMAR PANDEY,
mvphttps://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851
   MBA,BCA,B.Com(Hons)
UAE +971 528225509 India +91 9810929744
dilipan...@gmail.com, dilipan...@yahoo.com

Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Re: $$Excel-Macros$$ SUMPRODUCT: #VALUE ERROR

2014-01-15 Thread DILIPandey
Hi MLT,

Try using below formula which need to be confirmed using key combination:
ctrl shift enter

=IF(ISNUMBER(MATCH(A5,MID($A$1:$A$3,MIN(IFERROR(SEARCH($A$4,$A$1:$A$3),))+2,1)*1,0)),Matching,NotMatching)


Regards,
DILIPandey


On Tue, Jan 14, 2014 at 6:10 PM, MLT mlthorn...@gmail.com wrote:

 I'm looking for some help with one of the components of a SUMPRODUCT
 formula that is causing the formula to error:

 Starting in A1:

 alpha137
 beta224
 gamma492

 in A4: 49
 in A5: 2

 The idea is for one of the components of the SUMPRODUCT formula to look
 for a string (in A4) in each cell in the range (A1:A3) and return the
 number character that follows the string to see if it's equal to a certain
 value (A5).

 The problem is that since 49 does not necessarily appear in all cells,
 it creates an error for all those, causing the entire formula to error.

 Any suggestions?

 =SUMPRODUCT((MID(A4,FIND(49,$A$1:$A$3)+2,1)=A5)*()*...*()

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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 attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Thanks  Regards,

DILIP KUMAR PANDEY,
mvphttps://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851
   MBA,BCA,B.Com(Hons)
UAE +971 528225509 India +91 9810929744
dilipan...@gmail.com, dilipan...@yahoo.com

Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Re: $$Excel-Macros$$ macro code

2014-01-15 Thread DILIPandey
Hi Boreh,

Assuming I = 1,
That code is assigning available value in cell B6 to a variable name
AccName and then on the next cell i.e., Cell C6, it is populating the
value of G8 picked up from sheet whose name is there in Cell B6.

Cells(5 + I, 2)  is B6
Cells(5 + I, 3) is C6
Cells(8, 7) is G8 of another sheet

Hope this is clear.  Thanks.

Regards,
DILIPandey



On Thu, Jan 16, 2014 at 10:20 AM, Robinson Boreh rbo...@gmail.com wrote:

 Hi.

 I have macro code below. In layman's terms, can someone tell me what
 exactly it means. Am trying to learn macro

 'Enter Op. Bce
 AccName = Cells(5 + I, 2)
 Cells(5 + I, 3) = Sheets(AccName).Cells(8, 7)

 Regards,
 Boreh

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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 attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Thanks  Regards,

DILIP KUMAR PANDEY,
mvphttps://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851
   MBA,BCA,B.Com(Hons)
UAE +971 528225509 India +91 9810929744
dilipan...@gmail.com, dilipan...@yahoo.com

Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Re: $$Excel-Macros$$ Privacy Warning for macro enabled excel

2014-01-15 Thread DILIPandey
Can you upload that file (after removing sensitive data) ?


Regards,
DILIPandey


On Thu, Jan 16, 2014 at 10:32 AM, Robinson Boreh rbo...@gmail.com wrote:

 Hallo to you all.
 I converted an excel 2003 with macro to a 2010 excel enabled macro by
 using save as option. I now get an warning every time i save. The message
 goes like this *Privacy warning: This document contains macros, ActiveX
 controls, XML expansion pack information, or web components . These may
 include personal information that cannot be removed by Document Inspector.*
 How do i get rid of this message?

 Regards,
 Boreh

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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 attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Thanks  Regards,

DILIP KUMAR PANDEY,
mvphttps://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851
   MBA,BCA,B.Com(Hons)
UAE +971 528225509 India +91 9810929744
dilipan...@gmail.com, dilipan...@yahoo.com

Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


$$Excel-Macros$$ Re: Formula Sorting Data (Alpha + Numeric)

2011-10-13 Thread DILIPandey
Hi,

Do you want only 'figures' to be sorted out OR do you want numbers
only to be sorted out ?

Regards,
DILIPandey
--
Thanks  Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

On Oct 13, 2:46 pm, B Sharma sharma@gmail.com wrote:
 Dear Excel Experts  (and to my friends who have answered to my
 earlier queries)

 From a long time, I am searching for a formula which can sort the list
 and represent the unique datas only

 for Example , In column 1 I have the following data

 52
 86
 92C
 94B
 94B
 195
 193
 ABC
 XYZ
 87
 94J
 94B
 94K
 94C

 like this...
 I want a output in column B where it will ignore the duplicate items
 and sorted figures.

 I think its quiet difficult but please try this ...

 Thanks  Regards,
 B. Sharma

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Re: Total displayed as -1.776E-13 .. why not Zero????

2011-07-15 Thread DILIPandey
Hi Markkim,

I have checked that the answer of the formula =IF(A54=0,1,0) is 1
because A54 is blank in your sample sheet.

If I assume that you will have some value in A54, then the answer will
be 0 and then your below code is working fine :-

If range(A54)  0 then

Else
.
End If

Please check if this helps and let us know if you are revisiting your
explanation.
--
Thanks  Regards,

DILIP KUMAR PANDEY, mvp
 MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India



On Jul 14, 1:06 pm, Markkim mark@gmail.com wrote:
 Hi

 I have an issue with suming up numbers..

 when I sum up, it shows as -1.776E-13   ... not as Zero.

 I know I can fix it by simply changing the format cell to number.

 But the issue is that excel doesn't think it is Zero.

 in the sample worksheet,  Range C54 contains a following formular

 =IF(A54=0,1,0)

 And the result is 0   meaning it thinks A54 is not zero.

 I need Excel to think it is zero otherwise the macro I'm writing will not
 work.

 How can I make Excel think it's Zero.? ..   because I need to write like

 If range(A54)  0 then
 
 Else
 .
 End If

 Please help me!!

 Thanks

  untitled.xls
 18KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Re: months and fraction of a month between two days

2011-07-12 Thread DILIPandey
Hi Richard,

If the dates are present in B10 and C10, use following formula:-

=(DAY(EOMONTH(B10,0))-DAY(B10)+1)/DAY(EOMONTH(B10,0))
+IF(ISERROR(DATEDIF(DATE(YEAR(B10),MONTH(B10)+1,DAY(B10)),DATE(YEAR(C10),MONTH(C10)-1,DAY(C10)),m)),-1,DATEDIF(DATE(YEAR(B10),MONTH(B10)+1,DAY(B10)),DATE(YEAR(C10),MONTH(C10)-1,DAY(C10)),m))
+1+(DAY(EOMONTH(C10,0))-DAY(C10)+1)/DAY(EOMONTH(C10,0))

Also, I have tried achieving more accurate calculations as per below
scenario, shared by you:-

January 1, 2011 to February 14, 2011 would be 1.5 months - would be
1.535714286
January 1, 2011 to February 15, 2011 would be 1.5335714  - would be
1.5
January 1, 2011 to March 15, 2011 would be 2.483871   -  would be
2.548387097

Let me know if this helps.

--
Thanks  Regards,

DILIP KUMAR PANDEY, mvp
 MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India


On Jul 12, 1:55 pm, Richard richard.m...@gmail.com wrote:
 Hi All,
 I would appreciate a vba function that will calculation the number of months
 and fraction of a month between 2 dates.

 i.e.
 January 1, 2011 to February 14, 2011 would be 1.5 months
 January 1, 2011 to February 15, 2011 would be 1.5335714
 January 1, 2011 to March 15, 2011 would be 2.483871

 Thank you in advance

 Rich

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Re: sum of least 8 subjects

2011-05-31 Thread DILIPandey
Hi Ayoub,

It would be very helpful for the Group if you can share a sample
scenario of your problem.

Thanks,
DILIPandey

On May 31, 2:45 pm, ayoub Kakande akaka...@gmail.com wrote:
 Urgent help needed

 I have 18 subjects, 6 of them are compulsory from the other 12 a
 student offers only 2 to make a total of either 9 or ten
 subjects/papers.
 I need a formula to computer the sum of the least eight subjects done
 for each student.
 N.b if a student attempts less than 8 subjects it should not compute
 for him the total.
 These subjects are not in consecutive columns
 Thanx

 --
 Ayoub Kakande
 0772656158 / 0703516660
 Data - Mujhu
 Mulago Hosp

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Re: Arbitrage Formula

2011-05-17 Thread DILIPandey
Hi Qcan,

For the better understanding of the group, can you transfer the
details in an excel spreadsheet and send the same as an attachment.

Thanks,
DILIPandey


On May 15, 10:45 pm, qcan comeonove...@gmail.com wrote:
 Hi,

 I am looking for a couple of formulas that can be used to calculate an
 arbitrage in sports wagering.

 Example 1.

 An even split based on a 1000 dollar total wager divded between both
 sides.

 - Side 1 odds = +110
 - Side 2 odds = +150

 I know that one would have to wager $ 543.48 on side 1, in order to
 get a return $ 1141.31
 I also know that a wager of $ 456.52 on side two in order to get a
 retrun of $ 1141.30

 In other words a 14.13 % profit would be generated evenly no matter
 which side won.

 Example 2.

 The same as example 1 except I want to maximize side 1 while breaking
 even on side 2. To clarify - this would mean that all the profit would
 go to side 1 should side 1 win. If side 2 wins - I would break even.

 Using 1000 dollars again (actually 1140 dollars so that it's even),
 with the same odds as the first exmaple - I know that

 -  $ 684.00 would have to be wagered on side 1 and $ 456.00 would have
 to be wagered on side 2.

 If side 1 wins - I would get back a total of  $1436.40 (meaning a  $
 296.40 profit)
 If side 2 wins - I would get back exactly the total money wagered on
 both sides (1140 dollars) and break even.

 I have no idea how to express these two examples into a formula.
 Further, the formula(s) might be different when the favorite is
 actually below -100.

 I hope I made some sense. I will try and clarify should there be any
 questions.

 Anyone ?

 Thanks !!

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

2011-03-02 Thread DILIPandey
Congrats Ashish...!!

Best Regards,
DILIPandey

On Mar 1, 8:38 pm, Ayush jainayus...@gmail.com wrote:
 Hello Everyone,

 Ashish Koul has been selected as *'Most Helpful Member'* for the month of
 Feb 2011.
 He has posted 97 posts (13% of total posts) in February 2011 and helped many
 people through his expertise. He has been consistent contributor to this
 excel forum and achieved this recognition consistently from last three
 months.This is really amazing.

 Ashish, You are not only helping on excel queries but inspiring many people
 to support voluntarily.

 *Many Many Thanks Ashish for wonderful support to group.
 *

 *About Ashish Koul*
 Ashish resides in Delhi, India and currently working  with CSC. He is
 automation expert and his role is to automate tasks using VBA Macros and
 Advanced Excel. His favorite pass time is solving Excel Queries, Listening
 Music  Traveling.

 Regards
 Ayush Jain
 Group Manager

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel