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.

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.

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

Thanks Noorain On 7/4/12, NOORAIN ANSARI wrote: > Dear Mangesh, > > Please use it.. > > =TEXT(B2-A2,"[H]:mm:ss") > > On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay > wrote: > >> I need diff in between these two dates in Hours >> Start Date End Date >> 4/1/2012 5:01 4/3/2012 6:15 >> Whateve

Re: $$Excel-Macros$$ PLease Help

Dear Mangesh, Please use it.. =TEXT(B2-A2,"[H]:mm:ss") On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay wrote: > I need diff in between these two dates in Hours > Start Date End Date > 4/1/2012 5:01 4/3/2012 6:15 > Whatever the diff in between these two dats in terms of hours (hh:mm) > > P

RE: $$Excel-Macros$$ Please help : Use of Criteria & Rule1-2

Hi Suyog, I have used the name ranges in the sheet. If function starts with logical reason, to view the name ranges press CTRL+F3 So I have defined each logic a diffrent name like criteria 2 ,criteria3 like that Hope I have cleared you doubt, if you still have any queries please feel free to co

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

Smitha, Using developer tab Insert Combo box from Activex controls. Then right click on the combo box, select properties. Now write the source opposit to "Listfillrange". It works Thanks, Naresh V On Tue, May 29, 2012 at 10:04 AM, Bé Trần Văn wrote: > > > 2012/5/29 Mangesh Dayne

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

Check mails of this group. It has been already answered some days before. ManGesh On Tue, May 29, 2012 at 1:36 PM, Smitha S R wrote: > 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 >

Re: $$Excel-Macros$$ Please help

Dear Rajendra, Waheed solution is nice, you can also use...vlookup with approximate match =VLOOKUP(B2,$G$3:$I$5,3,*1*) On Tue, May 8, 2012 at 3:03 PM, Shaik Waheed wrote: > Hi, > PFA > > On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender wrote: > >> Dear Team >> >> Please go through the attached e

Re: $$Excel-Macros$$ Please help

Hi, PFA On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender wrote: > Dear Team > > Please go through the attached excel sheet and help me in the calculation > of* discount* (Column - D) based on the *discount criteria *(Column G:I) > > Regards > Rajender Soni > > -- > FORUM RULES (986+ members already

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

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

Hi Rajan, In the M column it should appear as 1600 and not -1600. Thanks Aruna On Sun, Apr 8, 2012 at 11:12 PM, Rajan_Verma wrote: > See the attached file > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *A

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

Dear Anil, Please see attached sheet, Maries solution is good but You can do it without using helping column On Fri, Feb 24, 2012 at 3:41 PM, anil panchal wrote: > Hi, > > Please help me how to show percentage in bar chart like value > > > > > -- > > > > Thanks & Regards > Anil Kumar > > --

Re: $$Excel-Macros$$ please help

Hi, Find the attached file. On Fri, Feb 24, 2012 at 2:11 PM, anil panchal wrote: > Hi, > > Please help me how to show percentage in bar chart like value > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

t; See attached that eliminates the need for Hyperlinks > Look in the ThisWorkbook module and the sheet module > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Avinash Patil > Sent: Monday, January 30, 2012 9:09 AM > To: excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

yes dilip, i guess u r right. i want the results as per the results highlighted in red border. and hyperlink format in red font. regards, Avinash On Sun, Jan 29, 2012 at 12:31 PM, Dilip Pandey wrote: > Hi Avinash, > > Not entirely getting your point. > Please confirm if you need following <

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

Hi Avinash, Not entirely getting your point. Please confirm if you need following < which I can understand per your post> :) 1) Following results as per Date in first field < this you have already attached> DateTotal Product Actual PriceTotal Number Of ProductsGrand Total She

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

Hi.. Please attach sample file with output what you want by Formula.. Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Satvik Sent: Jan/Mon/2012 09:33 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help..

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

Hi Satvik, use the below formula . =(today()-A1)/30.5 On Mon, Jan 2, 2012 at 9:32 PM, Satvik wrote: > Dear Excel Members, > > Please help me how to calculate the Tenurity of a agent. > > Regards, > Satvik > Sent from BlackBerry® on Airtel > > -- > FORUM RULES (934+ members already BANNED for v

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

You need to tell us what you want and why This cell _on this sheet___in this file_ needs to come from This cell _on this sheet___in this file_ and WHY Don Guillett SalesAid Software dguille...@gmail.com From: Chandra Singh Bora Sent: Friday, December 09, 2011

Re: $$Excel-Macros$$ Please help to convert tables from PDF to Excel.

Thnaks yaar, but i am new in Macro world so dont know even ABC of it, can u plz send the final file. I will be very thankful to you. its very urgent for me plz On Mon, Oct 24, 2011 at 8:59 PM, NOORAIN ANSARI wrote: > Dear Pravesh, > > Please try through below code.. > > Sub ImportPDFFileData() >

Re: $$Excel-Macros$$ Please help to convert tables from PDF to Excel.

Dear Pravesh, Please try through below code.. Sub ImportPDFFileData() 'Author: Steve Lipsman 'Purpose: Import PDF File Data Into Excel Worksheet 'Other Requirement(s): 'Acrobat' Checked in VBA Tools-References 'Reference Renames Itself 'Adobe Acrobat 9.0 Object Library' After Reference Is Saved

Re: $$Excel-Macros$$ Please help

I sent the original answer. I should have told you to save your file as an .xlsM (macro enabled file) From: Sundarvelan N Sent: Monday, August 22, 2011 6:59 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help Hi Team, Still i'm notable to find the solutio

Re: $$Excel-Macros$$ Please help

ginal Message----- From: XLS S >> Sent: Wednesday, August 10, 2011 1:19 PM >> >> To: excel-macros@googlegroups.com >> Subject: Re: $$Excel-Macros$$ Please help >> >> >> Hey Sundaryelan, >> >> Please find the attachment >> >> . >

Re: $$Excel-Macros$$ Please help

S Sent: Wednesday, August 10, 2011 1:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help Hey Sundaryelan, Please find the attachment . On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N wrote: Hi Friends, Please refer the attached image. Please he

Re: $$Excel-Macros$$ Please help

Hey Sundaryelan, Please find the attachment . On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N wrote: > Hi Friends, > > Please refer the attached image. Please help on this scenatio. > Thanks > N.Sundarvelan > 9600160150 > > -- > --

Re: $$Excel-Macros$$ Please help

Attach a file From: Sundarvelan N Sent: Tuesday, August 09, 2011 11:52 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help Hi Friends, Please refer the attached image. Please help on this scenatio. Thanks N.Sundarvelan 9600160150 -- --

RE: $$Excel-Macros$$ Please help

Please Attach Your excel file.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sundarvelan N Sent: Wednesday, August 10, 2011 10:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help Hi Friends, Please refer the attached

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 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 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)

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)

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)

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: 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

Try this =LEN(SUBSTITUTE(C3,"#n/a","")) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil panchal Sent: Tuesday, July 26, 2011 6:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help Dear Experts, Please find the

Re: $$Excel-Macros$$ Please help

=LEN(SUBSTITUTE(a1,"#n/a","")) On Tue, Jul 26, 2011 at 6:05 PM, anil panchal wrote: > Dear Experts, > > Please find the attached file . my questions is i have alphabets & Numbers > both in one cell now i want only count numbers like 123#n/aabcd345677 now i > want 9 > > > > Thanks & Regards > Ani

RE: RE: $$Excel-Macros$$ Please help to make my project good.

Thank you! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of GoldenLance Sent: Monday, June 13, 2011 7:14 AM To: excel-macros@googlegroups.com Subject: Re: RE: $$Excel-Macros$$ Please help to make my project good. =SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999

Re: RE: $$Excel-Macros$$ Please help to make my project good.

=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2, and then copy across to other cells -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://t

RE: $$Excel-Macros$$ Please help to make my project good.

@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of §»VIPER«§ Sent: Wednesday, May 11, 2011 10:36 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help to make my project good. pfa On Thu, May 12, 2011 at 12:31 AM, Mahesh parab wrote: Hi check whether

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

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 to make my project good.

y 12, 2011 8:36 AM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Please help to make my project good. > > > > pfa > > On Thu, May 12, 2011 at 12:31 AM, Mahesh parab > wrote: > > Hi > > > > check whether attach file helps. &

Re: $$Excel-Macros$$ Please help to make my project good.

pfa On Thu, May 12, 2011 at 12:31 AM, Mahesh parab wrote: > Hi > > check whether attach file helps. > > On Wed, May 11, 2011 at 3:51 PM, karan 1237 wrote: > >> Respected Sirs/Mam, >> >> I need your help making my project good. Please find attachment. I will >> be very obliged if someone can

RE: $$Excel-Macros$$ Please help to make my project good.

Hi Karan, Use this formula, =OFFSET(IF($A$2="Administration, Business and Office Work",'Administration, Business and Of'!A1,IF($A$2="Building and Construction",'Building and Construction'!B1,'Catering and Hospitality'!A1)),'Building and Construction'!$I$2,0) And copy in all your gray cells R

Re: $$Excel-Macros$$ Please help to make my project good.

Hi check whether attach file helps. On Wed, May 11, 2011 at 3:51 PM, karan 1237 wrote: > Respected Sirs/Mam, > > I need your help making my project good. Please find attachment. I will be > very obliged if someone can help me as earlier as possible. > > -- > Basically I have to do that

Re: $$Excel-Macros$$ Please help to make my project good.

please check the attachment if it helps.. best regards, STDEV(i) note: we need dynamic* Max Value* of ScrollBar so we use Scroolbar from ActiveX Control, instead of from FORM. A little macro wil work each time you change the "career" On Wed, May 11, 2011 at 5:21 PM, karan 1237 wrote: > Resp

Re: $$Excel-Macros$$ Please Help

*Thank you so much. I am very grateful to you. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı On Sun, May 8, 2011 at 6:59 AM, STDEV(i) wrote: > > try to use this UDF (user defined function) > Function UniqueList(Dat As Range) >' List of UnSorted Unique Values ' >'

Re: $$Excel-Macros$$ Please Help

try to use this UDF (user defined function) Function UniqueList(Dat As Range) ' List of UnSorted Unique Values ' '-' Dim Cel As Range, vArr(), n As Long, Tx As String Tx = ", " For Each Cel In Dat If InStr(1, Tx, ", " & Cel & ", ") = 0 T

Re: $$Excel-Macros$$ Please Help

try the attachment On Sat, May 7, 2011 at 2:20 PM, karan 1237 wrote: > * > LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT > SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT > *Hi Experts, > > I want like this. Please help. > > Thnx in Adva

Re: $$Excel-Macros$$ Please Help

try this =B3/(RIGHT(C3,LEN(C3)-FIND("~",SUBSTITUTE(C3," ","~",LEN(C3)-LEN(SUBSTITUTE(C3," ","")*1) On Wed, Apr 27, 2011 at 7:32 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: > Dear Gurus, > > Please advise any formula to calculate the Book Value in given attachment. > > Tha

Re: $$Excel-Macros$$ Please Help.................

Thanks a lot of Setiywati(STDEV). and Ashish... it's working fine On Wed, Apr 27, 2011 at 3:50 PM, STDEV(i) wrote: > by hiding application objec at time of userform initialized or activated > Application.visible = False > > and don' forget to unhide the aplication (excel)

Re: $$Excel-Macros$$ Please Help.................

by hiding application objec at time of userform initialized or activated Application.visible = False and don' forget to unhide the aplication (excel) at time of userform deactivated or unloaded Application.visible = False se attachaed workbook On Wed, Apr 27, 2011 at 1:38 PM, NOORAIN ANSARI wr

Re: $$Excel-Macros$$ Please Help

Hi Sudhir, In the excel sheet which you have send me, for the party name "b" on 14th March you have mentioned 1700 as the pending amount. My question is How do you come to arrive at this figure? 1700 Regards Umesh On Mon, Mar 21, 2011 at 9:13 PM, sudhir kumar wrote: > Hi, > > Thanx and It'

Re: $$Excel-Macros$$ Please Help

Hi, Thanx and It's feel good to see done with macro. And how to copy it to my main workbook. Meaning of Pending Amount : It mean's payment which was not collected yet. Regards Sudhir On 21/03/2011, Umesh Dev wrote: > Hi Sudhir, > > Check if its working. I have done it for only "Running Balance

Re: $$Excel-Macros$$ Please Help

Hi Sudhir, Check if its working. I have done it for only "Running Balance". I am not clear with the " Pending Amount" the numbers are contradicting in the format which you had attached. if you can let me know how it is done. I can rework the code. Regards Umesh Dev On Sat, Mar 19, 2011 at 12:15

Re: $$Excel-Macros$$ Please Help

Hi Running balance mean's outstanding of Parties on left side display date. Pending amount mean's pending bills upto outstanding. thanx On 19 March 2011 05:27, Umesh Dev wrote: > Hi Sudhir, > > It is still not clear, how to get the Running Bal and the Pending Amount. > > > Regards > Umesh >

Re: $$Excel-Macros$$ Please Help

Hi Sudhir, It is still not clear, how to get the Running Bal and the Pending Amount. Regards Umesh On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar wrote: > Dear Experts, > > > Please read my attachment and solve it. > > thanx > > > > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

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 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.

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 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 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

arre you using excel 2003 or 2007 if you are using 2007 simply apply filter by color On Fri, Feb 18, 2011 at 3:49 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: > Dear All, > > I have cash entries in one workbook and I want total of some specific > entries in different workbook

RE: $$Excel-Macros$$ Please help

Thankyou verymuch paul -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bhushan Sent: Tuesday, February 01, 2011 5:53 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Please help Dear All, We use $ sign in formula to

Re: $$Excel-Macros$$ Please help

ces. > > the $A is the ABSOLUTE column A. > so when you copy it, it remains "A" > but for "B", well, the current cell is column "B", > so when you copy it to column C, the formula changes > to "C".. > > does that help? > > Paul > > __

Re: $$Excel-Macros$$ Please help

Hi sudhir, Click *Conditional formatting* tab ->Select *New Rule* -> Select *Format only cells that contain* -> click on *Format* and choose the color. Regards Umesh Dev On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar wrote: > Dear Experts > > > please hep me for a formula which worked on co

Re: $$Excel-Macros$$ Please help

Result attached Aamir Shahzad On Sat, Jan 29, 2011 at 9:13 PM, sudhir kumar wrote: > Dear Experts > > > Please help see my attachement and help me. > > > thanking you > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > > P think Befo

Re: $$Excel-Macros$$ Please help

check the attachment On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar wrote: > Dear Experts > > > please hep me for a formula which worked on color. > > please see attachment. > > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > 9

Re: $$Excel-Macros$$ Please help

case wen u write =Sum(A2:A20 immediately press F4 the formula will convert to =SUM($A$2:$A$20 and then continue let me know if it works. From: D M Sukumar To: excel-macros@googlegroups.com Sent: Sat, 29 January, 2011 11:03:37 PM Subject: RE: $$Excel-Macros

Re: $$Excel-Macros$$ Please help

", well, the current cell is column "B", so when you copy it to column C, the formula changes to "C".. does that help? Paul ____________ From: D M Sukumar To: excel-macros@googlegroups.com Sent: Sat, January 29, 2011 12:33:37 PM Subject: RE:

RE: $$Excel-Macros$$ Please help

Hai groups, Can you tell me what is the use of $ sign excel And can you give some examples please;;; Thank you From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ Please help

use sumif check the attachment On Sat, Jan 29, 2011 at 9:43 PM, sudhir kumar wrote: > Dear Experts > > > Please help see my attachement and help me. > > > thanking you > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > > P think Bef

Re: $$Excel-Macros$$ Please help to get result through Formule

Hi Find the attachment. Thanks & Regards Thamu On Thu, Jan 27, 2011 at 3:04 PM, Born to Win wrote: > Hello Expert, > > In Attached Sheet i am making a tracker For Attrition In first summary > sheet i have to show Band with Colour corresponding to his Last Dated > Status. > > Please help me to

Re: $$Excel-Macros$$ Please help to get result through Formule

Hi CS, If you want to color the band. You can Conditional Formatting to get the result. Regards Umesh On Thu, Jan 27, 2011 at 3:04 PM, Born to Win wrote: > Hello Expert, > > In Attached Sheet i am making a tracker For Attrition In first summary > sheet i have to show Band with Colour correspon

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

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

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 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 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 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

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 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 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 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) , ", "") & 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

=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

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

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

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

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

ble to devote that much > time. :( > > Best Regards, > DILIPandey > > > > On Tue, Oct 12, 2010 at 6:13 PM, rajasekhar praharaju < > rajasekhar.prahar...@gmail.com> wrote: > >> >> >> -- Forwarded message -- >> From:

Re: $$Excel-Macros$$ Please help

< rajasekhar.prahar...@gmail.com> wrote: > > > -- Forwarded message -- > From: rajasekhar praharaju > Date: Tue, Oct 12, 2010 at 5:49 PM > Subject: Re: $$Excel-Macros$$ Please help > To: Dilip Pandey , excel-macros@googlegroups.com > > > hi Dilip, >

Re: $$Excel-Macros$$ Please help

hi Dilip, firstly i will be copying the pivot table from task distribution sheet. Row Labels Sum of # of no hits DEEPTI 45 LAKSHMI 35 NIKHIL 46 PUSHPA 15 RAVI 7 SAI 35 VENKAT 46 ARVIND 21 Grand Total 250 this part from task distribution sheet and click on extension bar (+) to get th

Re: $$Excel-Macros$$ Please help

Dear Rakasekhar. I am not able to understand your problem actually... :( How you are assigning the names against tasks ? I believe creating a pivot table and then using "Show Pages" option you can assign the tasks to different individuals. Please explain further if you need some other solution.

Re: $$Excel-Macros$$ Please help

could you please assist me in this concern .please actually if any batch is pending using vlookup i used to find their respective names how is this possible through sumif please suggest . On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS wrote: > Dear Rajasekhar > > > Please use u Sumif Formulas. >

Re: $$Excel-Macros$$ Please help

Dear Rajasekhar Please use u Sumif Formulas. Regards Sumit Vyas On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju < rajasekhar.prahar...@gmail.com> wrote: > > > hi Excel Guru, > > > Please assist me in this concern . > > > Attached are two sheets Task distribution orginal and other she

Re: $$Excel-Macros$$ Please Help

please check the attached workbook On Mon, Sep 27, 2010 at 11:02 PM, hemant shah wrote: > Hi Team, > Can you please help on the attached file. > I have explained my query in the attached sheet. > Regards, > Hemant Shah --

<    1   2   3   >