Re: $$Excel-Macros$$ Formula needed

Dear Abhishek Really great problem solved. thanks a lot Regards Shrinivas On Fri, Aug 28, 2015 at 12:45 PM, Abhishek Jain wrote: > Hope this helps. > > Whenever you want to make any change in the formula, do it in the first > resulting value, i.e, G2 and remember to press Ctrl+Shift+Enter (not

Re: $$Excel-Macros$$ Formula needed

Hope this helps. Whenever you want to make any change in the formula, do it in the first resulting value, i.e, G2 and remember to press Ctrl+Shift+Enter (not just enter) before dragging it down. Regards, On Fri, Aug 28, 2015 at 12:06 PM, Shrinivas Shevde wrote: > Dear All > Please find query.

Re: $$Excel-Macros$$ Formula Needed Please

please check the attachment On Fri, Mar 13, 2015 at 11:58 AM, Will Sob wrote: > > Hi, > Please I need help with the attached file. I want a that calculates how > many times 10, 13, 17 has appeared within the range D5:I32 > > > > > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan

Re: $$Excel-Macros$$ Formula Needed for Subtracting 2 Different Date/Time formats....

Santy, Absolutely phenomenal! Thank you for your brilliant, quick reply! John On Monday, August 26, 2013 8:56:14 AM UTC-4, Santy wrote: > > Little lengthy formula but working fine > > > *Thanks & Regards,* > *Santy* > > > On Mon, Aug 26, 2013 at 5:56 PM, John A. Smith > > > wrote: > >> I

Re: $$Excel-Macros$$ Formula Needed !!!!!

use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya wrote: > PFA File > > On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal > wrote: > > Thx Abhi > > > > > > > > > > Regards, > > > > Iqbal S > > > > > > On 22 October 2012 17:24, a

Re: $$Excel-Macros$$ Formula Needed !!!!!

Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal wrote: > > > Dear Shaikh Iqbal > > > > > Please find the attachment for the same > > > > > On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal wrote: > >> Dear Exports, >> >> Need help in attached file. >> >> >> >> >> >> >> >> >>

RE: $$Excel-Macros$$ Formula needed to extract the text from string

---Original Message- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: Saturday, October 15, 2011 09:59 PM > To: excel-macros@googlegroups.com > Cc: Noor Ali Sayyed; Anil Bhange > Subject: Re: $$Excel-Macros$$ Formula needed to extract the text from > string > &g

Re: $$Excel-Macros$$ Formula needed to extract the text from string

om: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Anil Bhange > Sent: Wednesday, October 12, 2011 04:14 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Formula needed to extract the text from string > > Amazing... Ms-Ex

Re: $$Excel-Macros$$ Formula needed to extract the text from string

r attached mail. > > ** ** > > Regards,Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Anil Bhange > *Sent:* Wednesday, October

RE: $$Excel-Macros$$ Formula needed to extract the text from string

PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Formula needed to extract the text from string Amazing... Ms-Exl-learner... This is exactly what I wanted... I was pretty sure this forum only can help me with solution... Thanks once again.. this saves my lot of time... Regards

Re: $$Excel-Macros$$ Formula needed to extract the text from string

Hi Anil, Designed a formula using Substitute function. See the attachment and let me know if this helps. Regards, DILIPandey On 10/12/11, Anil Bhange wrote: > Hi Expert, > > I needed the formula which can extract the specific content from a Text, > below is some sample excel cells > > To simpl

Re: $$Excel-Macros$$ Formula needed to extract the text from string

Hello Anil, A short version to Ms.Exl.Learner =TRIM(MID(SUBSTITUTE(A2,"/",REPT(" ",255)),4*255,255)) HTH Haseeb For help & tips visit; http://www.excelfox.com/forum/forum.php -- -- Some important links for excel u

Re: $$Excel-Macros$$ Formula needed to extract the text from string

t; > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ms-Exl-Learner . > *Sent:* Wednesday, October 12, 2011 03:34 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Formula needed to extract the t

RE: $$Excel-Macros$$ Formula needed to extract the text from string

-macros@googlegroups.com] On Behalf Of Ms-Exl-Learner . Sent: Wednesday, October 12, 2011 03:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula needed to extract the text from string Hi Anil, I Assume that your data is in Column A and your first row is having the column

Re: $$Excel-Macros$$ Formula needed to extract the text from string

Dear Anil, See attached sheet if it help to u.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Oct 12, 2011 at 1:20 PM, Anil Bhange < anil.bha..

Re: $$Excel-Macros$$ Formula needed to extract the text from string

Hi Anil, I Assume that your data is in Column A and your first row is having the column header. So your data will start from 2nd row of Column A (i.e. from A2 cell) A1 Data A2 /ENTRY-10 OCT TRF/REF 6004ABS6834230 /ORD/ Q-FAST TELECOM BV STRIJKVIERTEL 26 A 3454 PMDE MEERN /BNF/ INVOICENO 201

Re: $$Excel-Macros$$ Formula Needed to Extract Data

Johnny Can you please tell me which code you are talking about workbook which i attached as answer to this post is having only formulas can you attach your workbook. and brief description about ur problem On Thu, Jun 9, 2011 at 11:41 PM, Johnny wrote: > Ash > > Can you post the VBA code? I d

Re: $$Excel-Macros$$ Formula Needed to Extract Data

Ash Can you post the VBA code? I downloaded the example but it is not in the workbook. I need to use a similar code for data extraction also. This code might help me, too. Thanks Johnny -- -- Some important l

Re: $$Excel-Macros$$ Formula Needed to Extract Data

It helped very much Ashish, thank you again for your kind teachings. John On Fri, Jun 3, 2011 at 1:43 PM, ashish koul wrote: > see if it helps > > > On Wed, Jun 1, 2011 at 7:07 PM, John A. Smith wrote: > >> Need help please extracting specific data from an Excel spreadsheet into >> an Excel

Re: $$Excel-Macros$$ Formula Needed to Extract Data

see if it helps On Wed, Jun 1, 2011 at 7:07 PM, John A. Smith wrote: > Need help please extracting specific data from an Excel spreadsheet into an > Excel report. > > The arrangement of the data isn't always in the same order as shown in the > attached sample. > > Thank you again for your kind he