Re: $$Excel-Macros$$ How to calculate Days and Time.

Please ignore.. showing wrong answer On Wed, Aug 1, 2012 at 11:15 AM, vijayajith VA wrote: > Hi kumar, > > Try this.. > > =DATEDIF(A3,E3,"md") > =TEXT(B3+F3,"[HH]:MM") > > > On Tue, Jul 31, 2012 at 11:48 PM, xlstime wrote: > >> PFA THE ATTACHED MAY BE SOLUTION >> >> >> >> On Tue, Jul 31, 2012 at

Re: $$Excel-Macros$$ How to calculate Days and Time.

Hi kumar, Try this.. =DATEDIF(A3,E3,"md") =TEXT(B3+F3,"[HH]:MM") On Tue, Jul 31, 2012 at 11:48 PM, xlstime wrote: > PFA THE ATTACHED MAY BE SOLUTION > > > > On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar > wrote: > >> Dear Champs, >> >> I need to consider the time difference between both the

Re: $$Excel-Macros$$ Excel 2010 Remove Duplication

thanks Kuldeep I was rather showing an abnormal function or may be bug. When tried with a macro the results seen erroneous so manually checked what happened... Mine is more of a data entry requirement than reporting so each time these cells need alteration and summarizing... YOurs..sajay On T

$$Excel-Macros$$ regarding public const

Hi Gurus, Please could you explain what is the use of Public & public const in vba macros. could you provide me one simple example... Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

Re: $$Excel-Macros$$ Kindly tell me about "T", & "N" Formulas with examples. and What is exact use for this formulas.

Thanks a ton Sir. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 31, 2012 at 11:49 PM, NOORAIN ANSARI wrote: > Dear Kuldeep, > > T use

Re: $$Excel-Macros$$ Re: Please tell me more about Areas Function with example.

Thank you Ashish G. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 31, 2012 at 11:30 PM, ashish koul wrote: > visit > > http://msdn.mi

Re: $$Excel-Macros$$ a vlookup type function

Dear comkav, You can aslo use sumproduct =sumpoduct((rang1=ctr1)*(range2=ctr2)*(outputrange)) Sent from BlackBerry® on Airtel -Original Message- From: colmkav Sender: excel-macros@googlegroups.com Date: Tue, 31 Jul 2012 12:58:32 To: Reply-To: excel-macros@googlegroups.com Subject: $$

Re: $$Excel-Macros$$ a vlookup type function

Try Sumifs CA Kantilal Badale On Wed, Aug 1, 2012 at 1:28 AM, colmkav wrote: > Hi, I need a vlookup type function to return the value but only where more > than 1 field are the same > > eg > > client dateDebt > Jane 4/5/12 £50 > Jabe 2/5/12 £22 > > So I want to get the debt value w

$$Excel-Macros$$ a vlookup type function

Hi, I need a vlookup type function to return the value but only where more than 1 field are the same eg client dateDebt Jane 4/5/12 £50 Jabe 2/5/12 £22 So I want to get the debt value where Jane is the client and the date is 2.5.12 (ie £22) how can I achieve this? -- FORUM RULES

$$Excel-Macros$$ Re: Format Shape Style Dialog in XL2007, 2010

Thanks. I'm not sure I could explain my problem properly. I wish to invoke (using VBA) "Format Shape" built-in DIALOGUE - the one you get by right-clicking on an autoshape placed on a worksheet. D On Sunday, 29 July 2012 06:12:56 UTC+1, TJ wrote: > > Maybe this will help? > http://peltiertech

Re: $$Excel-Macros$$ Workdays formula help required

WORKDAY Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected de

Re: $$Excel-Macros$$ Please tell me more about Areas Function with example.

In Excel, the *Areas* function returns the number of ranges in a reference. The syntax for the *Areas* function is: Areas( reference ) *reference* is a range of cells. If you specify more than one range, you must surround your ranges with brackets. For Example: Let's take a look at an example:

Re: $$Excel-Macros$$ Segregation of short term, long term capital gain and average rate of share

Dear Sagar, Please share a sample workbook for more clearity. On Tue, Jul 31, 2012 at 10:18 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear friends, > > I had done 500 share trading transaction now I want to know the short term > and long term capital gain. > I want a formu

Re: $$Excel-Macros$$ Kindly tell me about "T", & "N" Formulas with examples. and What is exact use for this formulas.

Dear Kuldeep, T use for Text and N use for Number T like =T("Abc") revert ABC =T(123) revert blank N Like =N(124) revert 124 =N("abc") revert 0 On Tue, Jul 31, 2012 at 9:54 PM, Kuldeep Singh wrote: > > Hi Experts, > > Kindly tell me about "T", & "N" Formulas with examples. and What is exact >

Re: $$Excel-Macros$$ How to calculate Days and Time.

PFA THE ATTACHED MAY BE SOLUTION On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar wrote: > Dear Champs, > > I need to consider the time difference between both the countries. I want > to calculate the overall time consumed for the dispatch to be delivered, > kindly find the attached example sheet

Re: $$Excel-Macros$$ get.cell argument

Dear Santosh, Please see the attached sheet for Get.cell function. On Tue, Jul 31, 2012 at 11:00 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > I would like to know how many "type num" are there which are used in > Get.cell argument and what are their functions. > >

Re: $$Excel-Macros$$ How to calculate Days and Time.

Dear Champs, I need to consider the time difference between both the countries. I want to calculate the overall time consumed for the dispatch to be delivered, kindly find the attached example sheet of query. Thanks Ashish On 31 July 2012 10:58, ashish koul wrote: > can you attach the sample

Re: $$Excel-Macros$$ How to calculate Days and Time.

Dear Champs, I need to consider the time difference between both the countries. I want to calculate the overall time consumed for the dispatch to be delivered. Thanks Ashish On 30 July 2012 11:36, Sam Mathai Chacko wrote: > Either way, you need to consider the time difference between both the

Re: $$Excel-Macros$$ Re: Please tell me more about Areas Function with example.

visit http://msdn.microsoft.com/en-us/library/office/aa213698(v=office.11).aspx http://msdn.microsoft.com/en-us/library/aa174786(v=office.11).aspx http://roymacleanvba.wordpress.com/2010/07/22/multi-area-ranges/ On Tue, Jul 31, 2012 at 11:17 PM, Prince Dubey wrote: > hi Kuldeep' > > You can see

Re: $$Excel-Macros$$ How to calculate Days and Time.

can you attach the sample file On Tue, Jul 31, 2012 at 11:26 PM, kumar.ashish861 wrote: > Dear Champs, > > I need to consider the time difference between both the countries. I want > to calculate the overall time consumed for the dispatch to be delivered. > > > Thanks > Ashish > > > > > On Monda

Re: $$Excel-Macros$$ How to calculate Days and Time.

Dear Champs, I need to consider the time difference between both the countries. I want to calculate the overall time consumed for the dispatch to be delivered. Thanks Ashish On Monday, July 30, 2012 10:55:20 AM UTC-7, Paul Schreiner wrote: > > What kind of solution are you looking for? > A

$$Excel-Macros$$ Re: Please tell me more about Areas Function with example.

hi Kuldeep' You can see my thread about the areas function that i had started on 29 of july. regards prince On Tuesday, 31 July 2012 10:05:28 UTC+5:30, Kuldeep Singh wrote: > > > Hi Experts, > > Please tell me more about Areas Function with example. and how to use in > excel workbook. > > Reg

$$Excel-Macros$$ Re: Kindly tell me about "T", & "N" Formulas with examples. and What is exact use for this formulas.

Hi Kuldeep, T function generally used to check for weather the argument passed in it is a text or not , If it is a text then it return that text else it return blank, For example. =T("12") will return 12 and if i write the same T(12) will return blank. Now About N function. N function is u

Re: $$Excel-Macros$$ get.cell argument

visit http://www.mrexcel.com/forum/showthread.php?20611-Info-only-get-cell-arguments On Tue, Jul 31, 2012 at 11:00 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > I would like to know how many "type num" are there which are used in > Get.cell argument and what are

$$Excel-Macros$$ get.cell argument

Hi Group, I would like to know how many "type num" are there which are used in Get.cell argument and what are their functions. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread title

$$Excel-Macros$$ Segregation of short term, long term capital gain and average rate of share

Dear friends, I had done 500 share trading transaction now I want to know the short term and long term capital gain. I want a formula for auto averaging of share price. If I do this thing manually then it will take 10hours or more. Kindly help me if any solution availble for the same. Thanks in

$$Excel-Macros$$ Have an idea to improve excel ? Submit here.

Dear members, Last year,I started an initiative to collect ideas for improvements in excel. The initiative received the great response of 190 ideas and 1348 votes. If you still have ideas and new features that you would like to see in future version of MS Excel, you can submit the same here

$$Excel-Macros$$ Kindly tell me about "T", & "N" Formulas with examples. and What is exact use for this formulas.

Hi Experts, Kindly tell me about "T", & "N" Formulas with examples. and What is exact use for this formulas. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really ne

Re: $$Excel-Macros$$ Macro is not doing the right formatting - need help

Partial clean up of your macro Sub Subs_T_Complete() With Sheets("New") Sheets("Fixed").Range("F1:F600").Copy .Range("F1").PasteSpecial Paste:=xlPasteFormulas, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=False Sheets("Fixed").Range("H1:H600").Copy .Range("H1").PasteSpeci

Re: $$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

Hi Hilary Lomotey you have Custom Cell Formatting _(* #.##0,00_);_(* (#.##0,00);_(* "-"??_);_(@_) you must change by: _(* #.##0,00_);_(* (#.##0,00);_(* ""??_);_(@_) or another of your choice Chilexcel 2012/7/31 Hilary Lomotey > thanks Dave > > > On Tue, Jul 31, 2012 at 12:48 PM, David Grug

Re: $$Excel-Macros$$ Macro is not doing the right formatting - need help

I would completely re-write your macro to simplify and remove selections but this solves your immediate problem Sub colorcolH() Columns("H").SpecialCells(xlFormulas, xlNumbers).Interior.ColorIndex = 6 End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: CA

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

Try find and replace use ~* . snapshot below [image: Inline image 1] On Tue, Jul 31, 2012 at 8:01 PM, NOORAIN ANSARI wrote: > Sorry Paul, > > I have not tested, You are right.(*) represent for all characters. > Thanks for nice advice > > On Tue, Jul 31, 2012 at 7:59 PM, Paul Schreiner wr

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

Hi, Replace ~* with L. Hope this will work. Thanks, Chandra Shekar B On Tue, Jul 31, 2012 at 4:31 PM, NOORAIN ANSARI wrote: > Sorry Paul, > > I have not tested, You are right.(*) represent for all characters. > Thanks for nice advice > > > On Tue, Jul 31, 2012 at 7:59 PM, Paul Schrein

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

Sorry Paul, I have not tested, You are right.(*) represent for all characters. Thanks for nice advice On Tue, Jul 31, 2012 at 7:59 PM, Paul Schreiner wrote: > Did you test this? > When I use this, it interprets (*) as a > wildcard representing ALL CHARACTERS > and results in: > L > L > L

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

Did you test this? When I use this, it interprets (*) as a wildcard representing ALL CHARACTERS and results in: L L L   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

Dear Amit, If you want output in same column, you can use Ctrl+H (Find and Replace) On Tue, Jul 31, 2012 at 7:09 PM, Amit Desai (MERU) wrote: > Dear Friends, > > ** ** > > Please note that I would like to have a formula that would remove * sign > from the text & will replace it by L. Foll

RE: $$Excel-Macros$$ Remove Extrict sign & replce by L

Thanks a lot Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: 31 July 2012 19:30 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Remove Extrict sign & replce by L Hi, Please Use This. =SUBSTITUTE(A1

Re: $$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

thanks Dave On Tue, Jul 31, 2012 at 12:48 PM, David Grugeon wrote: > You have a circular reference. The formulas in col W refer to a range > including the cell B34 which refers to cells in col W. > > I don't really understand quite what you are doing so I do not offer a > solution but I hope thi

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

Hi, Please Use This. =SUBSTITUTE(A1,"*","L",1) =SUBSTITUTE(A2,CHAR(42),"L") Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 31, 2012 at

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

Are you wanting a formula? or VBA solution? You can use this formula: =SUBSTITUTE(A1,CHAR(42),"L")   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

Have a look in the help index for SUBSTITUTE Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Amit Desai (MERU) Sent: Tuesday, July 31, 2012 8:39 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Remove Extrict sign & replce by L Dear Friends,

Re: $$Excel-Macros$$ Macro is not doing the right formatting - need help

You should, at least provide an .xlsM file with your macro and before/after examples of what you want. Why should we do extra work? I will then be happy to have a look. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: CAN Sent: Tuesday, July 31, 2012 8:17 AM T

$$Excel-Macros$$ Remove Extrict sign & replce by L

Dear Friends, Please note that I would like to have a formula that would remove * sign from the text & will replace it by L. Following is the sample data. Please help. Code Number Result needed 1234* 1234L 12456* 12456L 12appolo** 12appoloLL Best Regards, Amit __

$$Excel-Macros$$ Macro is not doing the right formatting - need help

I have a simple excel sheet (attached file) The file is sorted by date and it shows information about deposits made in a day. Sometimes a deposit might have more than 1 transaction, sometimes it is just one transaction. The data is as follows: Date, Unit ID, Amount & Check number (there othe

Re: $$Excel-Macros$$ Alternative to OR condition

:), I guess it all depends on the structure of the formula :), never used ISNA before, I use IFERROR for everything. 2012/7/31 Hilary Lomotey > insightful, thanks > > > On Tue, Jul 31, 2012 at 12:01 PM, Paul Schreiner > wrote: > >> interesting... >> I was just thinking that I use ISNA way too m

Re: $$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

You have a circular reference. The formulas in col W refer to a range including the cell B34 which refers to cells in col W. I don't really understand quite what you are doing so I do not offer a solution but I hope this will help you find one for yourself. Regards David Grugeon On 31 July 2012

Re: $$Excel-Macros$$ Alternative to OR condition

insightful, thanks On Tue, Jul 31, 2012 at 12:01 PM, Paul Schreiner wrote: > interesting... > I was just thinking that I use ISNA way too much and should think about > using ISERROR more to "keep it simple"! > > > *Paul* > > - > *“Do all the good you can, >

Re: $$Excel-Macros$$ Alternative to OR condition

interesting... I was just thinking that I use ISNA way too much and should think about  using ISERROR more to "keep it simple"!   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times

Re: $$Excel-Macros$$ Excel 2010 Remove Duplication

You can try this functions: Pivot Table Remove Duplicates Countif Vlookup any more.. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) Phone.: +91-120-4763789, Extn.: 789,9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environm

Re: $$Excel-Macros$$ Alternative to OR condition

IFERROR checks for:  #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. ISNA checks specifically for #N/A === The other difference is that ISNA (and ISERROR) only return true/false You would need to include it in an "IF" statement to define

Re: $$Excel-Macros$$ Alternative to OR condition

Most Welcome Bro.. On Tue, Jul 31, 2012 at 5:27 PM, Jorge Marques wrote: > Nice :), I use a lot IFERROR, I´ll do it with ISNA, keeping it simple. > thank you very much. > > > 2012/7/31 NOORAIN ANSARI > >> Dear Jorge, >> >> The #N/A error happens most often when a lookup function cannot find a >

Re: $$Excel-Macros$$ Alternative to OR condition

Nice :), I use a lot IFERROR, I´ll do it with ISNA, keeping it simple. thank you very much. 2012/7/31 NOORAIN ANSARI > Dear Jorge, > > The #N/A error happens most often when a lookup function cannot find a > result. You can manually remove the all of your #N/As or you can stop them > in your ori

Re: $$Excel-Macros$$ Alternative to OR condition

Dear Jorge, The #N/A error happens most often when a lookup function cannot find a result. You can manually remove the all of your #N/As or you can stop them in your original formula. A simple and effective way of trapping the #N/A errors and replacing them with whatever you would like is to use t

Re: $$Excel-Macros$$ Alternative to OR condition

Noorain what does exactly "ISNA"? I used +IFERROR(IF(MATCH($C6;$A$4:$A$11;0);D1;"");E1) is it the same principle for IFerror? 2012/7/31 Hilary Lomotey > Perfect, thanks Noorain, it works > > > On Tue, Jul 31, 2012 at 10:24 AM, NOORAIN ANSARI > wrote: > >> Hi Hilary, >> >> Please try it.. >> >>

Re: $$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

Office 2013 is operating on Windows 7 (x86 , 64bit ) and Windows 8 *ONLY*. On Tuesday, July 31, 2012 1:58:12 PM UTC+3, Annu wrote: > > Is it can run on winxp sp3 or not? > Regards, > Gawli Anil > > On Tue, Jul 31, 2012 at 4:15 PM, NOORAIN ANSARI > wrote: > >> Dear Joshep, >> >> Please see scre

$$Excel-Macros$$ Re: Shortcut key to Align Left, Right & Center in Excel

Hello , Anjali A very nice technique is you can customize your toolbar by going to Excel Option -> Customize -> select All Commands add what you want to Quick Access Toolbar. After that you can easily access them by pressing ALT + number showed below picture Example in the file attached. Ho

Re: $$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

Is it can run on winxp sp3 or not? Regards, Gawli Anil On Tue, Jul 31, 2012 at 4:15 PM, NOORAIN ANSARI wrote: > Dear Joshep, > > Please see screen shot... > > On Tue, Jul 31, 2012 at 10:16 AM, joseph camill > wrote: > >> Hi Noorain, >> >> Please help me understand, I may be wrong. I do not

$$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

Hello Again, There is something funny going on in the formula in the attached sheet. in column B34 i have written a formula INDEX($W$3:$W$667,MATCH(U3,$V$3:$V$667,0)) to pick up the value from a list however the outcome comes with a dash (-), however if i run formula evaluator, you can see it pick

Re: $$Excel-Macros$$ Alternative to OR condition

Perfect, thanks Noorain, it works On Tue, Jul 31, 2012 at 10:24 AM, NOORAIN ANSARI wrote: > Hi Hilary, > > Please try it.. > > *=+IF(ISNA(MATCH(C4,$A$4:$A$6,0)),E1,D1)* > Hope it help to you. > > see the attached sheet. > > -- > With Regards, > Noorain Ansari > http:// >

Re: $$Excel-Macros$$ Alternative to OR condition

Hi Hilary, Please try it.. *=+IF(ISNA(MATCH(C4,$A$4:$A$6,0)),E1,D1)* Hope it help to you. see the attached sheet. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclin

Re: $$Excel-Macros$$ Alternative to OR condition

Thnks Marques, but not sure i follow your suggestion, can you be more explicit. thanks On Tue, Jul 31, 2012 at 10:06 AM, Jorge Marques wrote: > Do you the C4 to CX if it founds the value on column A it returns D1 else > if the C4 to Cx isn´t on column A returns E1? > > > 2012/7/31 Hilary Lomotey

Re: $$Excel-Macros$$ Alternative to OR condition

Do you the C4 to CX if it founds the value on column A it returns D1 else if the C4 to Cx isn´t on column A returns E1? 2012/7/31 Hilary Lomotey > Hello Experts > > is there another way to write an OR formula . Example, i want to exempt > some people from say tax, so i list them and write a form

$$Excel-Macros$$ Alternative to OR condition

Hello Experts is there another way to write an OR formula . Example, i want to exempt some people from say tax, so i list them and write a formula that +IF(OR(C4=$A$4,C4=$A$5,C4=$A$6),D1,E1). But this can be painful if the list is long, i tried using +IF(C4=$A$4:$A$17,D1,E1), but it only gets it w

$$Excel-Macros$$ Excel 2010 Remove Duplication

Hi.. anobody noticed this? if you try to remove duplicate fields via "Data -> Remove Duplicates" in formulas the result is erroneous.. Just like this A BC 1 TEST1 =B1 2 TEST2 =B2 3 TEST3 =B3 4 TEST4 =B4 5 TEST2 =B5 6 TEST5 =B6 if we try to find duplicates in

Re: $$Excel-Macros$$ Excel Book Closed Macros

Any Suggestions outlook is open but excel 2007 is closed. Regards Pankaj On Fri, Jul 27, 2012 at 4:28 PM, Pankaj wrote: > Dear Gurus, > > Can we create a macro or how can we send mails if my excel book is closed. > > like i have data:-- > > Name Email IDDate

Re: $$Excel-Macros$$ Need Help !!!!

Hi All, Thanks for providing me valuable solution and also I am thankful for providing me guidelines of the forum. I am sorry I have not mentioned the exact subject line in the header which I had mentioned in the sheet itself. Sorry again and Thanks a ton !!! On Tue, Jul 31, 2012 at 8:58 AM, NO