Re: $$Excel-Macros$$ Need your help

2014-01-03 Thread Ashish Kumar
Dear Kartik, Please elaborate more. On 03/01/2014, karthik N wrote: > Dear Friends > > Please find the attached file. > > Please help.. > > *Regards* > karthik.N > > -- > 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 pa

$$Excel-Macros$$ Need your help

2013-07-20 Thread Sanjay Kumar Maurya
Hi All, I want to join this group. -- ***Thanks Sanjay Kumar Maurya* -- 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://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thr

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
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: Mangesh Vimay To: excel-macros@googlegroups.com Sent: Mon, August 13, 2012 10:35

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Mangesh Vimay
s 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:* David Grugeon > *To:* excel-macros@

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
you can, To all the people you can, As long as ever you can.” - John Wesley - From: David Grugeon To: excel-macros@googlegroups.com Sent: Mon, August 13, 2012 9:25:56 AM Subject: Re: $$Excel-Macros$$ Need your help Magnesh and Paul

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread David Grugeon
sh Vimay > *To:* excel-macros@googlegroups.com; NOORAIN ANSARI < > noorain.ans...@gmail.com>; rajan verma > *Sent:* Mon, August 13, 2012 8:48:16 AM > *Subject:* $$Excel-Macros$$ Need your help > > Hi Friends, > > Please help me on issue below. > *Issue :-* I need such excel

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
ngesh Vimay To: excel-macros@googlegroups.com; NOORAIN ANSARI ; rajan verma Sent: Mon, August 13, 2012 8:48:16 AM Subject: $$Excel-Macros$$ Need your help Hi Friends, Please help me on issue below. Issue :-  I need such excel file which can automatically stored login time with date and logout

$$Excel-Macros$$ Need your help

2012-08-13 Thread Mangesh Vimay
Hi Friends, Please help me on issue below. *Issue :-* I need such excel file which can automatically stored login time with date and logout time so that I could able to analysis for how much time my computer was switched on/in use. For example, If I login by the time *7:00:00 AM* and logout on *1

Re: $$Excel-Macros$$ Need your help !!!

2012-06-21 Thread Mohit Sharma
Thanks Noorain sir. you are simply superb. On Wed, Jun 20, 2012 at 7:23 PM, NOORAIN ANSARI wrote: > Dear Mohit, > > See attached sheet > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Wed, Jun 20, 2012 at 6:13 PM, Mohit Sharma wrote:

Re: $$Excel-Macros$$ Need your help !!!

2012-06-20 Thread NOORAIN ANSARI
Dear Mohit, See attached sheet -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jun 20, 2012 at 6:13 PM, Mohit Sharma wrote: > Hi > Noorain sir, your method is simply great. but can be display the total no > of Value in one time. for eg. in th

Re: $$Excel-Macros$$ Need your help !!!

2012-06-20 Thread Mohit Sharma
Hi Noorain sir, your method is simply great. but can be display the total no of Value in one time. for eg. in this sheet every value like ABZ,XYZ,PQR are repeated three times. so can be display total of ABZ or XYZ or PQR in answer column with the help of VLookup On Tue, Jun 19, 2012 at 10:49 PM,

Re: $$Excel-Macros$$ Need your help !!!

2012-06-19 Thread Mangesh Vimay
Thanks Noorain Bhai, On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI wrote: > see attached sheet > > > On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI > wrote: > >> Dear Mangesh, >> >> Please try it.. >> >> =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) >> with ctrl+Shif

Re: $$Excel-Macros$$ Need your help !!!

2012-06-19 Thread NOORAIN ANSARI
see attached sheet On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI wrote: > Dear Mangesh, > > Please try it.. > > =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) > with ctrl+Shift+enter > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacrowor

Re: $$Excel-Macros$$ Need your help !!!

2012-06-19 Thread NOORAIN ANSARI
Dear Mangesh, Please try it.. =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) with ctrl+Shift+enter -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay wrote: > Hi Friends, In above

$$Excel-Macros$$ Need your help !!!

2012-06-19 Thread Mangesh Vimay
Hi Friends, In above example, if we input the name like ABC then it should display it's apropriate values in the table from the above list. Please find the attached sheet. How can we find the solution by using Vlookup() function? . Thanks -- With regards, MaNgEsH -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Need Your Help

2012-04-29 Thread dguillett1
Nicely done...!! Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ╰» ℓαℓιт мσαнη Sent: Sunday, April 29, 2012 12:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Your Help Hi karthik PFA Regards, Lalit Mohan On Sun, Apr 29

Re: $$Excel-Macros$$ Need Your Help

2012-04-29 Thread ╰» ℓαℓιт мσαнη
*Hi karthik* * * *PFA* * * *Regards,* *Lalit Mohan* On Sun, Apr 29, 2012 at 10:56 PM, ╰» ℓαℓιт мσαнη wrote: > *Hi karthik* > * > * > *PFA* > > *Regards,* > *Lalit Mohan* > > > > On Sun, Apr 29, 2012 at 1:38 PM, karthik N wrote: > >> Hi friends, >> >> Find the attachment of company address,how

Re: $$Excel-Macros$$ Need Your Help

2012-04-29 Thread ╰» ℓαℓιт мσαнη
*Hi karthik* * * *PFA* *Regards,* *Lalit Mohan* On Sun, Apr 29, 2012 at 1:38 PM, karthik N wrote: > Hi friends, > > Find the attachment of company address,how to spreat'up the colomn wise > data > > Sample data is attached. > > > Regards > karthik.N > > -- > FORUM RULES (986+ members already

$$Excel-Macros$$ Need your help !!!

2012-04-04 Thread Mangesh Dayne
Hi Rajan, I need some web links for the study material of excel vba. So kindly send me links so that I could learn vba. With regards, Mangesh Dayne -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgen

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-20 Thread rajan verma
_Verma wrote: >> >>> Thanks and Welcome >>> >>> >>> -Original Message- >>> From: excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] >>> On Behalf Of Lawali >>> Sent: Friday, August 19, 2011 7:

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-20 Thread Indrajit $nai
.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Lawali > Sent: Friday, August 19, 2011 7:57 PM > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. > > Rajan, > Your solution is awesome!!! > > On Aug 19, 9:39 am, "Rajan_

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-19 Thread Indrajit $nai
ay, August 19, 2011 7:57 PM > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. > > Rajan, > Your solution is awesome!!! > > On Aug 19, 9:39 am, "Rajan_Verma" wrote: > > You Can Tri this : > > > > Pri

RE: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-19 Thread Rajan_Verma
Thanks and Welcome -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lawali Sent: Friday, August 19, 2011 7:57 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. Rajan, Your

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-19 Thread Lawali
Range("F9").Offset(0, k).Value = Range("A" & i).Offset(0, > 1).Value > >             k = k + 1 > >         End If > >     Next > > End If > > Err: > > Application.EnableEvents = True > > End Sub > > From: excel-macros@google

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread XLS S
Hey Inderjit, please find the attachment... On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote: > Hi All, > I need your small help in Vlookup formula. I have attached a file with this > mail, where you can see  2 columns in the left. One is Qty. another is Sr. > no. > Now I want to search Sr.

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread NOORAIN ANSARI
Dear indajit, Please see attached sheet.. On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote: > Hi All, > > I need your small help in Vlookup formula. I have attached a file with this > mail, where you can see 2 columns in the left. One is Qty. another is Sr. > no. > Now I want to search Sr.

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread ashish koul
try this On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote: > Hi All, > > I need your small help in Vlookup formula. I have attached a file with this > mail, where you can see 2 columns in the left. One is Qty. another is Sr. > no. > Now I want to search Sr. no. through Qty. Suppose if I put

$$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread Indrajit $nai
Hi All, I need your small help in Vlookup formula. I have attached a file with this mail, where you can see 2 columns in the left. One is Qty. another is Sr. no. Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will show me 14, if I put 600 it will show 6, but the problem i

Re: $$Excel-Macros$$ need your help on Validation

2010-12-14 Thread ashish koul
check this link http://www.contextures.com/xldataval13.html#Create On Tue, Dec 14, 2010 at 11:32 AM, lucky singh wrote: > > Hi All, > > need your help on validation > > if i select softdiet then only the menu of soft diet should be shown in > dropdown & not hard diet similarly to hard diet on h

$$Excel-Macros$$ need your help on Validation

2010-12-14 Thread lucky singh
Hi All, need your help on validation if i select softdiet then only the menu of soft diet should be shown in dropdown & not hard diet similarly to hard diet on hard diet should be shown in dropdown & not soft diet... Regards, Lucky -- --

Re: $$Excel-Macros$$ need your help

2010-02-11 Thread Abhishek Jain
Hi Shammi, I am not sure if I have understood your query correctly. This is what I have done: > On the basis of the total score, the Band in the range G11 to H15 will be highlighted with blue color. > The amount of proposed growth on the basis of percentage relevant to to Band # would be reflecte

$$Excel-Macros$$ need your help

2010-02-11 Thread shammi shrivastav
friends please go through the attached file and help me. For about an hour I am fiddling with this. what I want: based on the value in cell K8; the corresponding band level should be highlighted automatically and a final result is available after all the calculations corresponding to the relev

$$Excel-Macros$$ Need your help

2009-09-18 Thread Santhosh Kumar M K
Dear Friends, Need your kind support. In a single sheet I created 10 Pivots for same data.In all pivots have same option is *Customer name*.When I change the customer name as "Rajesh" in a first pivot, automatically should be change the same name "Rajesh" in other 9 pivots.PLease, give suggestio