Re: $$Excel-Macros$$ I want to merge two text cell

Hi pfa From: Dhaval Shah To: excel-macros@googlegroups.com Sent: Wednesday, 6 March 2013 5:21 PM Subject: $$Excel-Macros$$ I want to merge two text cell dear friends i want to merge two text cell in one pls refer the sheet thanks dhaval -- Are y

Re: $$Excel-Macros$$ Sumproduct using VBA

With VBA require you to download the file 2013/7/12 Chandra Shekar > Hi, > > Could you please let me know how to use sumproduct using VBA? Where range > is date values. > > > =SUMPRODUCT(--(INT(Dump!$F$2:$F$5)>=C2)*(INT(Dump!$F$2:$F$5)<=D2)*--((Dump!$D$2:$D$5="U")+(Dump!$D$2:$D$5

Re: $$Excel-Macros$$ pulling data from a validation list

Vang File attachments and you need to specify the contents to be 2013/7/12 ravinder negi > please elaborate your query with attachment and examples > > > On Fri, 7/12/13, vba wrote: > > Subject: Re: $$Excel-Macros$$ pulling data from a validation l

$$Excel-Macros$$ Re: This Formula to span number of nights (from Date of Arrival to Date of Departure) not working!

Thank you again De Premor! I was struggling to find out what was wrong with the formula! :-) Love this forum! On Thursday, July 11, 2013 9:16:27 PM UTC+4, Ali wrote: > > Hi all, > > I recently posted a topic to solve an issue regarding the span of total > number of nights spent in specific co

$$Excel-Macros$$ Amazing Excel Charts

Hi Group Please find amazing chart collection here https://sites.google.com/site/e90e50charts/ -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog * Like Us on Facebook Join Us on Facebook

$$Excel-Macros$$ Sumproduct using VBA

Hi, Could you please let me know how to use sumproduct using VBA? Where range is date values. =SUMPRODUCT(--(INT(Dump!$F$2:$F$5)>=C2)*(INT(Dump!$F$2:$F$5)<=D2)*--((Dump!$D$2:$D$5="U")+(Dump!$D$2:$D$5="E")>0)) Regards Chandra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ fractions calculation macro

Hello, I am trying to implement the following calculation: column F (input) 100-05 3/4 --> Column G (output) 100.085 100+(05+3/4)/32 --> logic the new logic is represented through case "/" in the code below, *which is currently not outputting any result.* Sub dashes() Dim Rng As Range, Dn A

$$Excel-Macros$$ step to make and install excel 2007 add in on user machine

Hi Expert, can any one explain me how to make an add in in excel 2007, contain a user define function. what things to keep in mind to make scalable and robust add in. Please also point out the steps through which a normal excel user can install on his machine easily. thanks Divaker -- Are you

Re: $$Excel-Macros$$ pulling data from a validation list

please elaborate your query with attachment and examples On Fri, 7/12/13, vba wrote: Subject: Re: $$Excel-Macros$$ pulling data from a validation list To: "excel-macros@googlegroups.com" Date: Friday, July 12, 2013, 1:49 PM Hey  Pl refer for e

Re: $$Excel-Macros$$ pulling data from a validation list

please provide excel file with exmaple On Fri, 7/12/13, vba wrote: Subject: Re: $$Excel-Macros$$ pulling data from a validation list To: "excel-macros@googlegroups.com" Date: Friday, July 12, 2013, 1:49 PM Hey  Pl refer for exhaustive tutorial

Re: $$Excel-Macros$$ pulling data from a validation list

Hey Pl refer for exhaustive tutorial on the data validation: http://www.contextures.com/xlDataVal01.html Thanks!! On Fri, Jul 12, 2013 at 1:39 AM, vang wrote: > How do i pull values from a validation list ? > i am trying to do a simple nutritional planer. i have a list contaning > nutiotion

Re: $$Excel-Macros$$ SEARCH OPTION DOUBT

Hey Pl refer attached file, I have done for few cases.. You have to finish home work for rest of cases. Make Sure Header is matching with Heading of Data. Thanks!! On Fri, Jul 12, 2013 at 11:23 AM, Kannan Excel wrote: > hi, > > pls find the attached file, > > 2nd sheet is master data... 1st s