Dear Vijay,
The easiest way to do that is to select the entire table and then Sort on
Multiple Criteria.
1) Quality (Largest to Smallest)
2) Achieved (Largest to smallest)
That would do the trick..
Hope that helps...
Cheers!
Andy
On Tue, Apr 24, 2012 at 11:01 AM, Vijay Mane wrote:
>
> Hi Exp
Hi Experts,
Please refer file for more information
I want to calculate top performer agent according to achieved target and
quality
If there are multiple agent with same achieved target and quality then
preference in ranking should go with quality
--
FORUM RULES (986+ members already BANNED for
I was going to ask about that when complete. Unquestionably you can.
On Mon, Apr 23, 2012 at 4:35 PM, Asa Rossoff wrote:
> Ok, great. If you want, I can take a look at your specific code and see if
> I come up with any better ideas.
>
> Asa
>
> -Original Message-
> From: excel-macros@go
Ok, great. If you want, I can take a look at your specific code and see if
I come up with any better ideas.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Domain Admin
Sent: Monday, April 23, 2012 1:47 PM
To: excel-macros@go
Modular code is natural to me. It is actually constructed that way.
The arrays are only used inside this procedure so
it was natural to create them there. And the procedure is not very
lone. To change the code to pass in an array to this procedure
means moving the creation of the arrays outside
The more modular you oranize things, breaking things into small tasks, the
likelier that this kind of issue will naturally be avoided.
Another potential solution is to use a class module to define an object that
represents an array. You create multiple references to the same object that
way. But
We have a *VERY URGENT* Requirement in for *Java Developer *in Tampa,
FL*.* Please let me know if you have any matching resumes for the
below mentioned position ASAP.
*Minimum qualifications:*
* *
*Java Developer*
*Location: *Tampa, FL
*Duration*: 12 months+
*No of openings:* 20
*Max Billi
That is clever. There is no way to split the sub that uses both, but
the parent to it could pass in one or the other
just to use for those parts. Currently working though and that would
move a fair amount of local code out to the
parent so probably wait until I am making the final version pretty
If you use a separate sub or function for the tasks that could apply to one
or the other array, VBA will by default actually pass the array "by
reference" and you have a single name to refer to that variable by in the
other function, without having to copy the array.
If you use a function, you cou
Haseeb / Maries
thank you very much I can always count on you both. It realy help me a lot.
Thanks a lot.
Pawel
From: Haseeb A
To: excel-macros@googlegroups.com
Sent: Monday, April 23, 2012 4:59 PM
Subject: Re: $$Excel-Macros$$ sequence help needed
Hello
Hi,
Change to your settings.
It will list the content of your text file line by line, to Excel row by
rows. You have to list the id to lookup for in another worksheet.
Then you can use a left formula and vlookup to see what if id's match ids
in another worksheet.
Sub DialogDossier3()
Dim wb As
On 4/18/12, dguillett1 wrote:
> This will do for one. Adapt for the other. See attached
> Option Explicit
>
> Sub FindAccountInTallySAS()
> Dim i As Long
> Dim mf As Range
>
> For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row
> With Sheets("Tally")
> Set mf = .Columns("e").Find(What:=Cells(i, "c"),
Hi Pascal/Kris
Kris I did not see your mail before, only when pascal said he likes kris
code then his own then only I checked for your mail, yes I tried and
working fine, very short coding, I can understand why pascal was telling
he likes your code retrieving data speed wise your data comes fas
Thanks. I do have to have both arrays. Each contains all the data
for a different stock during a window of time. Comparisons are being
made across the data for that full calendar range. But depending on
this condition I want to extract a couple of values for each day
always from one array or t
Ok,
You can use this One:
Private Sub TextBox1_GotFocus()
Me.ListBox1.Visible = True
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.ListBox1.Visible = False
End Sub
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
Is your list box not hiding when you select other things except text box?
Is your macros enable?
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Mon/2012 07:55
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Mac
Siraj,
I don't want to be modest, I told you I'm not happy with the code I
provided you. To be honest Kris's code is a lot more about Excel ojects and
methods and if you learn this you could some other things on your own that
apply to Excel. Learn about resize it seems to be very useful when dea
Thanks for quick response,
I think you interpret my question wrong.
please read it again.
I want a feature in it if user click any where on sheet except textbox
orand listbox. listbox should be hide.
user should able to input data in textbox as well as select item in
listbox. but if he click o
HI
Please find the attached Sheet
I use Two Events of Text Box
1) Got Focus
2) Lost Focus
At GotFocus List Box is being Visible and at lost Focus List box will be
invisible
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf
Hi Deba,
Excel Does not need any other software to Write macros, you can find the
code window with in Excel By pressing ALT+F11, you need to insert a Module
Form insert module in VBE (Visual Basic Editor) , here you write your macro
and Function procedures.
Example : Sub Procedure
Sub
My latest adobe update seems to have an option, under tools, to convert to word
or excel
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Monday, April 23, 2012 8:52 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Help neede
Hi Pascal
Excellent
Thank you very much, its working fine now... This is what I needed.
Once again thank you for your help
Siraj
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of bpascal123
Sent: Monday, April 23, 2
Hi Siraj,
Insert : Set wb = ThisWorkbook between Sub Clear() and set ws
Pascal
On Monday, April 23, 2012 12:50:13 PM UTC+1, Siraj Momin (BTG) wrote:
>
>
>
> Dear Pascal,
>
>
>
> Its giving an error, anyway I recorded the macro and I am using that, just
> for knowledge purpose if you can clear
Hi
Can be done by VBA, please share your text file sample
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pavan Kumar
Sent: Apr/Mon/2012 05:48
To: excel-macros
Subject: $$Excel-Macros$$ - Compare two batch Files( Text File
No
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shekhar Sharma
Sent: Apr/Mon/2012 05:22
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to
Excel file via VBA
Hi
Thanks for the link, howev
We have a *VERY URGENT* Requirement in for *Java Developer *in Tampa,
FL*.* Please let me know if you have any matching resumes for the
below mentioned position ASAP. **
*Minimum qualifications:*
* *
*Java Developer*
*Location: *Tampa, FL**
*Duration*: 12 months+
*No of openings:* 20
*Max
Have you tried my code ?
Kris
--
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 be answered.
2) Don
*Dear Experts,
Can you please tell me how to run a macros and what is the functions of
running a macros ??. please guide me to run a macros !!. is there any
software to create macros code and is there any software to create very
long formula of excel. ? thanks in advance.
*
Thanks & Regards,*
Hi,
Try below code,
Sub CompareWorksheets(ws1 As Worksheet, ws2 As Worksheet)
Dim r As Long, c As Integer
Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer
Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String
Dim rptWB As Workbook, DiffCount As Long
Application.ScreenUpdatin
HI Team,
Request you help in getting a VBA code to compare two text files for
the difference and the difference needs to be populated in excel with
both the file values(Only different values as the files are huge) and
line number (Optional)
Regards,
Pavan Kumar G
--
FORUM RULES (986+ members al
HI Team,
Request you help in getting a VBA code to compare two text files for
the difference and the difference needs to be populated in excel with
both the file values(Only different values as the files are huge) and
line number (Optional)
Regards,
Pavan Kumar G
--
FORUM RULES (986+ members al
Hi
Thanks for the link, however is it possible to do this job via VBA?
Regards
Shekhar Sharma
On Fri, Apr 20, 2012 at 8:33 PM, ChilExcel wrote:
> Please see
> http://www.minipdf.com/
>
> I tried it and it works fine ...jpg at xls
>
> Chilexcel
> 2012/4/20 Shekhar Sharma
>
>> Hey Kris,
>>
>>
Why use c++ instead of java
On 4/21/12, Airen wrote:
> Hi All,
>
> I am planning to build a forecasting & network optimization product.
> Currently I am working in a company & this is my personal part time
> project. Any one interested in this project can contact me. Currently, I am
> thinking t
Hi Experts, I want to learn about Gauge Chart in excel please send me training
details with examples and template to work.Dear excelmacros ! Get Yourself a
cool, short @in.com Email ID now!
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Usually I would use one array. Arrays can hold lots of data, but they are
not objects, and so cannot have multiple references. You could
theoretically "hack into" the data for a new variant and point it to the
same array using the Windows API, but this seems like a dangerous idea to
me. VBA work
35 matches
Mail list logo
