Fwd: $$Excel-Macros$$ Formula needed

2018-09-09 Thread KAUSHIK SAVLA
Hi All, Awaiting for your help on formula. Thanks, Kaushik Savla -- Forwarded message - From: KAUSHIK SAVLA Date: Wed, Sep 5, 2018 at 8:06 PM Subject: $$Excel-Macros$$ Formula needed To: MS EXCEL AND VBA MACROS KAUSHIK SAVLA [image: Attachments]1:53 PM (6 hours ago) to

$$Excel-Macros$$ Formula needed

2018-09-05 Thread KAUSHIK SAVLA
KAUSHIK SAVLA [image: Attachments]1:53 PM (6 hours ago) to excel-macros Hi team, Need an formula whick will look at each cell of Column A and Column B and fetch result Criteria as below:- if Account beginning with 1 and if have balance positive then OK, otherwise "To check" if Account beginn

Re: $$Excel-Macros$$ Formula needed

2015-08-28 Thread Shrinivas Shevde
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

2015-08-28 Thread Abhishek Jain
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.

$$Excel-Macros$$ Formula needed

2015-08-27 Thread Shrinivas Shevde
Dear All Please find query. I have a excel sheet where I store all parts details I received . I want to make a list of all parts . I cant use remove duplicate function.. Can I get some other way/Formula so that list will keeps on updating as and when I will add new parts. Please find attached sheet

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

2015-03-13 Thread Sanjib Chatterjee
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

$$Excel-Macros$$ Formula Needed Please

2015-03-12 Thread Will Sob
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 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.faceboo

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

2013-08-26 Thread JohnA
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 !!!!!

2012-10-22 Thread Aamir Shahzad
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 !!!!!

2012-10-22 Thread Shaikh Iqbal
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

2011-10-16 Thread Dilip Pandey
---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

2011-10-15 Thread Dilip Pandey
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

2011-10-15 Thread ashish koul
l-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, > > ** ** &g

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

2011-10-15 Thread Anil Bhange
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

2011-10-12 Thread Dilip Pandey
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

2011-10-12 Thread Haseeb Avarakkan
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

2011-10-12 Thread Ms-Exl-Learner .
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

2011-10-12 Thread Anil Bhange
-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

2011-10-12 Thread NOORAIN ANSARI
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

2011-10-12 Thread Ms-Exl-Learner .
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

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

2011-10-12 Thread Anil Bhange
Hi Expert, I needed the formula which can extract the specific content from a Text, below is some sample excel cells To simplify this there is "/" sign after each content, and I need exact data which start after 4th "/" and till 5th "/" (which is mention below in Red). Can anybody tell me the

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

2011-06-09 Thread ashish koul
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

2011-06-09 Thread Johnny
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

2011-06-07 Thread John A. Smith
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

2011-06-03 Thread ashish koul
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

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

2011-06-01 Thread John A. Smith
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 help. John --

$$Excel-Macros$$ Formula needed

2009-05-26 Thread venkat sudhakar
Dear Friends, I need a formula for my work. There will be 2 Excel sheets. In First Sheet there will be 2 Columns In First column there will be code and in 2nd column there will be value and 'n' number of rows will be there. And the code may be repeated at several times in different rows. And i