Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-02 Thread Rakesh Kumar Sharma
Hi Noorain, Great job Dear, Congratulations !!! On Mon, Sep 3, 2012 at 10:40 AM, Seraj Alam wrote: > congrats noorain bhai. > > > On Mon, Sep 3, 2012 at 10:35 AM, अनिल नारायण गवली > wrote: > >> Dear noorian, >> >> Congrats Dear..:) >> >> Thanks & Regards, >> Gawli Anil >>

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-02 Thread Kuldeep Singh
Hi Muralidhar, Try this. =IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0")) Regards, Kuldeep Singh On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E wrote: > > Dear all, > > Good morning to every body > > Iam using Office 2010, I need in result column(F) how many times the > vendor na

Re: $$Excel-Macros$$ Number into hr:mm;ss

2012-09-02 Thread Chandra Shekar
Hello, Thanks Paul :) Regards, Chandru On Fri, Aug 31, 2012 at 4:58 PM, Paul Schreiner wrote: > We don't really have enough information. > > hh:mm:ss is actually a TIME OF DAY display format. > > As you probably already know, Excel stores date and time as a number. > the date is the number o

$$Excel-Macros$$ Count when po is greater than zero

2012-09-02 Thread Muralidhar E
Dear all, Good morning to every body Iam using Office 2010, I need in result column(F) how many times the vendor name(column B) is repeat, it is countable when the po(column D) is greater than zero, if po is blank or zero it will not be counted(calculated). Plz, find the attached file. Thanks in

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-02 Thread Seraj Alam
congrats noorain bhai. On Mon, Sep 3, 2012 at 10:35 AM, अनिल नारायण गवली wrote: > Dear noorian, > > Congrats Dear..:) > > Thanks & Regards, > Gawli Anil > > On Mon, Sep 3, 2012 at 10:20 AM, Kuldeep Singh wrote: > >> >> Congrats Noorain Sir. >> >> Regards, >> Kuldeep Singh >> B

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-02 Thread अनिल नारायण गवली
Dear noorian, Congrats Dear..:) Thanks & Regards, Gawli Anil On Mon, Sep 3, 2012 at 10:20 AM, Kuldeep Singh wrote: > > Congrats Noorain Sir. > > Regards, > Kuldeep Singh > Back Office Executive (MIS) > Info Edge India Limited (naukri.com) > Phone.: +91-120-4763789, Extn.: 789 >

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-02 Thread Kuldeep Singh
Congrats Noorain Sir. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Sun, Sep 2,

Re: $$Excel-Macros$$ Re: Required Revenue started from Date..

2012-09-02 Thread Kuldeep Singh
Hi Vabs, You can use this formula & Press Ctrl+Shift+Enter. =INDEX($1:$1,0,SMALL(IF(C2:R2>0,COLUMN($C$1:$R$1),""),1)) Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you

Re: $$Excel-Macros$$ Gathering info from MySQL Bugzilla DB into Excel using VBA (is this even possible?)

2012-09-02 Thread Marcus Polk
David, JOIN, duh! That "duh" is for me. ;-) Thank you for taking the time, it actually makes sense to me, explained out like that. I will take a look at the Pivot Table link. Thank you again, very much. Marcus On Sep 2, 2012, at 3:00 AM, David Grugeon wrote: > Ok Marcus. It is complicated

$$Excel-Macros$$ Re: Excel CD for Advance Excel Learning - data caputure in specific excel format, analysis etc.

2012-09-02 Thread Lalit Mohan Pandey
Why don't you use youtube for learning there are so many videos already uploaded. Regards, Lalit Mohan On Sunday, 2 September 2012 21:20:22 UTC+5:30, negidash wrote: > > Dear Group Members, > > Pl. held me out to get an Excel CD for advance Excel Learnng with demo > & easy understanding. Marke

$$Excel-Macros$$ Excel CD for Advance Excel Learning - data caputure in specific excel format, analysis etc.

2012-09-02 Thread bsn negi
Dear Group Members, Pl. held me out to get an Excel CD for advance Excel Learnng with demo & easy understanding. Market is floded with such CDs, however it is really difficult to find the good one. Primarily foucssing on to use huge raw & unorganised data downloaded in different formats from SAP

RE: $$Excel-Macros$$ EXCELLENT MIND READING

2012-09-02 Thread Rajan_Verma
Simply that colored number found in the last selected box. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kanwaljit Singh Sent: 02 September 2012 7:27 To: excel-macros@googlegroups.com Subject: Re:

Re: $$Excel-Macros$$ Returning a cumulative value based on the contents of a given cell

2012-09-02 Thread dguillett1
=SUM('2012 Actual'!C3:OFFSET('2012 Actual'!C3,0,MATCH($H$3,'2012 Actual'!$1:$1,0)-3)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Steve Weaver Sent: Wednesday, August 29, 2012 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Returning

Re: $$Excel-Macros$$ EXCELLENT MIND READING

2012-09-02 Thread Kanwaljit Singh
Seems a simple combination of two steps Pink : 1-6-14-21-22 Red : 2-5-13-15-20 Green : 9-12-16-23-25 Blue : 3-4-10-17-18 Black : 7-8-11-19-24 1st Step : We Choose Color 2nd Step : Just a hoax, useless step to create unnecessary suspence 3rd Step : Choose a Box. We selected a value earlier out

Re: $$Excel-Macros$$ EXCELLENT MIND READING

2012-09-02 Thread dguillett1
a public variable, perhaps. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kanwaljit Singh Sent: Sunday, September 02, 2012 1:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ EXCELLENT MIND READING Hi, Someone Noted how it works ? On

$$Excel-Macros$$ Re: Required Revenue started from Date..

2012-09-02 Thread Vabs
hii I tried doing without arrat formulae or vba.. Hope it doesnt throw error. Rgds//Vabs On Friday, August 31, 2012 6:05:54 PM UTC+5:30, Kuldeep Singh wrote: > > Hi Experts, > > I want to required Revenue started from Date. > > > Regards, > Kuldeep Singh > Phone.: +91-120-4763789, Extn.:

Re: $$Excel-Macros$$ Ratio Calculation

2012-09-02 Thread Sundarvelan N
Dear All, I used the below formula. *MALE* *FEMALE* *RATIO* 967 696 =$D4/(GCD($D4,$E4))&":"&$E4/(GCD($D4,$E4)) But i got this answer is this the correct answer 967:696 Thanks N.Sundarvelan 9600160150 On Sun, Sep 2, 2012 at 3:35 PM, ashish koul wrote: > http://spreadsheetpage.com

Re: $$Excel-Macros$$ Outlook to excel VBA

2012-09-02 Thread Vabs
Dear Amar, Post your qery in new thread. Rgds Vabs On Friday, August 31, 2012 4:30:22 PM UTC+5:30, amar takale wrote: > Dear Noorin > All VBA Experts, > This is very Challenging work for me also you & Our other Excel users in > group.I required VBA code when our research report published on

Re: $$Excel-Macros$$ Ratio Calculation

2012-09-02 Thread ashish koul
http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/ http://www.dailydoseofexcel.com/archives/2004/04/29/formatting-ratios/ On Sun, Sep 2, 2012 at 3:33 PM, Sundarvelan N wrote: > Dear Friends, > > Help me in calculating the ratio. > > *MALE* *FEMALE* *RATIO* 967 696

$$Excel-Macros$$ Ratio Calculation

2012-09-02 Thread Sundarvelan N
Dear Friends, Help me in calculating the ratio. *MALE* *FEMALE* *RATIO* 967 6961376 9901602 12391545 1155 1377 10571220 9141003 708 Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (

Re: $$Excel-Macros$$ Gathering info from MySQL Bugzilla DB into Excel using VBA (is this even possible?)

2012-09-02 Thread David Grugeon
Ok Marcus. It is complicated getting these things to wortogether if you have limited knowledge of any of them I pick No 5.to make a start on answering. Let assume that we are talking about a dog club database. You might have a list of dogs like this: Table: Dogs ID - Name - Breed - Sex 1 Fred

$$Excel-Macros$$ Learning codes used in ASAP Utilities

2012-09-02 Thread Amit Desai (MERU)
Dear Friends, I have installed ASAP Utilities from net. In case if I want to understand the VBA macro used in its feature what & how should I do? I wants to make few changes in preset feature, like spreading a sheet's data to many sheets based on certain criteria. Also do we have any such compr

RE: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-02 Thread Mohammed Muneer
Dear Noor, Congratulations friend, this is a really a landmark on whole excel platform. U r doing a tremendously great job, by bringing untiring efforts from u r side to help all the group members - when they are at a stage of feeling helpless to solve the problems arising in excel formula,