A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 0.56 seconds.
Search: Posts made by: Russell Dawson[_2_]
Forum: General Discussion May 13th, 2010, 06:08 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 177
Accounting question

Thanks Gord,

As you have seen I did get it eventually. It good to have the figures
confirmed though.

Regards
--
Russell Dawson
Excel Student
Forum: General Discussion May 12th, 2010, 08:40 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 177
Accounting question

Done it.

The solicitor was deducting the value of the car and then adding in half
it's value before apportionment rather than apportionment after adding the
car value.
--
Russell Dawson
Excel...
Forum: General Discussion May 12th, 2010, 06:34 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 177
Accounting question

This is not an Excel question but I know there are experts here who I know
will provide an answer.

There is an estate of a deceased person to distribute.

Net value is £112k which includes the...
Forum: General Discussion May 10th, 2010, 05:32 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 170
Insert rows when data changes

Many thanks for the answers.


--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.
Forum: General Discussion May 10th, 2010, 03:26 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 170
Insert rows when data changes

In a column of periodically changing names in alphabetical order (col A) – I
need to insert a row after each change in initial letter. So when the names
have been sorted when the initial letter...
Forum: Worksheet Functions May 8th, 2010, 08:04 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 110
In Excel how do you rearrange a list of address's in alphaetical o

If the addresses are in a row culminating with the postcode a simple sort
will suffice.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"josstex" wrote:
Forum: Worksheet Functions May 1st, 2010, 08:02 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 135
IF function

Where do you get the forecast figures from?
With all the data available to you you must have info on the orders placed
each month. Can't those figures alone enable you to work out your FY...
Forum: Worksheet Functions April 27th, 2010, 07:51 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 179
How to?

Rebecca

You may need to explain a little more about your problem. I doubt whether
the price of Cookies is the only entry here.
If it is then
=IF(B4="cookies",1,"")
in C4 where cookies are $1. ...
Forum: General Discussion April 25th, 2010, 07:00 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 120
hiding rows

Filter column a where your zeroes appear. In 2007 this allows you to select
all(by default) then deselect zeroes in this case which should give you the
desired result. Can't remember whether 2003...
Forum: Worksheet Functions April 24th, 2010, 06:48 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 148
How do I use a percentage formula?

I don't think that MeursaultO was meaning what percentage of the total column
each constituent part is.

He asks what percentage of 14,500,698 "in a given cell" each entry is.

The total of the...
Forum: Worksheet Functions April 18th, 2010, 03:32 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 22
Views: 563
Validation of UK VAT Number

Thanks Ron.

I'll sleep easy tonight.

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.
Forum: Worksheet Functions April 18th, 2010, 07:39 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 22
Views: 563
Validation of UK VAT Number

That's fine. It tells you the format i.e. 9 or 12 digits and the 3-4-2
format is no secret. It couldn't be as all businesses have to display it in
invoices etc.

What it doesn't give is the series...
Forum: Worksheet Functions April 17th, 2010, 04:42 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 22
Views: 563
Validation of UK VAT Number

Rob
Whilst this has been a very interesting discussion from an XL viewpoint I
can't understand why you need to do this.
Can't you just telephone the HMRC helpline? They will advise if the...
Forum: General Discussion April 16th, 2010, 06:49 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 153
Search for my questions in 2010

Click on your name in the post and then recent posts. I can see 8 posts in
2010 by you.

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.
Forum: General Discussion April 16th, 2010, 04:37 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 158
Calculation Problem

=F5/I5*60
Duration is in minutes
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Norm" wrote:
Forum: General Discussion April 15th, 2010, 10:07 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 158
Calculation Problem

The average per hour would be F5/I5 but where does the "standard number" in
G2 come in. What is it? How does it effect your calculation?
--
Russell Dawson
Excel Student

Please hit "Yes" if this...
Forum: General Discussion April 14th, 2010, 05:06 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 62
formula needed

.. . . and a portion is . . . ?
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"mothertucker" wrote:
Forum: General Discussion April 13th, 2010, 05:04 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 73
How to set a few columns on a worksheet which can be edited by ot

See Excel Help on your spreadsheet. Search
Unlock specific areas of a protected worksheet
You will prompted to enter a password so only you can change the locked
cells but your colleagues can edit...
Forum: General Discussion April 13th, 2010, 04:22 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 113
Insert Rows

It's probably formatted cells that extend beyond the data in your w/sheet.
You may have coloured whole rows/columns.
Figure out the last row of data you're using and delete all of the
formatting...
Forum: General Discussion April 12th, 2010, 06:07 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 104
Allocate payments

Paul

Thanks for that. It's not working for me. I'd done the calc manually and
doesn't match. I did make a mistake in my original posting - I put B2
instead of A2 in my example but you would...
Forum: General Discussion April 12th, 2010, 04:19 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 104
Allocate payments

I am breaking an unwritten rule by re-asking a question but the first time
was late on Friday and has become lost and ignored over the weekend. At
least that's what I hope as I'm sure there is a...
Forum: Worksheet Functions April 11th, 2010, 02:54 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 124
date Concatenation

Please try to give a fuller explanation of what it is you are doing.

Data origin/destination. Reasons. Examples. Etc.

The more info you can give the easier it will be to assist.
--
Russell...
Forum: Worksheet Functions April 11th, 2010, 02:19 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 124
date Concatenation

That's because the CONCATENATE formula joins two text strings together.
The result you are getting is converting the date 10/09/2009 (UK) into text.
Perhaps you should approach from another...
Forum: General Discussion April 9th, 2010, 07:10 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 62
vba or excel help

You're welcome. Please tick Yes if I was helpful.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"jcheko" wrote:
Forum: General Discussion April 9th, 2010, 06:41 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 62
vba or excel help

You might get what you want by searching the Help - input 2Track changes in a
shared workbook"

I don't think yours is shared but it may help you.

Good luck

Cheers
--
Russell Dawson
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 12:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.