Dear Mr. Atul,
But formula can not read text "comm" for taking value of %, it is taking the
same on fifo basis.
Regards,
Kamlesh
On Thu, Oct 23, 2008 at 2:35 PM, SINGHAL, ATUL. <[EMAIL PROTECTED]> wrote:
> Hi Abhi,
>
> I think, the enclosed file can solve your problem.
>
>
> Regards
>
> CA. At
Hi,
Use Pivot table.
check the attachment.
On Thu, Oct 23, 2008 at 12:14 PM, Santhosh Kumar M K <[EMAIL PROTECTED]>wrote:
> Dear Friends,
>
> Please, solve my problem
>
> Find the attached data..
>
> How to calculate total premium amount for a single personusing formula
> / function?
Thanks dude,
It worked wonderfully!!
Regards
Abhijit
_
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of SINGHAL, ATUL.
Sent: Thursday, October 23, 2008 2:36 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
Hi
Hi,
Just formatting a cell as number after the cell has received data, does not
change the format of the data.
If all your data is numeric, then follow these steps to actually change your
data to numbers:
1. Select Range A71:A1000
2. Format as number.
3. Enter 1 into an unused cell, then right-
see attachhed file for your query
On Thu, Oct 23, 2008 at 12:14 PM, Santhosh Kumar M K <[EMAIL PROTECTED]>wrote:
> Dear Friends,
>
> Please, solve my problem
>
> Find the attached data..
>
> How to calculate total premium amount for a single personusing formula
> / function?
>
>
Hi All,
I have an issue while using concatenate formula, Can any one of you help me
out with this:
Query:
Column A : MS
Column B : Excel
Column C : 24- Oct-08 ( formated as d-mmm-yy).
When I use concatenate i get a result as : MS Excel 39745
After formatting the cell too d-mmm-yy, I get the sa
Hi,
Try this:
SUMPRODUCT(--(A2:A100="Ramesh")*(D2:D100))
Change the name as required, or type the desired name into a spare cell, eg H1,
and use:
SUMPRODUCT(--(A2:A100=H1)*(D2:D100))
Regards - Dave.
Date: Thu, 23 Oct 2008 12:14:28 +0530
From: [EMAIL PROTECTED]
To: excel-macros@googlegroups.com
Hi Ajit,
I understood what you want to say. Actually Column C contains remarks
entered by the operator for particular guarantee amount. It contains details
about margin %, commission% and timing of the collection. It is not
necessary that all the three elements will be present all togeth
I am working in Excel VBA. I need to write a custom Workdays
function. We are building houses. It does not matter what day we
start on (we can start on a Saturday or Sunday) and holidays do not
matter. The function will look like this:
function(D1 as date, i1 as integer) as date
The problem
Hi..
Why dont you replace % character from that column.Just replace the %
sign with space from cell.
On 10/23/08, SINGHAL, ATUL. <[EMAIL PROTECTED]> wrote:
>
> Hi Abhi,
>
> I think, the enclosed file can solve your problem.
>
>
> Regards
>
> CA. Atul Singhal
>
>
> -Original Message-
>
This will happen when your numbers are in text. If you can send me a
file with example i can try
Nishant
On Oct 23, 2:36 pm, [EMAIL PROTECTED] wrote:
> Hi All
>
> I'm trying to code a worksheet so that when I press a button, it sorts
> the column in numerical order. I have been using the code
>
>
You can do a pivot table or try the sumif function
Nishant
On Oct 23, 11:44 am, "Santhosh Kumar M K" <[EMAIL PROTECTED]> wrote:
> Dear Friends,
>
> Please, solve my problem
>
> Find the attached data..
>
> How to calculate total premium amount for a single personusing formula /
> functio
I have send you the solution on email.
Nishant
On Oct 23, 4:56 pm, "Nidhesh Dhawan" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I need to apply lookup for repetitive items, if I use normal vlookup, it
> returns the value with matches with the first record.
>
> Is there any way to get 1st value for
Attention Vinu
Here is the code:
Sub Macro1()
Dim sht
For sht = 1 To Sheets.Count
Sheets(sht).Activate
ActiveWindow.Zoom = 100
Cells.Select
With Selection.Font
.Name = "Arial"
.Size = 9
End With
Range("A1").Select
Next sht
Sheets(1).Activate
End Sub
___
Hi all,
I need to apply lookup for repetitive items, if I use normal vlookup, it
returns the value with matches with the first record.
Is there any way to get 1st value for 1st record and to skip that record
subsequenly.
The above problem is explained in the attached sheet.
P.S. Would prefer
Dear Friends,
Please, solve my problem
Find the attached data..
How to calculate total premium amount for a single personusing formula /
function?
*Agent Name*
*Month *
*Colleted Date*
*Premium amount*
Ramesh
Feb
2/8/2008
5,000.00
Satish
Feb
2/15/2008
15,000.00
Raju
Please unsuscribe me
--- On Thu, 23/10/08, Venkata Narayana <[EMAIL PROTECTED]> wrote:
From: Venkata Narayana <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
To: excel-macros@googlegroups.com
Date: Thursday, 23 October, 2008, 1:06 AM
Dear,
You can copy using formula
Hi Abhi,
I think, the enclosed file can solve your problem.
Regards
CA. Atul Singhal
-Original Message-
From: Abhijit Kanhegaonkar [mailto:[EMAIL PROTECTED]
Sent: October 22, 2008 9:44 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
Hey guys,
Whenever Excel is opened the following message appears in a small
message box: 7942F100: File Format is not valid. I don't remember
anything odd happening the last time I used Excel before the box
started appearing. Any idea why this started to appear?
--~--~-~--~~~
Hi All
I'm trying to code a worksheet so that when I press a button, it sorts
the column in numerical order. I have been using the code
Private Sub commandbutton12_click()
Range("A71:U1000").Select
Selection.Sort Key1:=Range("A71"), Order1:=xlAscending,
Header:=xlNo, _
OrderCustom:=1
20 matches
Mail list logo
