Re: $$Excel-Macros$$ CONDITIONAL SUM

Dear Ashok, You can also use.. *=SUM(IF(MONTH(A2:A7)=D3,B2:B7,""))* with CSE(Ctrl+shift+enter) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Mon, Apr 2, 2012 at 1:25 PM, ASHOK PHALKE wrote: > Hi

Re: $$Excel-Macros$$ Look up and Auto Update ?

Hello Maries Thanks for the express fast reply :-) This works beautifully for me and exactly as I had hoped for. Thanks a lot. Appreciate it. Thanks Ashish Pradhan On 03-04-2012 02:11, Maries wrote: Hi, PFA. Regards, MARIES. On Mon, Apr 2, 2012 at 9:27 PM, Ashish Pradhan

$$Excel-Macros$$ Re: CONDITIONAL SUM

FYI, If you have blank cells or zero in a date column & corresponding column has numbers MONTH function will sum those numbers if the Month in A1 is 1. because in excel blank & zeros consider as Jan (in month case) To avoid this this need to use a another condition like (Sheet1!A2:A200<>"") or

$$Excel-Macros$$ Re: Format Conversation Question

That's works pefectly Haseeb. Thanks !! On Monday, April 2, 2012 8:17:30 PM UTC-4, Haseeb A wrote: > Hi, > > In a an adjustent cell try to multiply with 24 & round by 3 > > =ROUND(A1*24,3) > > Change A1 to TOI cell. > > ___ > HTH, Haseeb > -- FORUM RULES (986+ members already BANNE

$$Excel-Macros$$ Re: Format Conversation Question

Hi, In a an adjustent cell try to multiply with 24 & round by 3 =ROUND(A1*24,3) Change A1 to TOI cell. ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

$$Excel-Macros$$ Re: Count formula

Hello Shrini, =COUNTIF(D:D,">="&StartDate)-COUNTIF(D:D,">="&EndDate+1) Or, =SUMPRODUCT(COUNTIF(D:D,">="&IF({1,0},StartDate,EndDate+1))*{1,-1}) this way able to use whole column reference in SUMPRODUCT Change StartDate & EndDate to cell reference ___ HTH, Haseeb -- FORUM RULES (986+

Re: $$Excel-Macros$$ Count formula

Hi, Try, below shown Array formula. (Apply with CSE) =SUM((--INT(D7:D955)>=H13)*--(INT(D7:D955)<=H14)) Conditions, H13-Start Date & H14-End Date Regards, MARIES On Mon, Apr 2, 2012 at 11:47 AM, LAKSHMAN PRASAD wrote: > Dear Shrini** > Plz find out solve attach file. > Regards > LAKS

Re: $$Excel-Macros$$ Format Conversation Question

Hi, Try below formula for TOI values. =TEXT(A1,"h:mm AM/PM") Regards, MARIES. On Mon, Apr 2, 2012 at 1:40 AM, qcan wrote: > > > Hi, > > There is probably a very simple solution here, but I am stumped. > > In this link below, you will see a table that has a field called "TOI" > (abbreviation

Re: $$Excel-Macros$$ Add-in creation in excel 2007

Thanks SAM. Let me check it... On Tue, Apr 3, 2012 at 12:16 AM, Sam Mathai Chacko wrote: > The Custom UI Editor Tool is used to modify the XML tag of the custom UI > xml files on an office application file like Excel,Word, PPT, etc. > > Quite a few examples can be found at http://www.excelfox.com

Re: $$Excel-Macros$$ Re: format a cell

Hi Haseeb, Great Solution... On Mon, Apr 2, 2012 at 1:54 AM, pawel lupinski wrote: > Hi Again, > > Thanks again, it's all working, I have a lot to learn what is great, > you've shown me the magic. > > thanks > > Pawel > >-- > *From:* pawel lupinski > *To:* "exce

Re: $$Excel-Macros$$ Add-in creation in excel 2007

The Custom UI Editor Tool is used to modify the XML tag of the custom UI xml files on an office application file like Excel,Word, PPT, etc. Quite a few examples can be found at http://www.excelfox.com/forum/f10/ Regards, Sam Mathai Chacko On Tue, Apr 3, 2012 at 1:23 AM, Maries wrote: > Hi Raj,

Re: $$Excel-Macros$$ Add-in creation in excel 2007

Hi Raj, Check below link, http://jackmcintyre.net/how-to-add-macros-to-the-excel-2007-ribbon/ Dear Friends, Anyone give more details about Custom UI Editor Tool. >From above link, I came to know we required Custom UI Editor Tool

Re: $$Excel-Macros$$ Add-in creation in excel 2007

This link will tell you how to add a tab in Excel http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/?highlight=ribbon Regards, Sam Mathai Chacko On Mon, Apr 2, 2012 at 11:40 PM, Rajan_Verma wrote: > I think u should create custom menu to display that in Ribbon > > ** ** > >

$$Excel-Macros$$ RE: Color the Sum Range

Hi Mohammed, There are several possibilities that come to mind. You can try the following approach, or if this does not do what you want, provide a sample file and I/we will try to give you a different suggestion for your specific situation. 1. Remove all existing subtotals, totals, and

RE: $$Excel-Macros$$ Add-in creation in excel 2007

I think u should create custom menu to display that in Ribbon Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Raj Mahapatra Sent: Apr/Mon/2012 11:30 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Add-in creation in excel 2007

RE: $$Excel-Macros$$ Add-in creation in excel 2007

Hi Add-in will not looks like a opened file .. it will installed in your excel application, if you want to see you add-ins is installed properly .. you can press ALT +I , a dialogue box will open which will show all add-in available for you application.. you can use the macro written in that add-

Re: $$Excel-Macros$$ Add-in creation in excel 2007

Dear Raj, Please visit here. http://www.ozgrid.com/VBA/excel-add-in-create.htm -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra wrote: > hi group, > > i

Re: $$Excel-Macros$$ Add-in creation in excel 2007

sam, how would i get that add in as a tab in ms excel Thanks & Regards Rajesh Mahapatra On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko wrote: > Add-ins are designed to run in the background, and hence the file will not > be visible when you open it. If you go to the VBE window, you could >

Re: $$Excel-Macros$$ Add-in creation in excel 2007

Add-ins are designed to run in the background, and hence the file will not be visible when you open it. If you go to the VBE window, you could actually see that the vba project for your add-in is shown. Sam Mathai Chacko On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra wrote: > hi group, > > i wan

$$Excel-Macros$$ Look up and Auto Update ?

Hello I need a bit of a help with the attached excel file. (Formula would be best as I want to avoid the use of Macros / VBA) The attached excel file has two sheets: Cheque Entries Sheet: I shall be inserting data in Columns E, F, G, H and I on a regular basis. (Entries shall also be made in

$$Excel-Macros$$ Add-in creation in excel 2007

hi group, i wants to create addin in excel. i have created a addin using below steps, but it is not working. 1. in new workbook, i have insert a module and macro codes in it. 2. then saved the same workbook using ".xlam" extension. 3. when i opens the same add in in new excel. it does not op

Re: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816

This works Workbooks.open(YourFilePath) Thank you, Alex On Monday, April 2, 2012 9:48:01 AM UTC-4, Don Guillett wrote: > > One way to learn is to record a macro while doing manually > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Kremstep

RE: $$Excel-Macros$$ Re: Formula to Extract Unique Values :

Ok Got it.. thanks From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Apr/Mon/2012 08:16 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Formula to Extract Unique Values : Insert a row before Row 1. On Monday, 2 April 2012

Re: $$Excel-Macros$$ Re: Formula to Extract Unique Values :

Insert a row before Row 1. On Monday, 2 April 2012 20:06:06 UTC+5:30, Rajan_Verma wrote: > > Hi krish > > Please see attached sheet..I am unable to understand y its giving > duplicate to you only > > > > Rajan. > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@google

RE: $$Excel-Macros$$ Re: Formula to Extract Unique Values :

Hi krish Please see attached sheet..I am unable to understand y its giving duplicate to you only Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Apr/Mon/2012 07:59 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ R

Re: $$Excel-Macros$$ Re: Formula to Extract Unique Values :

PFA. Kris On Monday, 2 April 2012 19:51:01 UTC+5:30, Rajan_Verma wrote: > > Hi Krishna, > > Can you share a scenario where its giving duplicates? > > > > Rajan. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Kris > *Sent:* Apr/Mon/2012

RE: $$Excel-Macros$$ Re: Formula to Extract Unique Values :

Hi Krishna, Can you share a scenario where its giving duplicates? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Apr/Mon/2012 07:42 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Formula to Extract Unique Values :

$$Excel-Macros$$ Re: Formula to Extract Unique Values :

Hi Rajan, It gives duplicates as well. You may try this shorter one. In E2 and copied down, =INDEX(Range,MATCH(0,COUNTIF($E$1:E1,Range),0)) Array formula. Kris On Monday, 2 April 2012 19:19:58 UTC+5:30, Rajan_Verma wrote: > > > > Hi group, > > I have just created formula to extract unique

RE: $$Excel-Macros$$ CONDITIONAL SUM

Hi Please find attached workbook Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ASHOK PHALKE Sent: Apr/Mon/2012 01:26 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ CONDITIONAL SUM Hi,Please help me. I have following Data

Re: $$Excel-Macros$$ CONDITIONAL SUM

My Try, Array formula, {=SUM(--(MONTH(Sheet1!A2:A7)=A1)*Sheet1!B2:B7)} Regards, MARIES. On Mon, Apr 2, 2012 at 5:47 PM, dguillett1 wrote: > =sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200 > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread tit

RE: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816

Workbooks.open(YourFilePath) Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kremstep Sent: Apr/Mon/2012 09:50 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816 Say I want to open a fi

$$Excel-Macros$$ Formula to Extract Unique Values :

Hi group, I have just created formula to extract unique List from a given Range, it's an array formula. Just sharing with group J =IFERROR(INDEX(Range,SMALL(LARGE(--(COUNTIF(INDIRECT("A1:A" & ROW(Range)),Range)=1)*ROW(Range),ROW(INDIRECT("1:" &SUM(1/COUNTIF(Range,Range),ROW(INDIRECT

Re: $$Excel-Macros$$ vlookup with more than one value

If desired, reply directly to me with your file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: rajeyssh Sent: Monday, April 02, 2012 2:08 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup with more than one value I am sending you excel s

Re: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816

One way to learn is to record a macro while doing manually Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Kremstep Sent: Sunday, April 01, 2012 11:19 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816 Say

Re: $$Excel-Macros$$ CONDITIONAL SUM

for January use 1 in cell a1 =sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ASHOK PHALKE Sent: Monday, April 02, 2012 2:55 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ CONDITIONAL SUM Hi,Pl

RE: $$Excel-Macros$$ format a cell

# \ : ## Dear Rajan use this, Regards, Muneer, CC... -- 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 att

$$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816

Say I want to open a file with the below location or open the below link. What is the VBA code for this ? C:\Users\user\Desktop\leads.xls or open this link C:\Users\user\AppData\Local\Google\Chrome\Application ty, Alex -- FORUM RULES (986+ members already BANNED for violation) 1) Use c

$$Excel-Macros$$ CONDITIONAL SUM

Hi,Please help me. I have following Data Sheet1 Sheet2 Date Amount Month ( I am storing this field on seperate sheet),*I need formula to sum for the spcific Month,changing value of month in Sheet2*. 01/04/2012106 02

RE: $$Excel-Macros$$ format a cell

It's a custom format for 532 to covert in 5:32 Please try #":"## Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: Mar/Tue/2012 07:36 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ format a cell Hi All,

Re: $$Excel-Macros$$ Count formula

Dear Shrini Plz find out solve attach file. Regards LAKSHMAN From: Shrinivas Shevde To: excel-macros@googlegroups.com Sent: Monday, April 2, 2012 12:44 PM Subject: $$Excel-Macros$$ Count formula Dear all , I have a software which takes the reading for temp. I

$$Excel-Macros$$ Last Visit Invoive Details with formula

Dear All, Could you please help me with a formula? Attached is a sample file where in I need in column (W, X & Y) Invoice date, Invoice Number & Inv. Amount for each cab's previous last visit. Similarly I need in column (Z, AA & AB) Invoice date, Invoice Number & Inv. Amount for each cab's pre

Re: $$Excel-Macros$$ vlookup with more than one value

I am sending you excel sheet after filtering only gold, but exchange provide daily bhav copy of all the commodities and i want to pick out near months commodities like gold, silver, copper and many more so i asking you how to put vlookup in gold. thanks On Friday, March 30, 2012 8:39:43 PM UTC