Here's a function (TotalFee) that does what you describe. Take a look at
the attached file.
Tom
On Thu, Dec 4, 2008 at 6:26 AM, Ahmedhonest <[EMAIL PROTECTED]> wrote:
> Please find the attach file and suggest your valuable answers
>
> Expecting for a faster reply
>
> --
> Ahmed Bawazir
>
>
> >
Hi All,
Is there a way to count the number of characters selected within a
cell using a macro?
Thanks,
Sundar
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-mac
Hi...
I Have An Excel Query pls Help Me Out
I Have an Excel Sheet Which Contains 5 Columns; which seems to be
ABC
D E
Month Employee Date
Debit Credit
May XYZ 15/05/08
I have Ahmed It is very costly ebook.
On 12/5/08, Ahmedhonest <[EMAIL PROTECTED]> wrote:
>
> Manisha Kothari,
>
> find the file of excel short cut keys and for the rest of the answer i hope
> someone gives it
> Regards
> Ahmed
>
> On Thu, Dec 4, 2008 at 11:03 PM, Manisha Jain <
> [EMAIL PROTECTED]
Hi,
Could you please send me the raw data file?
Nagi
On Fri, Dec 5, 2008 at 6:44 PM, Raghuveer <[EMAIL PROTECTED]> wrote:
> Dear dev,
> I used IF condition, but it works upto only 6 or 8.
>
> I had a 100s of products and I have to pick up the rate from specified
> list.(By using vlookup function
Hi Dude,
Please find the attached file. May be it will useful for you.
Acknowledge the same by return mail.
*Unfeigned Regards
Manoj S Negi
**"Miles & miles to go before I sleep"
¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·
Hi Larry,
Try Using this formula instead.
=DATE(B4,B3,B2)-DATE(D4,D3,D2)
Cheers,
Lohith
On Dec 5, 12:51 am, larry <[EMAIL PROTECTED]> wrote:
> I am trying to creat a code for caculating the number of days between
> two dates. N=A-N causes a type mismacth run time error. Also looking
> for any
Before assigning variables values, use on error goto or on
error resume next.
When you use on error goto , you can stop executing further and
directly go to end giving some error information in msgbox, and when you use
on error resume next, the line with error will not be executed and the next
exe
Dear dev,
I used IF condition, but it works upto only 6 or 8.
I had a 100s of products and I have to pick up the rate from specified
list.(By using vlookup function).
Any way thanks for response...
Can you find any more good way..
Thanks
Raghuveer
--~--~-~--~~~---~
Hi,
Try these Array Formulas for Text, Numeric and AlphaNumeric
For Text & Alphanumeric
1) =SUM(IF(ISTEXT(A2:A13)=TRUE,D2:D13,0))
For Numeric Column
2) =SUM(IF(ISNUMBER(A2:A13)=TRUE,D2:D13,0))
Remember you need to add this formula using Ctrl+Shift+Enter.
Cheers,
Lohith
On Dec 4, 4:26 pm, A
Hi,
Try these Array Formulas for Text, Numeric and AlphaNumeric
For Text & Alphanumeric
1) =SUM(IF(ISTEXT(A2:A13)=TRUE,D2:D13,0))
For Numeric Column
2) =SUM(IF(ISNUMBER(A2:A13)=TRUE,D2:D13,0))
Remember you need to add this formula using Ctrl+Shift+Enter.
Cheers,
Lohith
On Dec 4, 4:26 pm, A
11 matches
Mail list logo
