Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] please help me to solve this question it's very urgent

You're great Noorain Sir. Regards, Kuldeep Singh On Thu, Aug 30, 2012 at 10:56 AM, NOORAIN ANSARI wrote: > Dear Pravesh, > > See attached sheet for more clarity. > > > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

$$Excel-Macros$$ Re: [XL-VBA Clinic] please help me to solve this question it's very urgent

Dear Pravesh, See attached sheet for more clarity. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Thu, Aug 30

$$Excel-Macros$$ Re: [XL-VBA Clinic] please help me to solve this question it's very urgent

Dear Pravesh, You can use vlookup through Concatenate function with helping column. =VLOOKUP(CONCATENATE(G3,H3),$A$3:$D$9,4,0) Alternate solution =LOOKUP(9E+300,1/(($B$3:$B$9=G3)*($C$3:$C$9=H3)),$D$3:$D$9) Or =INDEX($D$3:$D$9,MATCH(1,($B$3:$B$9=G3)*($C$3:$C$9=H3),0)) Or =OFFSET($D$2,MATCH(1,($B$

Re: $$Excel-Macros$$ If condition limitation.

Hi Vaibhav, Please try this. =IFNA(MATCH(1,2:2,-1)),"",INDEX($1:$1,0,MATCH(1,2:2,-1))) Regards, Kuldeep Singh On Wed, Aug 29, 2012 at 10:37 PM, in.vaib...@googlemail.com < in.vaib...@gmail.com> wrote: > Hi Don, > > This work on logic that this formulae returns nearest max vaue to -1 that > is

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Pravesh, Enclosed herewith your query solu Regards, Gawli Anil On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh wrote: > > Dear Preavesh, > > 04 solutions of you. for any query please see attachment. > > =LOOKUP(H3,$C$3:$D$9) > =VLOOKUP(H3:H6,$C$3:$D$9,2,0) > =VLOOKUP(H3,$C$3:$D$9,2,0) > =IF

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Preavesh, 04 solutions of you. for any query please see attachment. =LOOKUP(H3,$C$3:$D$9) =VLOOKUP(H3:H6,$C$3:$D$9,2,0) =VLOOKUP(H3,$C$3:$D$9,2,0) =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) Regards, Kuldeep Singh On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya wrote: > Hi Praves

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi Pravesh, Find the attached solved file. =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) Reagrds Amresh On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish < vaishpriyanka2...@gmail.com> wrote: > Hi Pravesh, > > =VLOOKUP($H3,$C$3:$D$9,2,0) > > I think this formula would solve

$$Excel-Macros$$ Outlook to excel VBA

Hi, I would like to import the timestamp from outlook with specific subject lines into excel. All mails reside in the inbox folder. The idea is to know by what time a specific task has been completed every day (against an SLA) . and this is understood by the specific subject line on the email.

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi Pravesh, =VLOOKUP($H3,$C$3:$D$9,2,0) I think this formula would solve your question. On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR wrote: > Hi Team, > > please help me to solve this question it's very urgent > > > waiting your response > > > > -- > > Thanks & Regards > > Prav

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Mr. Pravesh See the attached file and kindly refer the forum rules, the subject line must be clear regarding your query Ashish On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR wrote: > Hi Team, > > please help me to solve this question it's very urgent > > > waiting your response > > > > -- > >

$$Excel-Macros$$ please help me to solve this question it's very urgent

Hi Team, please help me to solve this question it's very urgent waiting your response -- Thanks & Regards Pravesh Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurat

Re: $$Excel-Macros$$ Exporting emails in excel

Dear Amit, Send me your sample extracted data and format in which you want day. Rgds Vaibhav -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups.com Date: Thu, 30 Aug 2012 09:25:16 To: 'in.vaib...@googlemail.com'; Reply-To: excel-macros@googlegroups.com Subj

RE: $$Excel-Macros$$ Exporting emails in excel

I am not getting entire data (of day, date & time) in a column so sorting through formula will not work... Best Regards, Amit From: in.vaib...@googlemail.com [mailto:in.vaib...@gmail.com] Sent: 29 August 2012 22:51 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Exporting em

$$Excel-Macros$$ How many time I've opened a particular file in a day?

Hi All, Can we track through VBA, how many time I've opened a particular file in a day? If it's possible then please provide me the VBA code. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use

Re: $$Excel-Macros$$ countdown macro needed.........

What is the purpose for this? On the face, it's very simple. However, it would not necessarily be ACCURATE. Basically, you would initialize a counter and loop , decrementing the counter and display the value, then use Wait() to wait for 1 second. because the time involved in decrementing the count

$$Excel-Macros$$ countdown macro needed.........

Hi Experts, I need a countdown macro as per attched file. Pl. help. Regards, Dhananjay -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ If condition limitation.

Hi Don, This work on logic that this formulae returns nearest max vaue to -1 that is cell refering to highest date. If i want this to return cell refering to lowest date then how can we et it. Rgds Vaibhav On Wed, Aug 29, 2012 at 7:07 PM, dguillett1 wrote: > =IF(ISNA(MATCH(1,2:2,-1)),"",IND

Re: $$Excel-Macros$$ Returning a cumulative value based on the contents of a given cell

Don, Steve attached a sample sheet. I changed the column headings to dates (first of the month) and changed the display format to show only the month name. then, I tried to use a sumif() but it didn't work correctly. now I've got to work on something else and won't be able to look at it for a w

Re: $$Excel-Macros$$ Returning a cumulative value based on the contents of a given cell

Provide examples and logic Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Steve Weaver Sent: Wednesday, August 29, 2012 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Returning a cumulative value based on the contents of a given cell

Re: $$Excel-Macros$$ Re: NETWORKDAYS Formula to calculate amount of hours

Oh yeah, I forgot. This return value is in Hours, and fractional part of an hour. if you try to display it as time: (hh:mm:ss) Excel will assume that you're actually looking at days and the decimal is the fractional part of a day. So, to display it as hh:mm:ss, you'll actually have to convert y

Re: $$Excel-Macros$$ Re: NETWORKDAYS Formula to calculate amount of hours

How about this logic: You can calculate the number of Networkdays. This INCLUDES the entire day. Your core hours are 6:00am to 7:00pm, or 13 hours, so NETWORKDAYS(A2,B2)*13 gives you the number of h ours in full days of work. Next, determine if the starting and ending days are non-working days.

Re: $$Excel-Macros$$ Learn Array formula's

Dear Murlidhar, Some best sites for Array Function http://www.cpearson.com/excel/ArrayFormulas.aspx http://www.ozgrid.com/Excel/arrays.htm On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E wrote: > hi to all group members, > > I want to learn can anyone send me the array formula's guide for beginne

RE: $$Excel-Macros$$ Copy excel files from different folders

Thanks a lot. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: 29 August 2012 19:47 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Copy excel files from different folders You can visit here http://excelpoweruser.wordpres

RE: $$Excel-Macros$$ Copy excel files from different folders

You can visit here http://excelpoweruser.wordpress.com/2012/08/17/get-all-files-hyperlinks-in-e xcel/ Download this file Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Krishnaraddi V. Mad

$$Excel-Macros$$ Copy excel files from different folders

Hi Experts, Do we have code to extract all excel files from sub folder. Ex: In Main folder we have 20 sub folders consists of excel files. I want to extract all 20 excel files and copy them to different location. Thanks & Regards. Krishna. "CONFIDENTIALITY NOTICE: This message and any attachment

Re: $$Excel-Macros$$ If condition limitation.

=IF(ISNA(MATCH(1,2:2,-1)),"",INDEX($1:$1,0,MATCH(1,2:2,-1))) copy down Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: mailto:in.vaib...@gmail.com Sent: Tuesday, August 28, 2012 11:51 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

$$Excel-Macros$$ Re: NETWORKDAYS Formula to calculate amount of hours

Hi Paul, My apologies and thanks for the lesson in etiquette. I was trying to be brief as to not bog people down with unnecessary details. I have a formula that I have been using, as stated, in a previous thread. However, it doesn't work when calculating non-core hours. Simply put, it doesn't m

Re: $$Excel-Macros$$ OFX to Excel-Reg

http://www.ofx.net/DownloadPage/Downloads.aspx Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: RAJA SEKAR Sent: Wednesday, August 29, 2012 12:01 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ OFX to Excel-Reg Dear All, Is it Possible to get

Re: $$Excel-Macros$$ NETWORKDAYS Formula to calculate amount of hours

LJ, I've located at least FOUR DIFFERENT discussion threads that you've created for what seems to be this same topic. Each worded slightly differently. In each case, it seems that the answers you are getting are not sufficient for your needs. First of all, it's somewhat rude to open three differ

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

Hi Siraj, It's working fine. Once consider if there are separate files / worksheets then how we can merge those on single workbook. On Wed, Aug 22, 2012 at 10:07 AM, Siraj Momin (BTG) wrote: > PFA > > ** ** > > Siraj > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > exce

$$Excel-Macros$$ NETWORKDAYS Formula to calculate amount of hours

I need a NETWORKDAYS formula to calculate the time between a start and end date and time during the work hours of 6AM and 7PM and excluding weekends. The format for the results need to be in hh:mm:ss format. A2 = End Time B2 = Start Time Appreciate the help. LJ -- Join official facebook page

$$Excel-Macros$$ Learn Array formula's

hi to all group members, I want to learn can anyone send me the array formula's guide for beginners with examples. Thanks in advance. -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Join official facebook page of this forum @ https://www.facebook.com/

Re: $$Excel-Macros$$ Re: Macro to convert date at the time of entry

Dear Rashid, Please try.. Option Explicit Public Function ReverseDate(Rng As Excel.Range) If VBA.Len(Rng) = 8 And IsNumeric(Rng) = True Then ReverseDate = VBA.Right(Rng, 4) & VBA.Mid(Rng, 3, 2) & VBA.Left(Rng, 2) Else ReverseDate = vbNullString End If End Function On Sun, Aug 26, 2012 at 1