Sorry Deepak, this is not the solution I want please read the text i written in
the attached file for complete understanding.
The main point of ranking is
1. Rank all the students which are pass. e.g. 1-4
2. After that rank all the students which are compartment e.g. 5-6
3. then rank the fail one.
On Aug 9, 1:57 pm, Chris Spicer wrote:
> Hi Jeffrey,
>
> Are you saying that you've written a custom function in VBA and when
> you use the function in the spreadsheet it references the drop down
> list? If this is the case your function should update when you change
> the drop-down list.
>
> I
On Tue, Aug 11, 2009 at 2:08 AM, Deepak Rai wrote:
> Hi,
>
> In the Developer Tools click on More Controls & then select Calender
> Control 12.0.
> Please follow the below steps to get the Calender Control:
>
> 1. Right Click on Menu Bar
> 2. Select "Customize Quick Access Toolbar.."
> 3. Select
Hi Anil,
Please find the attached sheet with answer of your query.
Regards,
Deepak Rai
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep wrote:
> I Need to calculate the range as per the criteria mentioned in attached
> file please help me.
>
> >
>
>
--
Thanks,
Deepak Rai
--~--~-~--~---
Hi,
In the Developer Tools click on More Controls & then select Calender Control
12.0.
Please follow the below steps to get the Calender Control:
1. Right Click on Menu Bar
2. Select "Customize Quick Access Toolbar.."
3. Select Customize option
4. In the Choose commands from drop down
5. Select D
the function is called "indirect".
Let's say that you have these values:
Cell A6 has 6
Cell A7 has 7 and is has a Range Name of "RName"
If you have a formula in B2: =INDIRECT(A2) * 5
then, in Cell A2 enter "A6", the value of B2 will then be 30 (6*5)
If you change A2 to read: "RName" , the value
Hi Prasad,
Mathematically 8.93hrs does not mean 8 hrs and 93 Minutes. Its 8 hrs and
0.93*60Mins. You can see it comes to 56 Minutes.
You can go ahead with Idrees solution or use the below formula (a bit
complex):
=TIME(INT(A3/60),MIN(((A3/60)-INT(A3/60))*60),)
Where A3 is the ce
Hi all,
I have a series of % values that can be either 0 or negative. I need
to know the maximum number of consecutive negative values in the
column. So having: -1%, 0%, -0.2%, -0.5%, -1%, -0.4%, 0% my result
should be 4.
Additional info, if it can be helpful: this is a cumulated returns
(drawdown
Hi all
i am using excel vba to send mails through outlook.. the sample code is as
below
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
' Application.Wait Now
Hi ShriNiwas
The macro which i have given already does the following,
1. splits the table into different sheets as per client
2. Saves the sheets as per client into new workbooks
3. these new workbooks are saved in the same folder where you are running
the code from...
now what additions do you w
Dear Dhananjay,
Please go thru the links below, this will give you some idea about the
custom formats.
http://www.ozgrid.com/Excel/CustomFormats.htm
http://www.ozgrid.com/Excel/excel-custom-number-formats.htm
Regards
Andy
On Sun, Aug 9, 2009 at 10:25 PM, Dhananjay Pinjan wrote:
> Hat's off Mas
Hi ALL.
How to use this calender in XL 2007.
Iqbal Shaikh
On 8/7/09, Ayushj wrote:
>
>
> Hi Shafiq,
>
> This is the awesome tip. Appreciate your knowledge. :)
> regards,
> Ayush Jain
>
> On Aug 7, 3:48 pm, shafiq online wrote:
> > Dear All,
> >
> > Here is a tip for pop up calendar in Exce
Dear Sandeep, could you elaborate your question a little more. May be with
one sample..
Regards,
Andy
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep wrote:
> Is there is anyway to use values as range in formula.
> Or is there is anyway to change values in range.
>
> Don't think for a vba solution i
Dear Sandeep, could you elaborate your question a little more. May be with
one sample..
Regards,
Andy
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep wrote:
> Is there is anyway to use values as range in formula.
> Or is there is anyway to change values in range.
>
> Don't think for a vba solution i
I Need to calculate the range as per the criteria mentioned in attached file
please help me.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Vid
15 matches
Mail list logo
