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

My dear friend I tried that... Simple copy & paste is not giving me all the fields. For today's data it is just giving me timing, for yesterday's data (till week end) it gives day & time & for previous week's data, it gives day & date. Best Regards, Amit From: excel-macros@googlegroups.com [ma

$$Excel-Macros$$ OFX to Excel-Reg

Dear All, Is it Possible to get OFX (Open Financial Exchange) data in to Excel. -- "Making a million friends is not a miracle, the miracle is to make a friend who will stand by you when a million are against you. "

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

PFA Sample Data, if we can do with formula or vba both option is welcome. Rgds Vaibhav On Tue, Aug 28, 2012 at 11:34 PM, wrote: > Hi All > > I have a tracker with almost 10 condition to be tasted. All condition is > shown as header, for case 1 when first event is completed then date of > completi

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

Dear vaibhav, Can you share sample worbook with group Sent from BlackBerry® on Airtel -Original Message- From: in.vaib...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 28 Aug 2012 18:04:01 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ If condition

RE: $$Excel-Macros$$ Baler Software

> Please don't ban me (I won't do it again) indicates foreknowledge and intent! -- 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, like

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

I would do this with a macro. Provide a file to ME along with this msg and examples. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: in.vaib...@gmail.com Sent: Tuesday, August 28, 2012 1:04 PM To: excel-macros@googlegroups.com Su

Re: $$Excel-Macros$$ Re: Required a search option in excel file

Didn’t anyone see my solution??? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Prince Dubey Sent: Monday, August 27, 2012 11:22 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Required a search option in excel file Hi Praveen, Please

$$Excel-Macros$$ Time Calculation

Greetings, I need a formula that calculates the amount of time between 7pm and 6pm and the entire weekend between 2 dates. Example: A1 = End Date and Time 8/1/2012 12:00:00PM B1 = Start Date and Time 8/21/2012 4:00:00PM I need the result to be in hh:mm:ss. Thanks in advance.

$$Excel-Macros$$ If condition limitation.

Hi All I have a tracker with almost 10 condition to be tasted. All condition is shown as header, for case 1 when first event is completed then date of completion is put under 1st header and under status for case 1 value to be reflected is description of header 1. When second event is completed

Re: $$Excel-Macros$$ Formula request - amount of time between 7pm and 6pm between 2 dates

I need the result in *hh:mm:ss* format. On Tuesday, August 28, 2012 1:40:40 PM UTC-4, Rajan_Verma wrote: > > *What amount you want.* > > *I mean in week, Day, Hour,Minute,Seconds or anything else?* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:*

$$Excel-Macros$$ Re: Formula request - amount of time between 7pm and 6pm between 2 dates

I need the result in *hh:mm:ss* format. On Tuesday, August 28, 2012 1:37:31 PM UTC-4, LJ wrote: > > Greetings, > > I need a formula that calculates the amount of time between 7pm and 6pm > between 2 dates. Example: > > A1 = End Date and Time 8/1/2012 12:00:00PM > B1 = Start Date and Time 8/21/201

RE: $$Excel-Macros$$ Formula request - amount of time between 7pm and 6pm between 2 dates

What amount you want. I mean in week, Day, Hour,Minute,Seconds or anything else? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of LJ Sent: 28 August 2012 11:08 To: excel-macros@googlegroups.com Subjec

$$Excel-Macros$$ Formula request - amount of time between 7pm and 6pm between 2 dates

Greetings, I need a formula that calculates the amount of time between 7pm and 6pm between 2 dates. Example: A1 = End Date and Time 8/1/2012 12:00:00PM B1 = Start Date and Time 8/21/2012 4:00:00PM Thanks in advance. J -- Join official facebook page of this forum @ https://www.facebook.com/

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

Apologies for not "adding" to this thread. But could not help but smile at the image after the question by Rajan. :-) :-) Thanks Ashish Pradhan On 28-08-2012 22:48, Rajan_Verma wrote: *Where you want to export, How you want to export ?* ** *Will you please elaborate this ?* ** *Descri

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

Where you want to export, How you want to export ? Will you please elaborate this ? Description: http://t2.gstatic.com/images?q=tbn:ANd9GcSUnzYbrl2H90NE5PREupCJIjQmzZBwRvBNi bEG_Ydd5M14PMrazw&t=1 J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.c

$$Excel-Macros$$ Exporting emails in excel

Dear Friends, Please let me know how we can export the mails & sort each fields like from, subject, date, time etc...s Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged info

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$$ Bullet graphs

Dear santosh, please visit here http://peltiertech.com/WordPress/how-to-make-horizontal-bullet-graphs-in-excel/ On Sat, Aug 25, 2012 at 4:21 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi, > > What are bullet graphs,would request to share some examples with me. > -- > Regards

$$Excel-Macros$$ Re: Required a search option in excel file

Hi Pravin, Plz see the attachment hope this time it will make some sense for you. regards prince On Tuesday, August 28, 2012 2:35:16 PM UTC+5:30, Pravin Gunjal wrote: > > Dear Prince > > It's working good. But this is not helpful for me. As we can not type the > full letters to search the data

$$Excel-Macros$$ Re: Required a search option in excel file

Dear Pravin, I think, Prince's code is correct, please try it once again.. rng.AutoFilter Field:=1, Criteria1:=*"*" & .Range("B2").Value & "*" * On Tue, Aug 28, 2012 at 6:42 PM, Pravin Gunjal wrote: > *Dear Noorain - Could you pl. help me our on this issue.* > > -- Forwarded message -

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

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

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

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

$$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$$ Need Help with a MAX NETWORKDAYS Formula

Greetings! I have been using the formula below to calculate the time between a start and end date and time during the work hours of 6AM and 7PM. The format for the results are hh:mm:ss. =MAX(0,TIME(19,0,0)-MAX(MOD(*O2*,1),TIME(6,0,0)))+ MAX(0,(NETWORKDAYS(INT(*O2*)+1,INT(*N2*)-1)))*13/24+ MAX(0

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Zibrean,, Please use below formula =TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("@",A4))-1)," ",REPT(" ",99)),99)) On Tue, Aug 28, 2012 at 2:50 PM, Zibraan wrote: > > Hi Team, > > I am looking for a formula to separate Company's name and email address > from IDs. > > Please refer the

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

Woh... Great Noorain Sir. Regards, Kuldeep Singh On Tue, Aug 28, 2012 at 3:53 PM, NOORAIN ANSARI wrote: > Dear Kuldeep, > > We can also use below alternative solution in pivot table.. > > Manually Create a Union Query > > If you can't combine your data on a single worksheet, another solution is

$$Excel-Macros$$ Re: time hours formula help

Try with ROUNDDOWN rounddown excel function to convert this into real number respective of positive or negative values (i sent you the file previously but you deleted my sheet...) On Tuesday, August 28, 2012 12:06:30 PM UTC+1, padsin bawa wrote: > > Hi, > > I have a workbook that requires a spec

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

but it has more than 130 email addresses it is not possible manually... On Tue, Aug 28, 2012 at 5:28 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Hi Lucky, > > You can use text to column fuction and put delimited from @. Then you can > manually replace com/net etc. > > Pleas

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Lucky, You can use text to column fuction and put delimited from @. Then you can manually replace com/net etc. Please seperate the if two mail addresses in one cell. Regards, KSAGAR On Tue, Aug 28, 2012 at 4:40 PM, David Grugeon wrote: > Hi Noorain > > It seems easy enough to create a UDF

Re: $$Excel-Macros$$ Q&A for Excel, Word & PPT

Hi Krishna, Very useful Q&A, thanks for sharing with us. On Tue, Aug 28, 2012 at 4:45 PM, Krishnaraddi V. Madolli < krishnaraddi.mado...@asia.xchanging.com> wrote: > "CONFIDENTIALITY NOTICE: This message and any attachment are confidential > and may also be privileged. If you are not the intende

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Thanks a lot Hilary... On Tue, Aug 28, 2012 at 2:25 PM, NOORAIN ANSARI wrote: > Dear Sagar, > > Please use attached study material to create Dashboard. > Hope it will help you. > > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Noorain It seems easy enough to create a UDF which finds the @ and then steps back until it finds a space. This will define the point to split the string. No time to do it at the moment. On 28 August 2012 20:39, Zibraan wrote: > > PFA... > > > On Tue, Aug 28, 2012 at 4:08 PM, NOORAIN ANSAR

$$Excel-Macros$$ time hours formula help

Hi, I have a workbook that requires a specific time formula that can show negative time offset as well as positive. I first would like negative offset to appear as negative offset (see yellow highlight) Then I would like if the formula can do this, to have other time show with + for positive

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Sure zibraan, Can you share a sample sheet. On Tue, Aug 28, 2012 at 3:47 PM, Zibraan wrote: > ok atleast can we extract email address > > > > On Tue, Aug 28, 2012 at 3:01 PM, NOORAIN ANSARI > wrote: > >> Dear Zibraan, >> >> I think it is very difficult to separate company Name and ID. because

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

Dear Kuldeep, We can also use below alternative solution in pivot table.. Manually Create a Union Query If you can't combine your data on a single worksheet, another solution is to create named ranges in an Excel file, and use MS Query to combine the data. There are sample files here: http://www

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

Yes Noorain Sir, Pivot Table is great solution for this query. Code 16-08-12 17-08-12 18-08-12 4656113 7402 8231 7231 4656114 7403 8232 7232 4656115 7404 8233 7233 4656116 7405 8234 7234 4656117 7406 8235 7235 4656118 7407 8236 7236 4656119 7408 8237 7237 4

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Dear Zibraan, I think it is very difficult to separate company Name and ID. because criteria is changing with word by word. Excel Function can't recognize company name. If you provide specific criteria then it can be done. On Tue, Aug 28, 2012 at 2:50 PM, Zibraan wrote: > > Hi Team, > > I a

$$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Team, I am looking for a formula to separate Company's name and email address from IDs. Please refer the snap shot below IDS Company Email Address Accord Soft asiapaci...@accord-soft.com

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

You asked of DB for share accounting and calculations for income tax. That is the domain area am referrin to Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: SAGAR KASANGOTTUWAR Sender: excel-macros@googlegroups.com Date: Tue, 28 Aug 2012 13:20:24 To: Repl

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Dear Hilary, Can you give some material for understanding DOMAIN area.? That will help me a lot... Thanks & Regards, Sagar Kasangottuwar On Tue, Aug 28, 2012 at 1:13 PM, wrote: > ** > Hi KSAGAR > > If one doesn't have an understanding of the domain area you can't design a > dashboard fo

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Hi KSAGAR If one doesn't have an understanding of the domain area you can't design a dashboard for it. I don't hv much operating knowledge of what you are describing. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: SAGAR KASANGOTTUWAR Sender: exce

$$Excel-Macros$$ Need MS Office 2010

Dear Group!! Can any one provide me full setup for MS Office 10? Regards, @Suman Send on the move with Galexy y. -- 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