Re: $$Excel-Macros$$ Unique count for a date & between range

Amit, If you are looking to count unique Vehicles in a date & a period. here is one way: For a single date: =SUM(IF(FREQUENCY(IF(TEXT(H$4:H$9,"md")=TEXT(CabOutDate,"md"),IF(C$4:C$9<>"",MATCH(C$4:C$9,C$4:C$9,0))),ROW(C$4:C$9)-ROW(C$4)+1),1)) Change cabOutDate to your reference where is

RE: $$Excel-Macros$$ Re: Display numbers in Lakhs

Shucks. I was surprised to see, on re-opening the sample file I posted, that the number format had changed and the numebrs were displayed incorrectly. The problem I had with the XLS file also applies to the XLSX file equally. You can ignore my example attachment. Although I was able to us

RE: $$Excel-Macros$$ Re: Display numbers in Lakhs

I think it should work to give the right comma separation, but it does not round to Lakhs. For Lakhs plus Indian comma separation, try this one (tested in Excel 2010): [<-100]-"Rs."#\,##\,##0,,,%%;[<100]"Rs."#,##0,,,%%;"Rs."#\,# #\,##0,,,%% This one also supports negative numb

Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition

Sir, A while ago, you had sent me a file, [ which I am enclosing ] to convert the DATA file into MANY SHEETS depeding upon filter condition, That is V useful, but I would like to generate NewFIles [ instead of New Sheets in the same XL file, since, i want to email them [using AUTOmailer, but I

RE: $$Excel-Macros$$ Call a Function

Hi Matt, Glad to help. What was your solution? Moving the functions to a standard module instead of the class module? Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Matt Sent: Tuesday, April 10, 2012 6:03 PM To: excel-macros@googlegroups.com S

$$Excel-Macros$$ Re: Ask for help! Excel scatter chart issue.

On Tuesday, April 10, 2012 6:07:27 PM UTC+8, Excel_xxx wrote: > > as a common problem , we can only choose X,Y data to create a scatter > chart, > but usually we want alias names for the points (in 3rd column) > > I can only use VBA to change the data label for each points > but that's not what

Re: $$Excel-Macros$$ Call a Function

Thanks Asa. Your advice helped! I thought I tried it before but I guess I missed something and it works now. Tx again' Matt On Thursday, April 5, 2012 3:27:51 PM UTC-4, tag wrote: > > please see... > Sub or Function not defined (Visual Basic) > > A *Sub* or *Function* must be defined in o

Re: $$Excel-Macros$$ Could this loop be replaced by some range method?

Rajan the evaluate method did turn out to be the most efficient of the 3 methods I tried by a wide margin. Here is the code used which took only 13.7% of the time of the next best method and only 11.6% of the loop method. Pretty much as you described it but the Len funtion is not needed. I belie

Re: $$Excel-Macros$$ Macro to calculate amount

*Paul,* You are a star, Excellent. I got what I want. Thanks you very much for the help. Regards, Dilan *Rajan_Verma,* Thanks for the help. However your macro gives the correct answer in "Amount" Column, but as a numerical value(1250). I need the formula (C5*D5)on the Amount cell. Regards, Dilan

Re: $$Excel-Macros$$ Unique count for a date & between range

I do not believe I understand. Please define what you mean by "unique count" The formulae I supplied produce the results that you showed in your example, at least based on my "assumption" of the range you wish to evaluate. If what you're really asking for is a summary by date and date range, the

RE: $$Excel-Macros$$ Unique count for a date & between range

My friend I wanted to get unique count & not just simple count with condition. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 10 April 2012 23:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Uniqu

$$Excel-Macros$$ Request to remove from the group

Hi, Request to stop sending excel macros email on my email anwar.mun...@owb.com as I am unable to access the same. Thanks & Regards, Anwar Munshi Lead Coach OneWest Bank, FSB E-mail I.D. : anwar.mun...@owb.com -- FORUM RULES (986+ memb

RE: $$Excel-Macros$$ Need help in VBA

Hi, Can you share your Macro ? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of girish naik Sent: Apr/Tue/2012 10:28 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help in VBA Hi, I need to write a vba script wherein the m

$$Excel-Macros$$ Need help in VBA

Hi, I need to write a vba script wherein the macro will capture all the files present in windows registry(regedit).. i am able to capture the folder name present HK_LOCAL_MACHINE but not able to capture the files present in th folder. Please help me out with this. Thanks Girish -- FORUM RULES

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

Ok. Thanks rajan. On Tue, Apr 10, 2012 at 10:17 PM, Rajan_Verma wrote: > I think Text is a read only property here > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne > *Sent:* Apr/Tue/2012 10:16

RE: $$Excel-Macros$$ Need help !!!

I think Text is a read only property here Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Dayne Sent: Apr/Tue/2012 10:16 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help !!! Thanks Rajan It works so it mean

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

Thanks Rajan It works so it means that - we generally use text property in VB but in excel it takes value property. So is there many differences in terms of property and events in excel macro vba and simply vb ? On Tue, Apr 10, 2012 at 10:13 PM, Rajan_Verma wrote: > Use value property instead of

RE: $$Excel-Macros$$ Need help !!!

Use value property instead of Text From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Dayne Sent: Apr/Tue/2012 10:12 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help !!! Hi all, I have created small code but it is showing

$$Excel-Macros$$ Need help !!!

Hi all, I have created small code but it is showing error message as "Object required". *The code is -* Sub gen() If Sheet1.Range("A2").Value > 50 Then Sheet1.Range("B2").Text = "You have entered the value above 50" Else Sheet1.Range("B2").Text = "You have entered the value below 50" End If End Su

RE: $$Excel-Macros$$ Unique count for a date & between range

Please see the attached file Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Apr/Tue/2012 09:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Unique count for a date & between range Hi, Consider, Dates Range is A

$$Excel-Macros$$ Re: Unique count for a date & between range

Hello Amit, This will count the unique numbers in A:A =SUM(SIGN(FREQUENCY(A:A,A:A))) with just ENTER. ___ 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 P

Re: $$Excel-Macros$$ Unique count for a date & between range

Hi, Consider, Dates Range is A1:A10, Try this array formula, (Apply with Ctrl+Shift+Enter) =SUM(--(COUNTIF(A1:A10,A1:A10)=1)) Regards, MARIES. On Tue, Apr 10, 2012 at 8:07 PM, Amit Desai (MERU) wrote: > Dear All, > > ** ** > > Please help to calculate unique count for a date & for a dat

$$Excel-Macros$$ Unique count for a date & between range

Dear All, Please help to calculate unique count for a date & for a date range. Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely

Re: $$Excel-Macros$$ Macro to calculate amount

Try this macro then: Option Explicit Sub Add_sums()     Dim ShtNo, nRows, R     For ShtNo = 1 To Sheets.Count     Sheets(ShtNo).Select     nRows = ActiveCell.SpecialCells(xlLastCell).Row     For R = 4 To nRows     If (Sheets(ShtNo).Cells(R, "C").Value <> "") Then   

RE: $$Excel-Macros$$ Macro to calculate amount

Try this : Sub CacluateAmount() Dim rngQuantity As Range Dim rngResult As Range Dim rngRate As Range Set rngQuantity = Application.InputBox("Please Select Range of Quantity", , , , , , , 8) Set rngRate = Application.InputBox("Please Select Range of Rate", , , , , , , 8) Set rngResul

Re: $$Excel-Macros$$ Macro to calculate amount

If you REALLY need a macro, let me know. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Dilan De Silva Sent: Tuesday, April 10, 2012 8:47 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to calculate amount Dear experts, I need a macro for f

RE: $$Excel-Macros$$ Macro to calculate amount

=E5*C5*1 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Apr/Tue/2012 07:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to calculate amount There's no macro required. you can use a simple formula: =IF(C

Re: $$Excel-Macros$$ Macro to calculate amount

You just need to double click on the formual cell, the formula will be copied to the last data cell. On Tue, Apr 10, 2012 at 7:57 PM, Dilan De Silva wrote: > Paul, > Thank you for the reply. > If I used your answer, I have to paste it on each cell. Paste the formula > in a work book with more th

Re: $$Excel-Macros$$ Macro to calculate amount

Paul, Thank you for the reply. If I used your answer, I have to paste it on each cell. Paste the formula in a work book with more than 100 pages is time consuming. Therefore I need to apply the formula to all cells in one click. Thank you. Regards, Dilan On Tue, Apr 10, 2012 at 5:22 PM, Paul S

Re: $$Excel-Macros$$ Macro to calculate amount

There's no macro required. you can use a simple formula: =IF(C5>0,C5*E5,"") then copy this down...   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

$$Excel-Macros$$ Macro to calculate amount

Dear experts, I need a macro for following requirement. Please refer the attached Excel sheet. If there is a value in the cell C5(Quantity), formula of cell F5(Amount) should be =C5*E5 otherwise cell F5 should be blank. This should be repeat to each row which has value in Column C. Thank you. Re

RE: $$Excel-Macros$$ Re: Display numbers in Lakhs

Hi Follow the mention things : TO UNSUBSCRIBE Google Groups help on the subject: http://support.google.com/groups/bin/answer.py?hl=en &answer=46608 Key points thereof: Leave the group by any of these methods: . Re

Re: $$Excel-Macros$$ Re: Display numbers in Lakhs

Hi Abhishek sir, Can u plz exclude me from this group Sent on my BlackBerry® from Vodafone -Original Message- From: Abhishek Jain Sender: excel-macros@googlegroups.com Date: Tue, 10 Apr 2012 16:40:31 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Display n

RE: $$Excel-Macros$$ Solver in excel

As I study the solver, I feel this is elder brother of Goal Seek in Excel ,where we can change only one value with Goal seek , Using Solver we can provide many cell for adjusting value as per our scenario , Below is the Parameter required to solver , We can add many scenario to see different analy

RE: $$Excel-Macros$$ Re: Display numbers in Lakhs

It is not working in Excel 2010, I am not too good in custom format. Can you please do something with Excel 2010. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Abhishek Jain Sent: Apr/Tue/2012 04:41 To: excel-macros@googlegroups.com Subject:

RE: $$Excel-Macros$$ Ask for help! Excel scatter chart issue.

Hi Please attached sample file Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_xxx Sent: Apr/Tue/2012 03:37 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Ask for help! Excel scatter chart issue. as a common problem , we

Re: $$Excel-Macros$$ Solver in excel

Dear Deba, Please check below link,,,hope it help to understand SOLVER. http://blogs.office.com/b/microsoft-excel/archive/2009/09/21/new-and-improved-solver.aspx -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacro

$$Excel-Macros$$ Solver in excel

*Hi Expert, Can somebody please guide me what is the use of solver in excel by the help of example ?? with different different criteria !!!.. Thanks in advance. * Thanks & Regards,* * *Deba Ranjan P*** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate th

Re: $$Excel-Macros$$ Re: Display numbers in Lakhs

Right Click on cell...choose format cells > Custom > under the "Type:" use this - *[>=1000]##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0 * On Tue, Apr 10, 2012 at 4:11 PM, Prabhu wrote: > Hi, > > Plz help to solve the below Query. > > > > On Sunday, January 29, 2012 11:12:26 AM UTC+5:30, Pr

$$Excel-Macros$$ Re: Display numbers in Lakhs

Hi, Plz help to solve the below Query. On Sunday, January 29, 2012 11:12:26 AM UTC+5:30, Prabhu wrote: > > Hi, > > In Excel I needs to convert numbers in to indian format and the value > should divided by lakhs and display in Lakhs. > > Example Rs.924104600.90 should reflect as Rs.9,241(in la

$$Excel-Macros$$ Re: Display numbers in Lakhs

On Sunday, January 29, 2012 11:12:26 AM UTC+5:30, Prabhu wrote: > > Hi, > > In Excel I needs to convert numbers in to indian format and the value > should divided by lakhs and display in Lakhs. > > Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian > format) > > Plz help. >

$$Excel-Macros$$ Ask for help! Excel scatter chart issue.

as a common problem , we can only choose X,Y data to create a scatter chart, but usually we want alias names for the points (in 3rd column) I can only use VBA to change the data label for each points but that's not what I want, My chart has hundreds of points and if I show all data labels, It lo

Fwd: $$Excel-Macros$$ Fwd: regarding pivot table problem

Dear Sir / Madam, I am facing a problem regarding pivot table. Please go through the mail . Waiting for your reply. Thanking you Regards, Sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Tue, Apr 10, 2012 at 10:24 AM Subject: $$Excel-Macros$$ Fwd: regarding pivo