Re: $$Excel-Macros$$ Kindly help on multiplication table macro

2012-06-03 Thread ashish koul
check the attachment see if it helps On Sun, Jun 3, 2012 at 3:57 PM, Aruna jayaram wrote: > Hi > > I want help to create a macro where in the first sheet A1 cell we specify > the number for which the multiplication table should be generated (i.e., 5 > means 5 multiplication ) and in the 2nd shee

RE: $$Excel-Macros$$ Kindly help me with my question on Excel

2012-03-05 Thread Rajan_Verma
HI, Do you want this : Format : HH:MM:SS =TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())+20) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aruna jayaram Sent: Mar/Fri/2012 12:27 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Kindly h

RE: $$Excel-Macros$$ Kindly help me with my question on Excel

2012-03-02 Thread Asa Rossoff
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Friday, March 02, 2012 2:05 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Kindly help me with my question on Excel Suppose you Enter actual date on D2 Cell

Re: $$Excel-Macros$$ Kindly help me with my question on Excel

2012-03-02 Thread Divaker Pandey
Suppose you Enter actual date on D2 Cell enter this formula where you want this result =IF(VALUE(TEXT(D2,"SS"))>30,TIME(TEXT(D2,"HH"),MOD(TEXT(D2,"[m]"),60)+1,0),TIME(TEXT(D2,"HH"),MOD(TEXT(D2,"[m]"),60),0)) On Fri, Mar 2, 2012 at 12:26 AM, Aruna jayaram wrote: > Kindly help me with my ques

Re: $$Excel-Macros$$ Kindly Help

2011-11-20 Thread Venkat CV
Hi Vijay, See attached if helps... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Thu, Nov 17, 2011 at 2:24 PM, vijayKumar wrote: > Dear Friends, > > Request you to help me on a Query of Open Office Excel. > > The Query is

Re: $$Excel-Macros$$ Kindly Help

2011-10-21 Thread dguillett1
= Mid(c, f1, f2 - f1) Next End Sub Don Guillett SalesAid Software dguille...@gmail.com From: XLS S Sent: Friday, October 21, 2011 10:21 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Kindly Help please send the example... On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 wrote:

Re: $$Excel-Macros$$ Kindly Help

2011-10-21 Thread XLS S
if this is a fix. then use countif see the attachment On Fri, Oct 21, 2011 at 8:51 PM, XLS S wrote: > please send the example... > > > On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 wrote: > >> Dear All, >> >> Need your help to extract some specific text. >> >> Exam. >> Govt I Grade College, Pasha

Re: $$Excel-Macros$$ Kindly Help

2011-10-21 Thread XLS S
please send the example... On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 wrote: > Dear All, > > Need your help to extract some specific text. > > Exam. > Govt I Grade College, Pashachapur Tq Hukkeri Dist Belgaum (2007) A/S/C/ > BBA. Enrol 139, Teacher 1, Principal-Dr S F Tangade. > > I need to ext

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-15 Thread ankur
hi ashish good work Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jan 14, 2010 at 6:52 PM, kvc praveen kumar wrote: > Thanks Vinod.. Glad that it was helpful!! > > On Thu, Jan 14, 2010 at 5:51 PM, vinod rao

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-14 Thread kvc praveen kumar
Thanks Vinod.. Glad that it was helpful!! On Thu, Jan 14, 2010 at 5:51 PM, vinod rao wrote: > Hello Praveen, > > Excellent!!! this was really great. > With Regards, > Vin > On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar > wrote: > >> Hello Vinod, >> >> PFA the soln to fill your column c us

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-14 Thread vinod rao
Hello Praveen, Excellent!!! this was really great. With Regards, Vin On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar wrote: > Hello Vinod, > > PFA the soln to fill your column c using VBA. Please let me know in case > you have any queries. > > Regards, > Praveen > > On Thu, Jan 14, 2010 at 1

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-14 Thread ashish koul
hi check it On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar wrote: > Hello Vinod, > > PFA the soln to fill your column c using VBA. Please let me know in case > you have any queries. > > Regards, > Praveen > > On Thu, Jan 14, 2010 at 1:34 PM, vinod rao wrote: > >> Hello Friends, >> Can i ge

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-14 Thread vinod rao
Hello Friends, Can i get a help for said query?. Thanks in advance. On Wed, Jan 13, 2010 at 3:13 PM, vinod rao wrote: > Hello Friends, > Can i get a help for said query?. Thanks in advance. > > On Wed, Jan 13, 2010 at 1:18 PM, vinod rao wrote: > >> Hi Ankur, >> >> This dont work because i have

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-13 Thread vinod rao
Hello Friends, Can i get a help for said query?. Thanks in advance. On Wed, Jan 13, 2010 at 1:18 PM, vinod rao wrote: > Hi Ankur, > > This dont work because i have 25 thousands of lines items one below another > and it takes long time to refresh page. > So better have vba programmed for getting

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-12 Thread vinod rao
Hi Ankur, This dont work because i have 25 thousands of lines items one below another and it takes long time to refresh page. So better have vba programmed for getting result. Plz help. Thanks for your quick reply. Regards, On Wed, Jan 13, 2010 at 11:22 AM, ankur wrote: > hi Vinod > > I try to

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-12 Thread ankur
hi Vinod I try to Slove the your Query Without The help of VBA Please Check the Attached File , male me for any other clarifcation thanks On 1/12/10, vinod rao wrote: > HI Team, > > > > I want a vba for Sum if and finding duplicate values. Plz find attached with > highlighted columns/rows. >