Re: $$Excel-Macros$$ Please help me

Thanksa ton Sourav. You kind help is highly appreciated. On Wed, Aug 3, 2016 at 7:46 PM, sourav devrani wrote: > please use this file. > i have change some little formula here you can use this file. > > Regards > Sourav Devrani > > On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani < > souravdevrani

$$Excel-Macros$$ Please help me Urgent

Hi Guys, I have a query . In this sentence.. "This iS a tEst" . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks & Regards Gaurav Devrani -- Are you =EXP(E

$$Excel-Macros$$ Please help Excel Gurus

Hi Every One, Please find the attached file, Kindly help me with the required formula In the file there is a table, with start date end date amount and corresponding months in rows i want a formula to distribute the amount month wise by referring to start date and end date Kindly help me regardin

$$Excel-Macros$$ Please help me fourmula

Dear All, please give me count fourmula in thes sheet -- Subhash Pratham Mumbai Education Initiative 9870914252 -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ Please help me

Sidhantha, I can give it a try, as i am also studying some things related to Stock Market... Let me know Harry On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know it

Re: $$Excel-Macros$$ Please help me

Can you please give me the example so that we can atleast try to help you out with query. On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know its my duty but can if any one he

Re: $$Excel-Macros$$ Please help me

Can you please give me the example so that we can atleast try to help you out with query. On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know its my duty but can if any one he

Re: $$Excel-Macros$$ Please help me

Sidhantha, Is it possible for you to provide Excel 2003 version Harry On May 3, 4:33 pm, sidhantha suchit wrote: > hi > > attach one of the sheet and thereis 1000 of such kind of sheet were i have > to do this wrk please help me. > On Mon, May 3, 2010 at 9:36 AM, Rahul Gandhi. wrote: > > > > >

Re: $$Excel-Macros$$ Please help me

can any one help me out i m waiting for your response ..otherwise i have to apply these thing in all thousand company and its a time taking On Wed, May 5, 2010 at 9:57 AM, Vikas Chouhan wrote: > Harry.. > > > 2003 format > > > On Tue, May 4, 2010 at 10:11 AM, Harpreet Singh Gujral < > harpreetgu

$$Excel-Macros$$ Please help - VBA book

I am a beginner of VBA in Excel. Can anybody tell me good VBA book which will help me to learn it from scratch? Book should be simple to study. Thanks -- -- Some important links for excel users: 1. Follow us on TWITT

Re: $$Excel-Macros$$ Please help me

Hi Sudhir, PFA... Regards, Lucky On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar wrote: > Hi > > All Dear members > > Plz help on the following point. > > I want count no. of Days between two Dates. > > Example > > 1-12-10 31-12-1031 > > thanx > > > -- > Sudhir Verm

Re: $$Excel-Macros$$ Please help me

use either of them :- =(B1-A1)+1 =DATEDIF(A1,B1,"d")+1 Regards, Manoj Kumar On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar wrote: > Hi > > All Dear members > > Plz help on the following point. > > I want count no. of Days between two Dates. > > Example > > 1-12-10 31-12-10

Re: $$Excel-Macros$$ Please help me

Dear Sudhir, Just would like to mention that the cells should be in date format, only then this function will work. Regards, Anubhav On Wed, Jan 19, 2011 at 2:59 PM, Manoj kumar wrote: > use either of them :- > > =(B1-A1)+1 > =DATEDIF(A1,B1,"d")+1 > > > Regards, > Manoj Kumar > > > On Wed, J

$$Excel-Macros$$ Please help on Excel.

Dear all, I have one attach file where I am keeping the serial pipe number but the problem is I am getting the same pipe number many times and it's hard to search whether provide pipe number are reported or not. Can u have any formula/validation i.e. when I type the reported pipe number its

$$Excel-Macros$$ please help me Urgent

Hi, Students English maths sceience Grades suresha 45 80 90 90-100 A srinivas 25 36 60 80-90 b sunyana 38 65 70 60-80c sunitha 80 90 68 36-60

Re: RE: $$Excel-Macros$$ Please help

Hello Anil, Also, If you have other text or charracters other than #n/a and just need to count the numbers only, use this, =COUNT(INDEX(MID(C2,ROW(INDEX(C:C,1):INDEX(C:C,LEN(C2))),1)+0,0)) Copy down HTH Haseeb For tips visit; http://www.excelfox.com/forum/forum.php -- -

Re: $$Excel-Macros$$ Please help me.

Hi, use below formula =find(B1,A1) Regards Amresh On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar wrote: > Dear Expert. > > i have 2 Coll A1 & B2 > > A1 Contain (Foto Fast Elec) > B1 Contain (Fast) > > I want khow B1 is in A1 or not... > > Regard > Manoj > > -- > FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Please help me.

Dear Manoj, You can also try =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found") On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar wrote: > Dear Expert. > > i have 2 Coll A1 & B2 > > A1 Contain (Foto Fast Elec) > B1 Contain (Fast) > > I want khow B1 is in A1 or not... > > Regard > Manoj > > -- >

Re: $$Excel-Macros$$ Please help me.

Thanks Noorain Ji... its working.. On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI wrote: > Dear Manoj, > > You can also try > =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found") > > On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar > wrote: > >> Dear Expert. >> >> i have 2 Coll A1 & B2 >> >> A

Re: $$Excel-Macros$$ Please help me.

Hi, Guru Ji, Its not working when i applying in table. Please guide...!! Regards, @Suman Send on the move with Galexy y. On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI" wrote: > Dear Manoj, > > You can also try > =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found") > > On Wed, Jul 11, 2012 at 1:01

Re: $$Excel-Macros$$ Please help me.

Dear Suman, It is working fine with table, Pls see the attached sheet. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jul 11, 2012 at 1:43 PM, Suman wrote: > Hi, > Guru Ji, > Its not working when i applying in table. Please guide...!! > > R

RE: $$Excel-Macros$$ Please help me.

ros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help me. Dear Suman, It is working fine with table, Pls see the attached sheet. -- Thanks & regards, Noorain Ansari www.noorainansari.com <http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.com On Wed, Jul 11, 20

Re: $$Excel-Macros$$ Please help me.

Dear Manoj, Calender in excel can be prepared by Array formula too, its purely full array for whole the months and years. =IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(C5),MONTH(C5),1

Re: $$Excel-Macros$$ Please help me.

Please tell us so that we can edit and learn it. How to make ? calender_Simple.xls file On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI wrote: > Dear Manoj, > > Please find attached simple Calender. > > You can create it simply. > > On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar > wrote: > >> De

Re: $$Excel-Macros$$ Please help me.

Dear Mangesh, To create this calendar in the range B2:H9, follow these steps: 1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge & Center. 2. Enter a date into the merged range. The day of the month isn’t important. 3. Enter the abbreviated day names in the range B3:H3.

Re: $$Excel-Macros$$ Please help me.

Thanks Deba. Its very nice even before using it I never know that Excel could do all these stuff so nicely. Thanks again Dear. On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan wrote: > Dear Mangesh, > > To create this calendar in the range B2:H9, follow these steps: > > > 1. Select B2:H2 and merge t

Re: $$Excel-Macros$$ PLEASE HELP ME

11:40 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ PLEASE HELP ME DEAR ALL MY EXCEL FRND. PLEASE SEND SOME FORMULA FOR MEDAL TALLY & CHAMPIANSHIP Chandra Singh Bohra Champawat Uttrakhand -- FORUM RULES (934+ members already BANNED for violation) 1) Use con

Re: $$Excel-Macros$$ Please help me Urgent

ong as ever you can.” - John Wesley - > > From: Gaurav Devrani >To: excel-macros@googlegroups.com >Sent: Thursday, February 26, 2015 10:12 AM >Subject: $$Excel-Macros$$ Please help me Urgent > > > >Hi Guys, > > > &

Re: $$Excel-Macros$$ Please help me Urgent

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* > - > >*From:* Gaurav Devrani > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, February 26, 2015 10:12 AM >

Re: $$Excel-Macros$$ Please help me Urgent

bruary 26, 2015 11:55 AM >Subject: Re: $$Excel-Macros$$ Please help me Urgent > > > >Thanks Paul for your quick reply. Yes I was also trying to create a macro but >Just wanted to confirm before, if that's possible in excel functions. No >worries. I really appreciate your

Re: $$Excel-Macros$$ Please help me Urgent

; > *“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* > - > > *From:* Gaurav Devrani >

Re: $$Excel-Macros$$ Please help me Urgent

Suppose you have value in cell A1 then type follo. formula in A2 & dont press enter & press F9, you will get result in curly bracket, after = sign enter CONCATENATE( & press enter to get result =TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),

Re: $$Excel-Macros$$ Please help me Urgent

Very Nice... Mr.Vabz On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: > Suppose you have value in cell A1 then type follo. formula in A2 & dont > press enter & press F9, you will get result in curly bracket, after = sign > enter CONCATENATE( & press enter to get result > > > =T

Re: $$Excel-Macros$$ Please help me Urgent

Dat's Cool Vaibhav. Thanks. On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth wrote: > > Very Nice... Mr.Vabz > > On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: > >> Suppose you have value in cell A1 then type follo. formula in A2 & dont >> press enter & press F9, you will get r

Re: $$Excel-Macros$$ please help me GRK

Dear GRKNAIDU, Please use this formula in the Bonus Qty column and copy down: =IF(MOD(J4,100)=0,(J4/100)*20,ROUNDDOWN(J4/100,0)*20) Regards, Aindril On Sat, Mar 2, 2013 at 5:33 PM, GRKRISHNA NAIDU wrote: > Dear all > > Will you please help to get the formula > > > for an example in attachment

Re: $$Excel-Macros$$ Please help Excel Gurus

Respected Harish, On what ratio do you want to distribute the amount based on the date.what are the specific criteria for distributing. Regards, VIJAYKUMAR On Tue, Jun 4, 2013 at 9:22 AM, Harish P Y wrote: > Hi Every One, > Please find the attached file, > Kindly help me with the required for

Re: $$Excel-Macros$$ Please help Excel Gurus

Formula Cell G5 =$F5/($E$5-$D$5) Fill down and fill right 2013/6/4 P.VIJAYKUMAR > Respected Harish, > > On what ratio do you want to distribute the amount based on the date.what > are the specific criteria for distributing. > > Regards, > VIJAYKUMAR > > > On Tue, Jun 4, 2013 at 9:22 AM, Haris

Re: $$Excel-Macros$$ Please help Excel Gurus

Dear Vijay , I want to distribute it on per day basis. Regards Harish With Regards *HARISH P Y* *P** **THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it is really necessary. Thanks for your support to protect our environment for the future generation* *1 ream of paper = 6%

Re: $$Excel-Macros$$ Please help Excel Gurus

> ratio just change the calculation in formula. > > Thanks > Ravinder > > --- On *Tue, 6/4/13, Bé Trần Văn * wrote: > > > From: Bé Trần Văn > Subject: Re: $$Excel-Macros$$ Please help Excel Gurus > To: excel-macros@googlegroups.com > Date: Tuesday, June 4, 2013,

$$Excel-Macros$$ Please help on FileName = Dir()

Hi Guys, Can anyone please explaint what *FileName = Dir() *is doing in below code. Public Sub RecursiveDir(ByVal CurrDir As String, Optional ByVal Level As Long) Dim Dirs() As String Dim NumDirs As Long Dim FileName As String Dim PathAndName As String Dim i As Long Dim Filesize As Double ' Mak

$$Excel-Macros$$ Please help on basic Excel

Hi Attached is a file in which in the loss column ( M Column ) the amount appears with the - ( Minus ) in the beginning. Kindly advise what can be done by which the minus will not appear. Thanks and Regards Aruna -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accur

Re: $$Excel-Macros$$ Please help me fourmula

Hi Subhash, You have forgot to attach the files. Please attach the file and explain your query as well. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, Feb 1, 2010 at 4:15 PM,

Re: $$Excel-Macros$$ Please help me fourmula

hi Subhash where is file ? On 01/02/2010, Dilip Pandey wrote: > Hi Subhash, > > You have forgot to attach the files. Please attach the file and explain > your query as well. Thanks. > > Best Regards, > -- > DILIP KUMAR PANDEY > MBA-HR,B Com(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gm

$$Excel-Macros$$ Please help to apply formula

Hi all, How to apply more than two functions in a singal formual., For ex:- i have to *concatenate* data and make it *trim *and *proper.* Appreciate your soonest response. Thank you all. -- Suhas -- -- Some imp

$$Excel-Macros$$ Please help regard this question

Dear Groups First Cell 20/12/2011 Secound Cell 12/11/2010 Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT DEAR GROUP MEMBER PLEASE HELP ME, I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL Required Results 1 YEAR ,1 MONTH ,8 DAYS LE

$$Excel-Macros$$ Please help in this Matter

Hi Experts, Please help me out the problem is if i check my status from master sheet for knowing how many projects are under process, when i select the statusfrom the drop down list, why dont all releated figures comes out. e.g. if i select under process all the under process project details sh

$$Excel-Macros$$ Please help on the formula

Hi Team, Please advise on the formula in H.O Sheet .. I am unable to get the data in B4. -- psreevi...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

$$Excel-Macros$$ Please help in P Table.

Dear All, my Question is we can use use two header in p. Table.? -- Thanks & Regards Anil Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twi

Re: $$Excel-Macros$$ Please help on Excel.

see if it helps On Tue, Mar 8, 2011 at 8:51 PM, Rabindra Thapa wrote: > Dear all, > > > > I have one attach file where I am keeping the serial pipe number but the > problem is I am getting the same pipe number many times and it’s hard to > search whether provide pipe number are reported or not

Re: $$Excel-Macros$$ Please help on Excel.

Hi use this formula in data validation =CONTAR.SI($C$2:$C$30;C1)=1 chilexcel Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 2011/3/8 Rabindra Thapa > Dear all, > > > > I have one attach file where I am keeping the serial pipe number b

Re: $$Excel-Macros$$ Please help on Excel.

sorry, use this formula in data validation =CONTAR.SI ($C$2:$C$30;C2)=1 2011/3/9 ChilExcel > Hi > > use this formula in data validation > > =CONTAR.SI($C$2:$C$30;C1)=1 > > > > chilexcel > > > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube

Re: $$Excel-Macros$$ please help me Urgent

hi sukumar, please find attached. regards, saber On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote: > Hi, > > Students English maths sceience Grades > suresha 45 80 90 90-100 A > srinivas 25 36 60 80-90 b >

Re: $$Excel-Macros$$ please help me Urgent

Hi Sukumar, I am not sure whether this is what you are looking for.. Have a look in the attached file whether it suits your requirement. --- *Sixthsense **:) Man of Extreme & Innovative Thoughts :)* On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote: > Hi, > > Students English maths sceience

$$Excel-Macros$$ Please help me(Combo box)

Hi frds Please help me. -- ***Thanks Sanjay Kumar Maurya* -- -- 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

$$Excel-Macros$$ please help with array formula

Hi experts, I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum B). In 2nd sheet i want a formula if i enter 20 its should show me the name of all the candidate who has 40 marks in 1st sheet. can it done with array forumla. please help. *Name* *Marks CT-1* SOMERSET

$$Excel-Macros$$ Please help in dividing equal numbers

Dear all, Please help in enclosed problem solution. i have tried many and even googled, but i am unable to create formula. Have exlplained xl sheet, please find. Regards, Rashi -- 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 Fa

Re: $$Excel-Macros$$ Please help on FileName = Dir()

, To all the people you can, As long as ever you can.” - John Wesley - > > From: maksood alam <786maks...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Wednesday, December 4, 2013 2:05 PM >Subject: $$Excel-Macros$$ Please help on FileName = Dir() >

Re: $$Excel-Macros$$ Please help on FileName = Dir()

------ > > *From:* maksood alam <786maks...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, December 4, 2013 2:05 PM > *Subject:* $$Excel-Macros$$ Please help on FileName = Dir() > > Hi Guys, > > Can anyone please

$$Excel-Macros$$ please help for consolidate in excel

Hi All, I have some data for date wise but I want all excel file in one sheet through macro. Example. Regards, Jitendra//9650449202 -- 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://w

RE: $$Excel-Macros$$ Please help on basic Excel

See the attached file Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aruna jayaram Sent: Apr/Sun/2012 11:09 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help on basic Excel Hi Attached is a file in which in the loss

Re: $$Excel-Macros$$ Please help on basic Excel

ooglegroups.com] *On Behalf Of *Aruna jayaram > *Sent:* Apr/Sun/2012 11:09 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Please help on basic Excel > > ** ** > > Hi > > Attached is a file in which in the loss column ( M Column ) the amount >

RE: $$Excel-Macros$$ Please help on basic Excel

See the attached sheet Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aruna jayaram Sent: Apr/Sun/2012 11:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help on basic Excel Hi Rajan, In the M column it should

Re: $$Excel-Macros$$ Please help on basic Excel

jayaram > *Sent:* Apr/Sun/2012 11:21 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Please help on basic Excel > > ** ** > > Hi Rajan, > > In the M column it should appear as 1600 and not -1600. > > Thanks > > Aruna > > On S

$$Excel-Macros$$ Please help on the data validation

Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils

Re: $$Excel-Macros$$ Please help to apply formula

"&B2&" "&C2)) or: =PROPER(TRIM(A2)&" "&TRIM(B2)&" "&TRIM(C2)) Now, if you only want to apply "proper" to the first word, then it's just a matter of where you place the () =PROPER(TRIM(A2)) & " " & TRIM(

Re: $$Excel-Macros$$ Please help to apply formula

C2)) > > Now, if you only want to apply "proper" to the first word, then > it's just a matter of where you place the () > =PROPER(TRIM(A2)) & " " & TRIM(B2) & " " & TRIM(C2) > > > Paul > > -- > *Fr

Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA

I Think in particular this scenerio we have one more function of "Concatenate" or "&". that also helps us to do the same, at the other hand this formula is also very suitable for so many conditions.. Thanks again sir. On Jul 23, 6:33 pm, Dilip Pandey wrote: > Hi Hari, > > I have achieved the

Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA

Thanks Rahul, No doubt, "concatenate" and "&" will do the task but for that we need to have a column on both d locations n we also need to check if this is feasible. But anyways both the ways are ok n there are other ways as well :) thx, DILIPandey On 7/24/10, Rahul Gandhi. wrote: > I Think in

Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA

Dear Dilipji, Thank you very much, It is working, but one problem It showing error when nothing is entered, I have tried to insert isserror formula, but not able insert it. if possible please revise my file. again thank you very much for your kind help On Sat, Jul 24, 2010 at 9:24 AM, Dilip Pande

Re: $$Excel-Macros$$ Please help regard this question

Hey Jai, Supposing the dates are in cells A1 and A2, you can use the following in cell A3: =DATEDIF(A2,A1,"y")&IF(DATEDIF(A2,A1,"y")>1," years ,"," year ,")&DATEDIF(A2,A1,"ym")&IF(DATEDIF(A2,A1,"ym")>1," months ,"," month ,")&DATEDIF(A2,A1,"md")&IF(DATEDIF(A2,A1,"md")>1," days left."," day left."

Re: $$Excel-Macros$$ Please help regard this question

Dear Jai... Please see attachment.. =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, "&TEXT((D5-D6),"dd")&" DAYS" Thanks, Noorain On Thu, Nov 11, 2010 at 9:47 PM, Jai wrote: > Dear Groups > > First Cell > > 20/12/2011 > > Secound Cell > > 12/11/2010 > > R

Re: $$Excel-Macros$$ Please help regard this question

Very simple! Good On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI wrote: > Dear Jai... > > Please see attachment.. > > =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, > "&TEXT((D5-D6),"dd")&" DAYS" > Thanks, > Noorain > On Thu, Nov 11, 2010 at 9:47 PM, Jai wrote: > >> Dear Groups >

Re: $$Excel-Macros$$ Please help regard this question

THANKS A LOST EXPERTS On Fri, Nov 12, 2010 at 3:59 PM, SAJID MANSOOR wrote: > Very simple! Good > > > On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI > wrote: > >> Dear Jai... >> >> Please see attachment.. >> >> =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, >> "&TEXT((D5-D6),"dd")&

Re: $$Excel-Macros$$ Please help regard this question

=IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check the date(s)") On Fri, Nov 12, 2010 at 4:19 PM, Jai wrote: > THANKS A LO

Re: $$Excel-Macros$$ Please help regard this question

=IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check the date(s)") this will supress if year/month/day = 0 in the expansio

Re: $$Excel-Macros$$ Please help regard this question

Excellent one,,,its working Is it possbile , the result should be 0 , if i give same dates for both. On Fri, Nov 12, 2010 at 9:53 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > =IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & > IF(MONTH(A1) - MO

Re: $$Excel-Macros$$ Please help regard this question

=IF(A1 >= A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)& " Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & DAY(A1) - DAY(A2) & " Day(s) Left", "Please check the date(s)") On Mon, Nov 15, 2010 at 11:14 AM, Manjunath C wrote: > Excellent one,,,its working,,

Re: $$Excel-Macros$$ Please help in this Matter

Check if this works for you. Regards, Manoj Kumar On Tue, Dec 21, 2010 at 1:08 PM, Rohan Young wrote: > Hi Experts, > > Please help me out the problem is if i check my status from master sheet > for knowing how many projects are under process, when i select the statusfrom > the drop down lis

Re: $$Excel-Macros$$ Please help on the formula

Dear Poojari, Please see attachments.. Thanks, Noorain Ansari On Fri, Dec 24, 2010 at 12:24 AM, poojari sreevijay wrote: > Hi Team, > > Please advise on the formula in H.O Sheet .. > > I am unable to get the data in B4. > > > > -- > psreevi...@gmail.com > > -- > > --

Re: $$Excel-Macros$$ Please help on the formula

Hi Noorain, Here we use only vlookup i am worng or right, On Fri, Dec 24, 2010 at 5:00 PM, NOORAIN ANSARI wrote: > Dear Poojari, > > Please see attachments.. > > Thanks, > Noorain Ansari > > On Fri, Dec 24, 2010 at 12:24 AM, poojari sreevijay < > psreevi...@gmail.com> wrote: > >> Hi Team, >

Re: $$Excel-Macros$$ Please help on the formula

> > Hi Noorian/ Team, > I got succeded in retrieving data by using dr as branch ( used indirect function only )but failed when trying to give sr as branch . could any one can fix the issue.. only by using indirect function only... it should retrieve data based on branch . Please find the atta

Re: $$Excel-Macros$$ Please help on the formula

Hi Noorian/ Team, I got succeded in making up the formula...:) please find the attached excel sheet Thanks , psreevi...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips t

Re: $$Excel-Macros$$ -- Please Help Code Doesn't Work

Hi Dearests, Please Help Code Doesn't Work On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar wrote: > *thanks Daniel Ji for the reply... here what I need and what the code > doesn't do.* > * > * > *This code runs as long as the Sheets("1").Cells(2, ColNumber) = > Sheets("Name").Cells(RowCounter, 1)

Re: $$Excel-Macros$$ -- Please Help Code Doesn't Work

Plz share your code On Feb 21, 2:06 pm, rakesh kumar wrote: > Hi Dearests, > > Please Help Code Doesn't Work > > On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar > wrote: > > > > > > > > > > > *thanks Daniel Ji for the reply... here what I need and what the code > > doesn't do.* > > * > > * > > *Th

Re: $$Excel-Macros$$ Please help me(Combo box)

see if it helps On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote: > Hi frds > > Please help me. > > -- > ***Thanks > Sanjay Kumar Maurya* > > -- > > -- > Some important links for excel users: > 1. Follow us on TW

Re: $$Excel-Macros$$ Please help me(Combo box)

hi Sanjay, just see whether this helps...i created a pivot according to my understanding of the quwestion...just get back to me if it is not enough On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote: > Hi frds > > Please help me. > > -- > ***Thanks > Sanjay Kumar Maurya* > > -- > > ---

Re: $$Excel-Macros$$ Please help me(Combo box)

Hi, Please find the attached sheet with solution. Thanks Rupesh Kr. On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote: > Hi frds > > Please help me. > > -- > ***Thanks > Sanjay Kumar Maurya* > > -- > > -- > Some

Re: $$Excel-Macros$$ Please help me(Combo box)

Dear Frd Thanks for your reply and solution but I have more data so pivot table is not possible for it. if u have any easy format please tell me. Thanks Sanjay Kumar Maurya On 8/3/11, sreejith k.s wrote: > hi Sanjay, > > just see whether this helps...i created a pivot according to my > understa

Re: $$Excel-Macros$$ Please help me(Combo box)

Hey Sanjay Try to use Indirect Functionplease find the attachment On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya wrote: > Dear Frd > > Thanks for your reply and solution but I have more data so pivot table > is not possible for it. if u have any easy format please tell me. > > T

Re: $$Excel-Macros$$ Please help me(Combo box)

Dear Friends Thank your very much for your great reply. may u define this formula. I can not find any source for *Groups* . I am using that other place that function is not working. Thanks again Sanjay Kumar Maurya On Thu, Aug 4, 2011 at 5:18 AM, XLS S wrote: > Hey Sanjay > > Try to use In

Re: $$Excel-Macros$$ please help with array formula

can you send us the attachment On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote: > Hi experts, > > I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum > B). In 2nd sheet i want a formula if i enter 20 its should show me the name > of all the ca

Re: $$Excel-Macros$$ please help with array formula

cannot send any attchment due to system restrictions. On Tue, Aug 28, 2012 at 8:20 PM, ashish koul wrote: > can you send us the attachment > > > On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote: > >> Hi experts, >> >> I have data in once sheet in two colums like *NAME*(c

Re: $$Excel-Macros$$ please help with array formula

Dear Maksood, Please try it.. =IFERROR(INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),""),ROW(B1))-4),"--") On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote: > Hi experts, > > I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum > B

Re: $$Excel-Macros$$ please help with array formula

See attachment for more clarity On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote: > Hi experts, > > I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum > B). In 2nd sheet i want a formula if i enter 20 its should show me the name > of all the c

Re: $$Excel-Macros$$ please help with array formula

Thanks Noorain bhai.. its solved my qurey.. On Tue, Aug 28, 2012 at 8:35 PM, NOORAIN ANSARI wrote: > See attachment for more clarity > > On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote: > >> Hi experts, >> >> I have data in once sheet in two colums like *NAME*(colum A)

Re: $$Excel-Macros$$ please help with array formula

Hi Noorin what is logic of last number 4 in formula if I change it nothing change in output ={INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),""),ROW(B1))-4)} I used excel 2003 so I changed formula like this Pl tell me logic of number 4 in last On Tue, Aug 28, 2012 at 10:16 PM, maksood

Re: $$Excel-Macros$$ please help with array formula

Dear Amar, We are using No. 4 for row no., If you go through attachment, table start from row no. 5, row no.4 is heading so, we deduct above all row Number including header. so we are using 4 because we are deduction 4 row no. Hope my explanation will help you. On Thu, Aug 30, 2012 at 5:16 P

Re: $$Excel-Macros$$ Please help in dividing equal numbers

please explain your query On Fri, May 29, 2015 at 10:04 AM, Rashi Singh wrote: > Dear all, > > > Please help in enclosed problem solution. i have tried many and even > googled, but i am unable to create formula. Have exlplained xl sheet, > please find. > > > Regards, > Rashi > > -- > Are you =E

Re: $$Excel-Macros$$ Please help in dividing equal numbers

What's your criteria for "how many 100 or 150 you can use". On Fri, May 29, 2015 at 10:04 AM, Rashi Singh wrote: > Dear all, > > > Please help in enclosed problem solution. i have tried many and even > googled, but i am unable to create formula. Have exlplained xl sheet, > please find. > > > Reg

Re: $$Excel-Macros$$ Please help in dividing equal numbers

Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my drawer box, i have bundle of Rs. 100 and Rs. 150 (Assume). Now How many Rs 100 have to take out from my drawer and Rs. 150 from my drawer. to equivalent Rs. 2250. Hope i could able to explain my query ! Thanks in advance

<    1   2   3   4   >