$$Excel-Macros$$ Correct function

So what I hae seems simple but am stumped and on short timeframe. I need formula for the following: 1 to 9.5 = 1 9.75 to 19 = 2 .. every increment of 9.5 = 1 Thanks in advance! -- 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

Re: $$Excel-Macros$$ Subtotal function

On Sun, 5/14/17, 'Minta Spriggs' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Subtotal function To: excel-macros@googlegroups.com Date: Sunday, May 14, 2017, 3

Re: $$Excel-Macros$$ Subtotal function

On Sat, 5/13/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Subtotal function To: excel-macros@googlegroups.com Date: Saturday, May 13, 2017, 9

Re: $$Excel-Macros$$ Subtotal function

On Fri, 5/12/17, Abdelrahman Noaman <abdelrahman.go...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Subtotal function To: excel-macros@googlegroups.com, izharra...@gmail.com Date: Friday, May 12, 2017, 8:37 PM On 12 May 2017 at

Re: $$Excel-Macros$$ Subtotal function

On 12 May 2017 at 06:58, Izhar wrote: > rking in s hi Change it from =SUBTOTAL(9,J2:J1399*1*) to =SUBTOTAL(9,J2:J1399*0*) Thanks & Best Regards *Abdelrahman Gomaa | *Supervisor Receivable Accountant* | *Cancun Beach Resort & Spa Address: 102 KM Suez - Zafarana Road,

$$Excel-Macros$$ Simple function but it returns #VALUE

I am trying to create a very simple function that will take a string of text and read a range of texts to see if I have any that string in any of the ranges of the texts. Should be a 10-minute problem to solve. I am however getting a #VALUE back. I call the function with this:

$$Excel-Macros$$ IF Function in Excel

https://www.youtube.com/watch?v=ce76NYo0Na4 -- 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 thread titles. Poor thread

$$Excel-Macros$$ RAND() Function with Probability

Hi Guys, Lets say i want to predict the weather using the RAND() Functions. I have the weather and probability. Snow 0.21 Cloudy 0.33 Sunny 0.3 Rainy 0.16 And i have to predict the entire month of January, what formulae do i use to do so? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ IF Function

Good Afternoon, Please help, how to calculate the average price between the lowest and second lowest price, when there is 5 different price for one item. -- 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

Re: $$Excel-Macros$$ Excel function for TC_Name with Priority.

Thanks alot Ravinder. Thanks, Regards, Sairam Prasath. Mob - +91-98848 12055 On Sun, Dec 13, 2015 at 12:37 PM, 'ravinder negi' via MS EXCEL AND VBA MACROS wrote: > Hi, please use below formula > > >

Re: $$Excel-Macros$$ Excel function for TC_Name with Priority.

Hi, please use below formula =IF(IFERROR(SEARCH("_H_",A2),0)>0,"High",IF(IFERROR(SEARCH("_M",A2),0),"Medium","Low"))  or attached file On Saturday, December 12, 2015 5:08 AM, Sairam Prasath wrote: Hi All,I need the excel formula for the following. | TC_Name |

$$Excel-Macros$$ Excel function for TC_Name with Priority.

Hi All, I need the excel formula for the following. *TC_Name* *Priority* TC_H_001 High TC_M_001 Medium TC_L_001 Low The above are the columns that I am maintaining. In the column name TC_Name, if there is a character “_H_” then in Priority it should be updated as “High” and if the

RE: $$Excel-Macros$$ Excel function for TC_Name with Priority.

.com Subject: $$Excel-Macros$$ Excel function for TC_Name with Priority. Hi All, I need the excel formula for the following. TC_Name Priority TC_H_001 High TC_M_001 Medium TC_L_001 Low The above are the columns that I am maintaining. In the column name TC_Name, if there is a ch

$$Excel-Macros$$ Match function problem

Sorry for bothering you i'm new in VBA I am trying to use the MATCH function in VBA to search for a particular hour in a range containing hours and return the matching column number that give me Error N°13 so thank you for your help Public Sub test() With Sheets(F. Regulation) Dim dt As

$$Excel-Macros$$ Need function help to calculate on matched field data

Dear experts, Kindly see attached file in which I make formula in yellow cell that is if match particular task with Sheet2 table, the calculated data should be from matched task. I tried with array but not get exact output. Please suggest me how to calculate data only those which matched of

$$Excel-Macros$$ Re: Function for Data validataion

Dear Ashish, Following should solve the issue AND(ISNUMBER(--RIGHT(B8,7)),LEN(B8)=11,(ISTEXT(IFERROR(VALUE(MID(B8,1,1)),(MID(B8,1,1),(ISTEXT(IFERROR(VALUE(MID(B8,2,1)),(MID(B8,2,1),(ISTEXT(IFERROR(VALUE(MID(B8,3,1)),(MID(B8,3,1),(ISTEXT(IFERROR(VALUE(MID(B8,4,1)),(MID(B8,4,1))

Re: $$Excel-Macros$$ Require function for lookup value on condition.

Thanks Mr.Vaibhav Mr.Sandeep, that's exactly what i need:) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 9, 2015 at 10:39 AM, Sandeep Sharma sandeepsharma4...@gmail.com wrote: Thanks

Re: $$Excel-Macros$$ Require function for lookup value on condition.

Kindly check this Non-Array solution. With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” On Sat, Feb 7, 2015 at 9:26 PM, Vaibhav Joshi v...@vabs.in wrote: Check this... On Fri, Feb 6, 2015 at 11:08 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote:

Re: $$Excel-Macros$$ Require function for lookup value on condition.

really good Sandeep On Sun, Feb 8, 2015 at 3:37 PM, Sandeep Sharma sandeepsharma4...@gmail.com wrote: Kindly check this Non-Array solution. With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” On Sat, Feb 7, 2015 at 9:26 PM, Vaibhav Joshi

Re: $$Excel-Macros$$ Require function for lookup value on condition.

Thanks Vaibhav. Sir, I want to learn VBA so, suggest me where from start. With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” On Sun, Feb 8, 2015 at 10:39 PM, Vaibhav Joshi v...@vabs.in wrote: really good Sandeep On Sun, Feb 8, 2015 at 3:37 PM,

Re: $$Excel-Macros$$ Require function for lookup value on condition.

Check this... On Fri, Feb 6, 2015 at 11:08 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I require function to lookup value on consider of two particular condition. Pls. see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this

$$Excel-Macros$$ Require function for lookup value on condition.

Dear experts, I require function to lookup value on consider of two particular condition. Pls. see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Worksheet Function

can.” - John Wesley* - *From:* Eugene Bernard eugene.bern...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, January 8, 2015 11:50 AM *Subject:* $$Excel-Macros$$ Worksheet Function Please find attached a sheet, where i am facing

$$Excel-Macros$$ Worksheet Function

Please find attached a sheet, where i am facing a error in the one liner macro. TIA Regards Eugene -- 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

Re: $$Excel-Macros$$ Worksheet Function

you can, To all the people you can, As long as ever you can.” - John Wesley - From: Eugene Bernard eugene.bern...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, January 8, 2015 11:50 AM Subject: $$Excel-Macros$$ Worksheet Function Please

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

Hi Check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Dec 25, 2014 at 10:41 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Hello Mr.Vaibhav As per trial mail, you solved my function query to display data on matching code, but

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

Thanks... you are always rock in excel..Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Thu, Dec 25, 2014 at 10:50 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this... Cheers!!

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

Cheers!! On Dec 26, 2014 8:18 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Thanks... you are always rock in excel..Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Thu, Dec 25,

$$Excel-Macros$$ Need function help for output of particular list on matching data

Hello Mr.Vaibhav As per trial mail, you solved my function query to display data on matching code, but could you please edit this function to display only those data which matching with code Date, example is mention in attached sheet. Regards. Ashish Bhalara 9624111822 P*Please do not print

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

Hi check this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 11:17 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I try below function to get output from other sheet on matching data written in L1 in sheet

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

Hi Mr.Vaibhav Ones again thank you so much for your tremendous job to help me. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 23, 2014 at 2:31 PM, Vaibhav Joshi v...@vabs.in wrote: Hi

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 2:51 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Hi Mr.Vaibhav Ones again thank you so much for your tremendous job to help me. Regards. Ashish Bhalara 9624111822 P*Please

$$Excel-Macros$$ Need function help for output of particular list on matching data

Dear experts, I try below function to get output from other sheet on matching data written in L1 in sheet of 'Letter'. But this function is not working and I'm not able to understand error.

$$Excel-Macros$$ StrComp function through which assembly or references I can use this function in vba.

StrComp function through which assembly or references I can use this function in vba. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ StrComp function through which assembly or references I can use this function in vba.

, As long as ever you can.” - John Wesley - From: Mandeep Baluja rockerna...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, December 10, 2014 6:57 AM Subject: $$Excel-Macros$$ StrComp function through which assembly

$$Excel-Macros$$ need function to get data on exact match

Dear experts, I need function to receive data on fulfill particular cell data, the demo is attached herewith, thanks in advance. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

Hi Vaibhav Paul, Thanks a lot for your HELP. On Mon, Jul 21, 2014 at 6:18 PM, Vaibhav Joshi v...@vabs.in wrote: see this... Cheers!! On Mon, Jul 21, 2014 at 5:53 PM, Dileep Kumar deepuk...@gmail.com wrote: Hi Vaibhav, Thanks a lot for your reply. I found that what mistake I am

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

what you are trying to achieve? On Mon, Jul 21, 2014 at 5:12 PM, Dileep Kumar deepuk...@gmail.com wrote: Dear Friends, Please find attached Daily Reporting Formate of Excel in the summary sheet I am unable to get the vales using indirect function. Please help me friends. -- Regards,

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

Hi Vaibhav, Thanks a lot for your reply. I found that what mistake I am doing. Is there any way that we can give the reference of the date field in the summary sheet science I have all the sheet with dates only. That can much faster for me to finish out. On Mon, Jul 21, 2014 at 5:45 PM,

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

Sent: Monday, July 21, 2014 7:42 AM Subject: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help Dear Friends, Please find attached Daily Reporting Formate of Excel in the summary sheet I am unable to get the vales using indirect function. Please help me friends

RE: $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW

Try below mentioned Change cell ref.. =LEFT(B27,LEN(B27)-FIND(MT.,B27,1)+3) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Tuesday, February 11, 2014 1:47 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MID function

Re: $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW

[mailto: excel-macros@googlegroups.com] *On Behalf Of *amar takale *Sent:* Tuesday, February 11, 2014 1:47 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW Dear experts Pls help me on this issue of MID

Re: $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW

:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *amar takale *Sent:* Tuesday, February 11, 2014 2:40 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW Dear Sir I Replace all

$$Excel-Macros$$ Today Function

Can someone please tell me how to create a formula that will transpose the today function to a 8 digit numerical value ? The today function would be in cell A1... B1 would return the value. Example: A1 = 9/23/213 B1 = 20130923 Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Today Function

=TEXT(A1,MMDD) OR =TEXT(Today(),MMDD) On Mon, Sep 23, 2013 at 11:46 PM, Bill Q ronsmith...@gmail.com wrote: Can someone please tell me how to create a formula that will transpose the today function to a 8 digit numerical value ? The today function would be in cell A1... B1 would

Re: $$Excel-Macros$$ Today Function

Excellent Is there something that can be added to the code so that the returned value is in a numeric value ? On Monday, 23 September 2013 18:48:32 UTC-4, Ayush Jain wrote: =TEXT(A1,MMDD) OR =TEXT(Today(),MMDD) On Mon, Sep 23, 2013 at 11:46 PM, Bill Q ronsm...@gmail.com

Re: $$Excel-Macros$$ Today Function

=VALUE(TEXT(TODAY(),MMDD)) On Tue, Sep 24, 2013 at 12:10 AM, Bill Q ronsmith...@gmail.com wrote: Excellent Is there something that can be added to the code so that the returned value is in a numeric value ? On Monday, 23 September 2013 18:48:32 UTC-4, Ayush Jain wrote:

Re: $$Excel-Macros$$ Today Function

PERFECT ! Many thanks !! On Monday, 23 September 2013 19:20:16 UTC-4, Ayush Jain wrote: =VALUE(TEXT(TODAY(),MMDD)) On Tue, Sep 24, 2013 at 12:10 AM, Bill Q ronsm...@gmail.com javascript: wrote: Excellent Is there something that can be added to the code so that the returned

$$Excel-Macros$$ LEFT function Trouble !!! HELP PLZ !!!

Dear I am making a small error in my file, only one condition is working in VBA, Please give me tips to complete it Awaiting your answer RegardsSajid Memon -- 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) !

Re: $$Excel-Macros$$ LEFT function Trouble !!! HELP PLZ !!!

I tried to understand your code but couldn't. However, see if the attached helps. Thanks, On Mon, Aug 5, 2013 at 2:56 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear I am making a small error in my file, only one condition is working in VBA, Please give me tips to complete it Awaiting

Re: $$Excel-Macros$$ LEFT function Trouble !!! HELP PLZ !!!

Try this Private Sub CommandButton1_Click() Dim Rng As Range For Each Rng In Range(C1:C20) If Rng Then Rng.Offset(, 2) = IIf(Left(Rng, 1) = `, Tax, Retail) Next End Sub Pada 05/08/2013 16:26, SAJID MEMON menulis: Dear I am making a small error in my file, only one

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

Re: $$Excel-Macros$$ Indirect Function syntax

Hi MLT, Use this =SUM(INDIRECT(A1:A3)) ** * Best Regards, Ms Excel User * ** On Sun, Jul 21, 2013 at 12:37 AM, MLT mlthorn...@gmail.com wrote: I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum

$$Excel-Macros$$ Indirect Function syntax

cool thanks. can that same syntax be used for vlookup? for example: =VLOOKUP(INDIRECT(A1,B1:C3,2,FALSE)) -- 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

Re: $$Excel-Macros$$ Indirect Function syntax

Hi, Use this =VLOOKUP(INDIRECT(A1),B1:C3,2,FALSE) ** * Best Regards, Ms Excel User * ** On Sun, Jul 21, 2013 at 1:08 AM, MLT mlthorn...@gmail.com wrote: cool thanks. can that same syntax be used for vlookup? for example: =VLOOKUP(INDIRECT(A1,B1:C3,2,FALSE)) -- Are

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ indirect function syntax

I'm trying to figure out the syntax to use a function within the Indirect function. I would like to do something like this but am getting a #REF error: =INDIRECT(SUM(A1:A3)) Where am I going wrong? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ indirect function syntax

. Enjoy Team XLS On Sun, Jul 21, 2013 at 12:54 AM, MLT mlthorn...@gmail.com wrote: I'm trying to figure out the syntax to use a function within the Indirect function. I would like to do something like this but am getting a #REF error: =INDIRECT(SUM(A1:A3))

Fwd: $$Excel-Macros$$ Vlookup function using with match columns

function? Thanks in advance. -- Forwarded message -- From: Prafull Jadhav prafulltjad...@gmail.com Date: 10 July 2013 16:52 Subject: Re: $$Excel-Macros$$ Vlookup function using with match columns To: excel-macros@googlegroups.com Dear Murli, You can just give ref of column

$$Excel-Macros$$ Vlookup function using with match columns

Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup).

Fwd: $$Excel-Macros$$ Vlookup function using with match columns

vlookup function? *Note:* It is more helpful with sharing date by examples. Thanks in advance. -- Forwarded message -- From: Muralidhar E emuralidha...@gmail.com Date: 10 July 2013 15:30 Subject: $$Excel-Macros$$ Vlookup function using with match columns To: excel-macros

Re: $$Excel-Macros$$ Vlookup function using with match columns

E emuralidha...@gmail.com Date: 10 July 2013 15:30 Subject: $$Excel-Macros$$ Vlookup function using with match columns To: excel-macros@googlegroups.com Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How

Re: $$Excel-Macros$$ Vlookup function using with match columns

get the second value result by using vlookup function? *Note:* It is more helpful with sharing date by examples. Thanks in advance. -- Forwarded message -- From: Muralidhar E emuralidha...@gmail.com Date: 10 July 2013 15:30 Subject: $$Excel-Macros$$ Vlookup function using

Re: $$Excel-Macros$$ Vlookup function using with match columns

:* It is more helpful with sharing date by examples. Thanks in advance. -- Forwarded message -- From: Muralidhar E emuralidha...@gmail.com Date: 10 July 2013 15:30 Subject: $$Excel-Macros$$ Vlookup function using with match columns To: excel-macros@googlegroups.com Dear

$$Excel-Macros$$ split function in vba

I want this in excel formula..this one also very nice can you explain how split is working. --- On Sat, 6/15/13, De Premor d...@premor.net wrote: From: De Premor d...@premor.net Subject: Re: $$Excel-Macros$$ Cell Merge - Reg To: excel-macros@googlegroups.com Date: Saturday, June 15, 2013, 2:13

Re: $$Excel-Macros$$ split function in vba

Function ExtractEmail(Sentence As String) As String Dim Word For Each Word In Split(Sentence, ) If InStr(1, Word, @) 0 Then ExtractEmail = Word Next End Function For example: in case we have a sentence like *please send mail to some...@example.com or futher info* the split

Re: $$Excel-Macros$$ split function in vba

Subject: Re: $$Excel-Macros$$ split function in vba To: excel-macros@googlegroups.com Date: Saturday, June 15, 2013, 2:54 PM Function ExtractEmail(Sentence As String) As String     Dim Word     For Each Word In Split(Sentence, )     If InStr(1, Word, @) 0

Re: $$Excel-Macros$$ split function in vba

: From: De Premor d...@premor.net Subject: Re: $$Excel-Macros$$ split function in vba To: excel-macros@googlegroups.com Date: Saturday, June 15, 2013, 2:54 PM Function ExtractEmail(Sentence As String) As String Dim Word For Each Word In Split(Sentence, ) If InStr(1, Word, @) 0

$$Excel-Macros$$ saving function to use in all workbooks

Hi, How can i use a self created function in all my workbooks ? Thanks for your ideas Dirk -- 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

Re: $$Excel-Macros$$ saving function to use in all workbooks

create function add-in for reference please check below link http://stackoverflow.com/questions/755812/create-a-custom-worksheet-function-in-excel-vba . Enjoy Team XLS On Thu, Mar 28, 2013 at 3:53 PM, Dirk Lahaye dirk.lahaye.pr...@gmail.comwrote: Hi, How can i

$$Excel-Macros$$ WEEKDAY function of excel - need character day

Is there a function in excel 2013 that would give character day of week (e.g Mon, Tue...). Weekday function is giving numeric day, what is the fun of it. do we need to write another function or macro just to convert this numeric day to sun, mon... Thanks. -- Rawat -- Join official facebook

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

Dear VS, You can use it for weekday as Character day of week. =CHOOSE(WEEKDAY(A2),Sun,Mon,Tue,Wed,Thu,Fri,Sat) or =LOOKUP(WEEKDAY(A2),{1,2,3,4,5,6,7},{Sun,Mon,Tue,Wed,Thu,Fri,Sat}) see attached sheet for more clarity. On Mon, Sep 24, 2012 at 11:45 AM, V S Rawat g vsra...@gmail.com wrote:

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

Hi, Use TEXT function. Ex: =text(A2, ddd) On Sep 24, 2012 11:46 AM, V S Rawat g vsra...@gmail.com wrote: Is there a function in excel 2013 that would give character day of week (e.g Mon, Tue...). Weekday function is giving numeric day, what is the fun of it. do we need to write another

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

And if you don't want to use formula then use custom format of cell as ddd On Sep 24, 2012 11:55 AM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi, Use TEXT function. Ex: =text(A2, ddd) On Sep 24, 2012 11:46 AM, V S Rawat g vsra...@gmail.com wrote: Is there a function in excel

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

On 9/24/2012 11:58 AM India Time, _Swapnil Palande_ wrote: And if you don't want to use formula then use custom format of cell as ddd oh, that is even more easy. but, as the main date is visible in other cell, from which i want to show cdow in this cell, I guess the other formula sent by

Re: $$Excel-Macros$$ subtitute function infirmation required

Thanks to all... On Wed, Sep 19, 2012 at 11:24 AM, Karan Singh karan1...@gmail.com wrote: Please find below : http://blog.contextures.com/archives/2011/01/28/30-excel-functions-in-30-days-27-substitute/ Karan Singh On Wed, Sep 19, 2012 at 11:23 AM, Kuldeep Singh

RE: $$Excel-Macros$$ subtitute function infirmation required

You can Press F1 in Excel and Find Substitute Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manoj Kumar Sent: 19 September 2012 11:17 To: excel-macros@googlegroups.com Subject: $$Excel-Macros

$$Excel-Macros$$ subtitute function infirmation required

Dear Expert, i want know about subtitute. anybody tell me about subtitute function.. Regard Manoj -- 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

Re: $$Excel-Macros$$ subtitute function infirmation required

Hi, Please read below hope it will help you to understand substitute function.. In Excel, the *SUBSTITUTE* function replaces a set of characters with another. The syntax for the *SUBSTITUTE* function is: SUBSTITUTE( text, old_text, new_text, [nth_appearance] ) *text* is the original string

Re: $$Excel-Macros$$ subtitute function infirmation required

Hi see below links: http://office.microsoft.com/en-us/excel-help/substitute-function-HP010062578.aspx http://www.techonthenet.com/excel/formulas/substitute.php Regards, Kuldeep Singh On Wed, Sep 19, 2012 at 11:17 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, i want know

Re: $$Excel-Macros$$ subtitute function infirmation required

Please find below : http://blog.contextures.com/archives/2011/01/28/30-excel-functions-in-30-days-27-substitute/ Karan Singh On Wed, Sep 19, 2012 at 11:23 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi see below links:

$$Excel-Macros$$ BIN2DEC Function...

Hi Experts, What is use BIN2DEC function. Kindly tell me something with example. Regards, Kuldeep Singh -- 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

Re: $$Excel-Macros$$ BIN2DEC Function...

it coverts binary to decimal http://www.techonthenet.com/excel/formulas/bin2dec.php http://office.microsoft.com/en-us/excel-help/bin2dec-HP005209002.aspx On Thu, Sep 13, 2012 at 9:59 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Experts, What is use BIN2DEC function. Kindly tell me

Re: $$Excel-Macros$$ BIN2DEC Function...

- From: Kuldeep Singh naukrikuld...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, September 13, 2012 12:30:10 PM Subject: $$Excel-Macros$$ BIN2DEC Function... Hi Experts, What is use BIN2DEC function. Kindly tell

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

C the attached file. ? u r missing. From: Kuldeep Singh naukrikuld...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, August 6, 2012 12:44 PM Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date Dear Lakshman, Require

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

-macros@googlegroups.com *Sent:* Monday, August 6, 2012 12:44 PM *Subject:* Re: $$Excel-Macros$$ Sumproduct function to get sum between two date Dear Lakshman, Require output value 4625000 your formula is not working. It's working fine. =SUMPRODUCT((A7:A24=E1)*(A7:A24=F1)*(F7:F24)) Regards

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

ok From: LAKSHMAN PRASAD lakshman_...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tuesday, August 7, 2012 11:53 AM Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date C the attached file. ? u r

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

-macros@googlegroups.com Sent: Saturday, August 4, 2012 4:02 PM Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date Dear experts, I need output of sum between two date by using of Sumproduct as below formula but the error is occur in fuction, please see attache sheet

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

: http://www.gaursonsindia.com/ -- *From:* Ashish Bhalara ashishbhalar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Saturday, August 4, 2012 4:02 PM *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two date Dear experts, I need

$$Excel-Macros$$ Sumproduct function to get sum between two date

Dear experts, I need output of sum between two date by using of Sumproduct as below formula but the error is occur in fuction, please see attache sheet. =SUMPRODUCT(A7:A23E1)*(A7:A23F1)*(F7:F23) Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is

RE: $$Excel-Macros$$ Sumproduct function to get sum between two date

=SUMPRODUCT((A7:A23=E1)*(A7:A23=F1)*(F7:F23)) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 04 August 2012 4:02 To: excel-macros@googlegroups.com Subject: $$Excel-Macros

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

@googlegroups.com *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two date ** ** Dear experts, ** ** I need output of sum between two date by using of Sumproduct as below formula but the error is occur in fuction, please see attache sheet. ** ** =SUMPRODUCT

$$Excel-Macros$$ Excel Function details collection required

Hi Members, I have required syntax and details of each excel function. Please provide me. thanks in advance. Divaker -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ Excel Function details collection required

Hi Divakar You can Download file from here http://www.xlfdic.com/ It will explain you most of the functions with examples and syntax Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 1:54 PM, Divaker Pandey divake...@gmail.com wrote: Hi Members, I have required syntax and details of

$$Excel-Macros$$ IF Function

How can we add so many conditions in IF function? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not

Re: $$Excel-Macros$$ IF Function

Hi Smitha, Can you please send sample file. So that we can help you. In If function you can add any function. Thanks, Naresh V On Wed, May 16, 2012 at 7:11 AM, Smitha S R sperdwo...@gmail.com wrote: How can we add so many conditions in IF function? -- FORUM RULES (986+

  1   2   >