|
24-05-2012
12:50 PM BST
|
I think I see what you are looking for. In D1 I would type:
=sumproduct(($A$1:$A1=A1)*($B$1:$B1))+sumproduct(($A$1:$A1=A1)*($C$1:$C1))
Then copy it down.
I think that might do what you need.
Let me know how you get on.
>
> From: QT - ZOLU KICK
> <qtopic-27-tHAhkTQwWtmq@quicktopic.com>
> Date: 2012/05/23 Wed AM 09:06:59 BST
> To: QT topic subscribers <qtopic-subs@quicktopic.com>
> Subject: Help with Excel functions (www.meadinkent.co.uk)
>
>
< replied-to message removed by QT >
|
|
ZOLU KICK
23-05-2012
09:06 AM BST
|
Dear Ricahrd
Pls note belw,
A column is the "NAME" range like account A, B ......
B column is "Debit" range like currency
C column is "CREDIT" range like currency
D column is "BALANCE" range like formula (balance + debit - credit) assume opening balance is "0" when we put the formula D3 to D8 than its working correctly.
where
A3=A, A4=B, A5=A, A6=B, A7=A, A8=B
B4=10, B5=20, B8=5
C3=10, C6=15, C7=5
My question is that if we cover all above data in a excel table & select each name (A column) as filter than must be the only show balance of each name in balance column like A & excel not calculate the other name debit credit data/hide row record, Kindly assist with excel formula, Excel table subtotal provide me a result as I want in the bottom of table but we need each name record result at the balance column. Hope u understand.
With Best Regards,
________________________________
From: QT - Richard Burton <qtopic-27-tHAhkTQwWtmq@quicktopic.com> To: QT topic subscribers <qtopic-subs@quicktopic.com>
Sent: Tuesday, May 22, 2012 11:03 PM
Subject: Help with Excel functions (www.meadinkent.co.uk)
< replied-to message removed by QT >
|
|
Richard Burton
22-05-2012
07:03 PM BST
|
Sorry, I don't see what it is you need. Do you think you can give a clearer description?
Thanks
Richard
On Tue, 2012-05-22 at 07:30 +0000, QT - ZOLU KICK wrote:
< replied-to message removed by QT >
|
|
ZOLU KICK
22-05-2012
08:30 AM BST
|
Brother Richard
NAME DR CR BAL
A 10 -10
B 10 10
A 20 20
B 15 -15
A 5 -5
B 5 5
Need assistance on excel TABLE running balance Formula, As when I do select name A or B than must be balance show as (DR-CR) running criteria (Balance+DR-CR) for each name, Appreciate yr prompt reply.
|
|
Bob
15-04-2012
12:14 PM BST
|
Can anyone help me with a formula:
Cell to give value of deduction from pay when rate from £0 to £145 per wk.= Nil. Rate from £146 to £817 = 12% & from above £817 = 2%
Many thanks, Bob
|
|
hamish paterson
12-04-2012
11:20 AM BST
|
Sorry - just realised I used the wrong macro name in my posting @ 2499... should have been MakeHTM.
Hamish
|
|
hamish paterson
12-04-2012
06:24 AM BST
|
I solved my difficulty with the blank line at the top of the html table, using MakeHTM. Have made a number of other minor changes, and am left with the one final challenge - can a hyperlink on the excel spreadsheet be carried over into the html table? I've had a couple of tries at this, but don't feel like I'm getting close. Also inserted an 'if MyRow = 4' loop to try to draw top and bottom borders on that particular row, but no success. Any hints for either of these problems?
hamishp@ozemail.com.au
|
|
Bob
11-04-2012
04:21 PM BST
|
If you are still out there Richard, could I trouble you for another formula:
Cell to give value of deduction from pay when rate from £0 to £145 per wk.= Nil. Rate from £146 to £817 = 12% & from above £817 = 2%
Many thanks, Bob
|
|
hamish paterson
11-04-2012
03:27 AM BST
|
AM experimenting with your RangeToHTM macro, and can use it, with some modification, for my current project. Is it possible to avoid the blank row at the top of the file where the column widths are set? I would prefer to have the top line of my Excel worksheet as the top line of the html page. I've been mucking around with this but can't achieve what I want without losing the column width settings.
|
|
Bob
08-04-2012
01:43 PM BST
|
Thanks Richard, I'll give it a try. Kind regards, Bob
|
|
Richard Burton
07-04-2012
05:53 PM BST
|
Hi Bob,
I believe that this type of thing is possible. I've not really done it myself, though.
Depending on your variety of Excel it is something like, Data>Import>Web Enquiry. I'm not really familiar with it. Or there is subscription data for stock and shares available quite widely.
HTH
Richard
On Sat, 2012-04-07 at 16:03 +0000, QT - Bob wrote:
< replied-to message removed by QT >
|
|
Bob
07-04-2012
05:03 PM BST
|
Hi Richard. I've had a play and it seems very good, thank you. Can I ask another question. Is it possible to have an Excel spreadsheet, say for a stocks and shares portfoilo, which can link up to live stock market info online, and then update the spreadsheet with current prices. Best wishes, Bob
|
|
Bob
07-04-2012
02:21 PM BST
|
Thank you Richard, this is very helpful. I shall go and have a play. Thanks again, Bob
|
|
Richard Burton
06-04-2012
06:44 PM BST
|
Something like this?
=IF(Pay<25400,10500,IF(Pay>100000,MAX(0,8105-((Pay-100000)/2)),MAX(8105,10500-((Pay-25400)/2))))
I've not extensively tested this but seems to be close to the answer.
All the best.
Richard
On Fri, 2012-04-06 at 15:33 +0000, QT - Bob wrote:
< replied-to message removed by QT >
|
|
Bob
06-04-2012
04:33 PM BST
|
Can anyone provide a formula that returns a changing cell value for tax free pay under the following conditions:
The upper tax free allowance is say £10500 but the sum reduces by £1 for every £2 earned above £25,400 down to the standard tax free allowance of £8105.
Then the standard rate of £8105 reduces by £1 for every £2 earned above £100,000 down to £0
Thanks for any assistance
|
|
herco@iconnect.co.ke
31-03-2012
05:14 AM BST
|
In Word, there are the options in the table menu to 'auto fit contents to window'
Sent from my BlackBerry® smartphone from Zain Kenya
< replied-to message removed by QT >
|
New Topic
My Topics
Views:
34956
(Unique:
10045
) / Subscribers:
66 | What's this?
